Microsoft Excel Intermediate

Recap exercise on Absolute Cell Referencing

Working with tables

• Creating a table
• Adding and removing data
• Working with the total row
• Sorting a table
• Filtering a table
• Removing duplicate rows of data
• Formatting the table
• Using data validation
• Converting to a range

Managing workbooks

• Using workbook views
• Selecting and switching between worksheets
• Inserting and deleting worksheets
• Creating headers and footers
• Hiding rows, columns, worksheets, and windows
• Setting the print area
• Printing a selection, multiple worksheets, and workbooks
• Creating a template
• Protecting a workbook
• Working with data ranges

Working with pivot tables

• Creating a pivot table
• Specifying pivot table data
• Changing a pivot table’s calculation
• Working with pivot table layout
• Grouping pivot table items
• Updating a pivot table
• Creating a pivot chart
• Using slicers

Getting started with worksheets

• Choosing and selecting the source data
• Choosing the right chart
• Inserting a chart
• Editing, adding, and removing chart data
• Changing chart data
• Using sparklines

More functions & formulas

• Formulas with multiple operators
• Inserting and editing a function
• AutoCalculate and manual calculation
• Defining names
• Using and managing defined names
• Displaying and tracing formulas
• Understanding formula errors
• Using logical and lookup functions such as IF and VLOOKUP