Course Details
Course Outline
1 - Working with Functions
Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions
2 - Working with Lists
Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data
3 - Analyzing Data
Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting
4 - Visualizing Data with Charts
Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features
5 - Using PivotTables and PivotCharts
Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Prerequisites
Other Prerequisites
To ensure success, students should have completed Logical Operations’ Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 or have the equivalent knowledge and experience.