How to use Excels tools to quickly retrieve, view and summarise information in numerous ways.
Microsoft Excel is great for storing and organising your data, but it can be time-consuming and frustrating to find the information you need.
This workshop will show you how to use Excel's powerful tools to quickly retrieve, view and summarise information in numerous ways.
Join Karen for a lively mix of demonstrations and business examples and practice what you've learned at your own pace in your own time.
The course includes access to a month's free support on any of the topics learned.
What will be covered?
Ensure accurate data entry using data validation
Use time-saving filters
Visually explore and analyse data using conditional formatting
Create interactive filters in PivotTables
Present your information as a chart
Dos and don'ts when working with data
Learn numerous time-saving tricks and shortcuts
|Duration: 90 mins
|Time: 10am - 11.30am
||Member Cost: £40+VAT
||Non-member Cost: £60+VAT