You know how to use Microsoft Excel to perform simple calculations and modify your workbooks and worksheets to make them easier to read, interpret, and present to others. However, Microsoft Excel is capable of doing so much more. With this course, you can extract actionable organizational intelligence from your raw data to crunch the numbers when needed.
Learning Objectives »
- Work with functions.
- Work with lists.
- Analyze data.
- Visualize data with charts.
- Use PivotTables and Pivot Charts.
Course Agenda
Working with Microsoft Excel Functions
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date & Time Functions
- Work with Text Functions
Working with Microsoft Excel Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Analyzing Data
- Create and Modify Tables
- Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Used Advanced Chart Features
Pivot Tables and Pivot Charts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data Using Timelines and Slicers
