Loading...

Course Description

CLICK HERE TO REGISTER

If you work with numbers, you need to master Microsoft Excel 2016! This hands-on course will teach you dozens of shortcuts and tricks for setting up fully-formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.

In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. You will also learn Excel 2016 features, including Quick Analysis, Flash Fill, and new charting capabilities.

This is not a tutorial, but an in-depth class. By the time you're done, you will be using this vital Office 2016 application like a pro.

Syllabus

  • Lesson 1 - Excel Basics
  • Lesson 2 - Creating a Worksheet
  • Lesson 3 - Time-Savers
  • Lesson 4 - Relative, Absolute, Mixed, and Circular References
  • Lesson 5 - Three Dimensional Workbooks
  • Lesson 6 - Sorting, Subtotaling, and Filtering
  • Lesson 7 - Charting Basics
  • Lesson 8 - Advanced Charting Techniques
  • Lesson 9 - Intro to Excel's Statistical Functions
  • Lesson 10 - Financial Functions
  • Lesson 11 - Worksheet Automation
  • Lesson 12 - Mastering Excel's IF Function
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .