Microsoft Excel Level 3
Hours: 6.00 | Estimated Cost: $219.00
Learn more specialized and advanced capabilities of Microsoft® Excel®. You will learn about some of the more advanced features of Excel, including advanced data analysis, collaboration on workbooks with other users and automating workbook functionality. Prerequisite: Microsoft Excel 2016 - Level 1 & 2 or equivalent knowledge/experience.
Additional Information
-
Learn About
* Working with Multiple Worksheets and Workbooks
* Using Lookup Functions and Formula Auditing
* Sharing and Protecting Workbooks
* Automating Workbook Functionality
* Creating Sparklines and Mapping Data
* Forecasting Data
-
Benefits & Outcomes
* Improve productivity by allowing mundane tasks to be completed more efficiently
* Learn valuable tips and tricks to improve efficiency and accuracy
* Become proficient in Microsoft Excel
-
Training Outline
**Working with Multiple Worksheets and Workbooks**
* Use Links and External References
* Use 3-D References
* Consolidate Data
**Using Lookup Functions**
* Using Lookup Functions (VLOOKUP, MATCH and INDEX)
**Sharing and Protecting Workbooks**
* Collaborate on a Workbook
* Protect Worksheets and Workbooks
**Automating Workbook Functionality**
* Apply Data Validation
* Search for Invalid Data and Formulas with Errors
* Work with Macros
**Creating Sparklines and Mapping Data**
* Create Sparklines
* Map Data