Course Overview
This 1-day, instructor-led course provides advanced tools for solving real-world problems in MS Excel 2016. You will learn:
- Logical and lookup functions
- Advanced formulas
- Special functions
- Importing and exporting
- Analysis
- Macros and forms
Schedule
Microsoft Excel 2016 Advanced Training
date
location
3/31/21 - 3/31/21 (1 days)
8:30AM - 4:30PM EST
Online
Sold Out5/05/21 - 5/05/21 (1 days)
8:30AM - 4:30PM EST
Online
Sold Out5/07/21 - 5/07/21 (1 days)
8:30AM - 4:30PM EST
Online
Open5/07/21 - 5/07/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open5/07/21 - 5/07/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open5/27/21 - 5/27/21 (1 days)
8:30AM - 4:00PM GMT+1
Stuttgart, Germany
Sold Out7/09/21 - 7/09/21 (1 days)
8:30AM - 4:30PM EST
Online
Open7/09/21 - 7/09/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open7/09/21 - 7/09/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open8/18/21 - 8/18/21 (1 days)
8:30AM - 4:30PM EST
Online
Sold Out9/10/21 - 9/10/21 (1 days)
8:30AM - 4:30PM EST
Online
Open9/10/21 - 9/10/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open9/10/21 - 9/10/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open11/24/21 - 11/24/21 (1 days)
8:30AM - 4:30PM EST
Online
Open11/24/21 - 11/24/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open11/24/21 - 11/24/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open![[image]](https://phoenixts.com/wp-content/themes/phoenixts-com/assets/images/temp/image-9@2x.jpg)
Not seeing a good fit?
Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.
Learn more about custom training
Course Outline
Logical and Lookup Functions
- Decision-making functions
- Lookup and reference functions
Advanced Formulas
- Auditing and error-trapping
- Formula options
- Arrays
Special functions
- Date and time functions
- Text functions
- Other functions
Importing and Exporting
- The Power Pivot Data Model
- Exporting data
Analysis
- What-if analysis
- The Analysis Toolpak
Macros and Forms
- Recording macros
- Running macros
- Forms