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