Manage Workbook Options and Settings 

Create Worksheets and Workbooks

• Creating new workbooks 
• Saving workbooks 
• Closing workbooks 
• Opening workbooks 
• Selecting cells 
• Import data 
• Add a worksheet to an existing workbook 
• Copy and move a worksheet

Navigate in Worksheets and Workbooks

• Search for data within a workbook 
• Navigate to a named cell, range, or workbook element
• Insert and remove hyperlinks 

Format Worksheets and Workbooks

• Rename a worksheet 
• Change worksheet order and colour
• Insert and delete columns or rows 
• Change workbook themes 
• Adjust row height and column width 
• Insert headers and footers

Customise Options and Views for Worksheets and Workbooks

• Hide or unhide worksheets 
• Hide or unhide rows and columns 
• Customise the Quick Access toolbar 
• Modify document properties 
• Display formulas 

Configure Worksheets and Workbooks for Distribution 

• Inspect a workbook for hidden properties or personal information
• Inspect a workbook for accessibility and compatibility issues

Apply Custom Data Formats and Layouts

Apply Custom Data Formats and Validation

• Create custom number formats 
• Populate cells by using advanced Fill Series options
• Configure data validation 

Apply Advanced Conditional Formatting 

• Create custom conditional formatting rules 
• Create conditional formatting rules that use formulas
• Manage conditional formatting rules 

Data Filtering

• Using AutoFilters 
• Applying a custom AutoFilter
• Creating advanced filters
• Applying multiple criteria 
• Using complex criteria
• Copying filtered results to a new location 
• Using database functions

Create and Modify Custom Workbook Elements 

• Create and modify simple macros 
• Insert and configure form controls

Auditing Worksheets 

• Tracing precedent and dependent cells 
• Tracing errors 
• Cell Validation

Create Tables

Create and Manage Tables

• Create an Excel table from a cell range 
• Convert a table to a cell range 
• Add or remove table rows and columns

Manage Table Styles and Options

• Apply styles to tables
• Configure table-style options
• Insert total rows 

Filter and Sort a Table

• Filter records 
• Sort data by multiple columns 
• Change sort order 
• Remove duplicate records

Perform Operations with Formulas and Functions

Summarise Data by using Functions

• Perform calculations by using the SUM function
• Perform calculations by using MIN and MAX functions
• Perform calculations by using the COUNT function
• Perform calculations by using the AVERAGE function 

Perform Conditional Operations by using Functions

• Perform logical operations by using the IF, SUMIF and AVERAGEIF functions
• Perform statistical operations by using the COUNTIF function 

Format and Modify Text by using Functions 

• Format text by using RIGHT, LEFT, and MID functions
• Format text by using UPPER, LOWER, and PROPER functions 
• Format text by using the CONCATENATE function