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® 2019 - 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