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