Course length: 2-days
Course Overview
This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.
Prerequisites
To be successful in this course, you should have completed Excel Level 1 or have equivalent knowledge.
Outline
Creating Advanced Formulas
- Cell References
- Working with Named Ranges
- Formula Auditing
Analyzing Data with Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Date Functions
- Protecting Worksheets
Organizing Worksheet Data with Tables
- Create and Format Tables
- Total Row
- Removing Duplicates
- Table References
Analyzing Data with Data Tools
- Data Validation
- Advanced Filter
- Conditional Formatting with Rules
- Database Functions
- Subtotal Functions
Visualizing Data with Charts
- Selecting appropriate charts for data
- Modify and format various charts
Introduction to PivotTables
- Create basic PivotTables
- Sort and Filter PivotTables
- Insert PivotCharts and Slicers
Working with Graphical Objects
You may also be interested in:
Excel - Data Analysis and Forecasting
What's Next?
View our Excel Flowchart
Certification
Before testing you will need:
Is Level 2 right for you?
Try our self-assessment