Excel 2016 Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel 2016: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. The three levels of our Excel 2016 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course.
Chapter 1: Logical and Lookup Functions
- Module A: Decision-making functions
- Module B: Lookup and reference functions
Chapter 2: Advanced Formula
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
Chapter 3: Special functions
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
Chapter 4: Importing and Exporting
- Module A: The Power Pivot Data Model
- Module B: Exporting data
Chapter 5: Analysis
- Module A: What-if analysis
- Module B: The Analysis Toolpak
Chapter 6: Macros and Forms
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
Appendix A: Internationalization and Accessibility
- Preparing workbooks for internationalization and accessibility
Need to request this course on a Different Day?
LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Excel Advanced, 5/20/20 , Centene"Several participants were struggling at the beginning and Titus was amazing with picking up on that the best way to get us moving was to have them share their screens so they could get caught up. Even though we were on Zoom, Titus made it feel personal. He regularly used our names and made most of us comfortable being on our cameras even though we were reluctant at first."