Microsoft Excel - Manage Your Data - Half day course

Description

This course is for PA’s; Administrative Assistants; Virtual Assistants; Office
Managers and anyone uses Excel as a database for lists or calculations.

Attendees must be confident adding text and numbers to Excel and be able to do
basic calculations.

By the end of the course you will be able to sort and filter data so that you can
focus on the information you wish to get out of Excel.

What you will learn

The Ribbon and Quick Access Toolbar
Setting up the spreadsheet for data
What is a list?
Sorting
Filtering
Format as a table
Calculated fields
Conditional Formatting
Subtotals
Introducing Pivot Tables