Excel 2013 Level 3

Microsoft® Office Excel® 2013: Part 3

Course Length: 1 day

Course Content:

Chapter 1: Logical and Lookup Functions
Module A: Decision-making functions
Module B: Lookup and reference functions

Chapter 2: Advanced Formulas
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: External data
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