Microsoft Office Excel 2016 Advanced Training Course
Microsoft Excel 2016 - Level 3
Course Number: |
#CED-1500 |
Course Length: |
1 day |
Grants (discounts) are available for multiple students for the same or different courses. |
Upcoming Dates |
Class Times |
Class Format |
Quote |
Call (800) 611-1840 for Class Schedule |
Instructor-Led
- Certified Instructor
- Includes all course materials
In this course, you will become familiar with advanced features and functionality of Microsoft Excel 2016.
Course Content
Lesson 1: Logical and Lookup Functions
- Decision-making functions
- Lookup and reference functions
Lesson 2: Advanced Formulas
- Auditing and error-trapping
- Formula options
- Arrays
Lesson 3: Special functions
- Date and time functions
- Text functions
- Other functions
Lesson 4: Importing and Exporting
- The Power Pivot Data Model
- Exporting data
Lesson 5: Analysis
- What-if analysis
- The Analysis Toolpak
Lesson 6: Macros and Forms
- Recording macros
- Running macros
- Forms
CED Solutions is your best choice for Excel 2016 Level 3,
Excel 2016 Level 3 training,
Excel 2016 Level 3 certification,
Excel 2016 Level 3 boot camp,
Excel 2016 Level 3 certification training,
Excel 2016 Level 3 certification course,
Excel 2016 Level 3 course,
Excel 2016 Level 3 class.
|
Follow CED