About this course
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
Recent reviews
great training
I had quite a good knowledge of Excel in the first instance so a lot of the items covered I already knew. However, i did learn a few new shortcuts and discovered pivot tables
It would have been good to have some pointers on how to use excel on macs as the majority of the room were working off macs which slowed down the session and meant mac users weren't able to learn as many shortcuts like the 2 PC users in the session.