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