Microsoft Excel Level 3

Hours: 6.00 | Estimated Cost: $179.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

Share Your Needs

Information Request (check all that apply - your information is private)
Areas of Interest (check all that apply)

(e.g., MS Excel on-site)

Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771