Skill

Microsoft Excel 2016

August 2016 with Simona Millham

  • Entry
  • 33 videos
  • 7 hrs 1 min
This Microsoft Excel 2016 training course with Simona Millham will teach you fundamental and advanced spreadsheet skills. With real-world examples taken from a business environment, you'll learn about number formats, data visualization, PivotTables, What-If Analysis, Forecasting, 3D maps, and more.

Learners who are new to using Microsoft Excel will benefit from working through this course from the beginning, while experienced learners may find it more advantageous to jump into the Nuggets they find most valuable.

Recommended Experience
  • Some familiarity with Microsoft Windows
Recommended Equipment
  • Computer running Windows 7 or later
  • Any edition of Microsoft Office 2016 or an Office 365 plan which includes Microsoft Office. (Note: Excel 2016 acquired through the home editions of Office 2016 or Office 365 has slightly reduced functionality. This will be highlighted during the course.)
Related Certifications
  • None
Related Job Functions
  • Any
Simona Millham has been a CBT Nuggets trainer since 2015 and holds a variety of Microsoft certifications, including Microsoft Office Master, and Microsoft Certified Professional qualifications in Licensing and Software Asset Management.
Get started
Simona Millham
Simona Millham
Trainer

Skill Outline

  1. 1. Overview (0:19)
  2. 2. Introduction (5:59)
  3. 3. Find Your Way Around and Get Help (10:49)
  4. 4. Creating Your First Spreadsheet (15:30)
  5. 5. Calculations (15:57)
  6. 6. Managing Files (13:16)
  7. 7. Number Formats (14:40)
  8. 8. Data Visualization (11:44)
  9. 9. Getting Started with Excel Functions (16:04)
  10. 10. More Excel Functions (16:05)
  11. 11. Create Your Own Excel Function (9:12)
  12. 12. Page Layout (13:36)
  13. 13. Get Started with Charts (12:11)
  14. 14. Do More with Charts (13:42)
  15. 15. Explore the Excel Chart Types! (13:15)
  16. 16. Protecting Workbooks (10:15)
  17. 17. Data Validation for Good Quality Data (12:09)
  18. 18. Analyzing Data with PivotTables (16:18)
  19. 19. Connecting to Data Sources (11:15)
  20. 20. Introduction to Power Pivot (13:48)
  21. 21. Interactive Reports with Power View (9:05)
  22. 22. Excel Forecasting (12:34)
  23. 23. Excel 3D Maps (12:19)
  24. 24. Adding Graphics to Your Spreadsheets (10:19)
  25. 25. Customizing Your Workspace (9:10)
  26. 26. Introduction to Excel Macros (13:42)
  27. 27. Conclusion (0:04)

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Accountability Coaching

Define your goals and stick to a training plan with help from our coaches.

Learn this skill and so much more!

Get started

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT
Read Reviews
Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2025 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522