- 15 Dec 2021 (Wed) - 4 Feb 2022 (Fri) 12:00 PM
- 12 Jan 2022 (Wed) - 4 Mar 2022 (Fri) 12:00 PM
($300 Cash rebate upon successful completion)
Learn to quickly and efficiently use Microsoft Excel 2016 and discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro!
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.
What You’ll Learn
• Excel Basics
• Creating a Worksheet
• Time-Savers, Tips & Tricks
• Relative, Absolute, Mixed, and Circular References
• Three Dimensional Workbooks
• Sorting, Subtotaling, and Filtering
• Charting Basics
• Advanced Charting Techniques
• Intro to Excel's Statistical Functions
• Financial Functions
• Worksheet Automation
• Mastering Excel's IF Function