Microsoft Excel Level 2 – Office 2016/Office 365
Take your Microsoft Excel skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Excel at an intermediate level. You will learn how to work with additional Excel features including: advanced formulas, tables, charts and PivotTables and PivotCharts.
2 Days
Microsoft Excel
7 PDUs
Personal Development Unit
MS Excel Level 2 – Intermediate
WORKING WITH FUNCTIONS
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date & Time Functions
- Work with Text Functions
WORKING WITH LISTS
- Sort Data
- Filter Data
- Query Data with Database Functions
- 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
Workshop Wrap-Up
At the end of the course, students will have an opportunity to ask questions.
