Microsoft Excel Level 2

Hours: 6.00 | Estimated Cost: $179.00

Use Microsoft® Excel® to create advanced formulas and organize your data into tables. Discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons. Prerequisite: Microsoft® Office Excel® 2016 - Level 1 or equivalent knowledge/experience.

    Additional Information

  • Learn About
    • Working with Functions
    • Working with Lists
    • Analyzing Data
    • Visualizing Data with Charts
    • Analyzing data with PivotTables and Pivot Charts

  • 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 Functions**

    • Work with Ranges
    • Use Specialized Functions
    • Work with Logical Functions
    • Work with Date and Time Functions
    • Work with Text Functions

    **Working with Lists**

    • Sort Data
    • Filter Data
    • Outline and Subtotal Data

    **Analyzing Data**

    • Create and Modify Tables
    • Apply Intermediate Conditional Formatting
    • Apply Advanced Conditional Formatting

    **Visualizing Data with Charts**

    • Create Charts
    • Modify and Format Charts
    • Use Advanced Chart Features

    **Analyzing Data with PivotTables and PivotCharts**

    • Create a PivotTable
    • Analyze PivotTable Data
    • Present Data with PivotCharts
    • Filter Data by using Timelines and Slicers


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