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® - Level 1 or equivalent knowledge/experience.

    Additional Information

  • Learn About
    * Working with Functions
    * Working with Lists
    * Analyzing Data
    * Analyzing data with PivotTables and Pivot Charts
    * Visualizing Data with 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
Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

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