Advanced Excel

Create worksheets and workbooks

Prepare workbooks for collaboration

Navigate in worksheets and workbooks

Format worksheets and workbooks

Customize options and views for worksheets and workbooks

Format cells and ranges

Insert data in cells and ranges

Fill cells based on existing data

Apply advanced conditional formatting and filtering

Summarize and organize data

Format and validate data

Create and manage tables

Manage table styles and options

Filter and sort a table

Summarize data by using functions

Perform data analysis

Perform conditional operations by using functions

Format and modify text by using functions

Perform logical operations in formulas

Look up data by using functions

Use advanced date and time functions

Troubleshoot formulas

Create and modify advanced charts

Create and modify PivotTables

Create and modify PivotCharts

Create and modify simple macros