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