Udemy

Ultimate Microsoft Excel 2016 Course - Beginner to Expert

Enroll Now
  • 2,735 Students
  • Updated 3/2024
  • Certificate Available
4.4
(151 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
23 Hour(s) 47 Minute(s)
Language
English
Taught by
Simon Sez IT
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.4
(151 Ratings)
1 views

Course Overview

Ultimate Microsoft Excel 2016 Course - Beginner to Expert

18 Hours of Training. The Most Convenient Way to Boost Your Confidence And Learn MS Excel 2016 Inside And Out—Quickly

Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle  

  • Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course  

  • Includes 18 hours of high-quality training by your professional trainer  

  • Practice along using exercise files  

  • Watch and learn with demo project files  

  • Progresses logically from beginning with an easy intro to advanced topics  

  • Learn to Create Charts and Graphs  

This bundle includes:  

  • 2 complete courses  

  • 18 hours of video tutorials  

  • Over 100 individual video lectures  

  • Exercise files to practice what you learned  

  • Demo files used by the trainer  

  • Printable course transcriptions to follow along and take notes

  • Certificate of completion  

Contents and Overview for the 9-Hour Excel 2016 Beginner Course  

This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user.  

It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them.  

You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.  

Upon completion of this course you will know the essentials of Microsoft Excel 2016.  

Contents and Overview for the 9-Hour Excel 2016 Advanced Course  

Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.  

Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more.  

Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.  

* Includes quizzes, exercise files, demo files and certificate of completion.

** Updated June 2017. Course transcripts now available.



Here’s what our students are saying…


"I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .”
- Tomáš Seiner

"The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!"
- Ontavus Thomas

"Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir"
-
Jessica Henry


Did you know?


Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!


Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.


Course Content

  • 49 section(s)
  • 139 lecture(s)
  • Section 1 Excel 2016: Introduction to Excel 2016 Beginner Course
  • Section 2 Excel 2016: What's New
  • Section 3 Excel 2016: Using Touch
  • Section 4 Excel 2016: Getting Started
  • Section 5 Excel 2016: Using Help
  • Section 6 Excel 2016: Excel Options
  • Section 7 Excel 2016: The Ribbon and Toolbars
  • Section 8 Excel 2016: Entering and Editing Data
  • Section 9 Excel 2016: Backup and Recovery
  • Section 10 Excel 2016: Fill and Series
  • Section 11 Excel 2016: Viewing and Printing
  • Section 12 Excel 2016: Cut, Copy, and Paste
  • Section 13 Excel 2016: Formatting a Worksheet
  • Section 14 Excel 2016: Formulas and Functions
  • Section 15 Excel 2016: Managing Worksheets
  • Section 16 Excel 2016: Working with Multiple Workbooks
  • Section 17 Excel 2016: Saving Workbooks
  • Section 18 Excel 2016: Proofing
  • Section 19 Excel 2016: Inserting Comments
  • Section 20 Excel 2016: Basic Functions in Excel
  • Section 21 Excel 2016: Graphs and Charts
  • Section 22 Excel 2016: Sorting and Filtering Data
  • Section 23 Excel 2016: Shapes and Pictures
  • Section 24 Excel 2016: Formatting Cells Based on Content
  • Section 25 Excel 2016: Protection and Security
  • Section 26 Excel 2016: Naming Items
  • Section 27 Excel 2016: Finding and Replacing Words
  • Section 28 Excel 2016: Borders
  • Section 29 Excel 2016: Workbook Inspection
  • Section 30 Excel 2016: Privacy Options
  • Section 31 Excel 2016: Sharing Options
  • Section 32 Excel 2016: Wrap Up
  • Section 33 Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course
  • Section 34 Excel 2016 Advanced: Functions
  • Section 35 Excel 2016 Advanced: Date and Time Functions
  • Section 36 Excel 2016 Advanced: Text Functions
  • Section 37 Excel 2016 Advanced: Logical Functions
  • Section 38 Excel 2016 Advanced: Lookup Functions
  • Section 39 Excel 2016 Advanced: Financial Functions
  • Section 40 Excel 2016 Advanced: Statistical Functions
  • Section 41 Excel 2016 Advanced: Connecting to External Data
  • Section 42 Excel 2016 Advanced: Tables
  • Section 43 Excel 2016 Advanced: Pivot Tables
  • Section 44 Excel 2016 Advanced: Data Analysis
  • Section 45 Excel 2016 Advanced: Graphs and Charts
  • Section 46 Excel 2016 Advanced: Excel Web App
  • Section 47 Excel 2016 Advanced: Conclusion
  • Section 48 Extras
  • Section 49 Additional Training

What You’ll Learn

  • Discover new and improved features in Excel 2016.
  • How to effectively use Excel 2016 on a touchscreen device.
  • How create, save, and open a workbook.
  • Learn how to personalize your use of Excel using Excel Options.
  • How to use and how to customize the Quick Access Toolbar.
  • Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • The basics of entering and editing data in a workbook.
  • Discover how to format dates and numbers.
  • Learn practical methods in which you can backup and recover your Excel spreadsheets.
  • Effectively use autofill and flashfill so you are more productive.
  • Discover the essentials of using fomulas and functions.
  • How to rename, insert, move, and reference an Excel 2016 worksheet.
  • Discover how to create charts and graphs
  • Learn practical methods to sort and filter your data
  • How to protect and secure your Excel data
  • Working with dates and times
  • Averages, percentiles, and LINEST functions
  • Calculating depreciation
  • Using financial functions to determine payments
  • Sparklines and data bars
  • How to import and export data to and from Excel
  • Create and effectively use pivot tables
  • How to use Excel for data analysis
  • Discover practical methods for financial & statistical​ Functions
  • Practice what you learned with included exercise files


Reviews

  • K
    Kowou D. Kowou
    4.0

    Detailed and many examples

  • P
    Patricia Bono
    4.5

    Yes, this is exactly what I was looking for!

  • S
    Scott Carico
    4.0

    Very good course for the beginner.

  • D
    Daniel Lambert
    4.5

    Easy to follow. The instructor has a clear and understandable style. Does not make any assumptions about your knowledge.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed