For individuals who need to analyse or manipulate data for reporting purposes. This course is ideal for anyone wanting to expand their knowledge of Excel
To become faster and more confident analysing data with Pivot Tables and other useful analytical tools.
Understand the best way to arrange data in a spreadsheet?
Finding and fixing inputting errors
Understand Pivot Fields and lists
Use Pivot tables to summarise & analyse data
Format, Layout and Design Options
Summarise field settings – Average, Count, Sum
Inserting Calculated Fields, Using grouped dates
Copy and Paste Visible Cells
Insert and edit Pivot Chart
Inserting Slicers & Timelines
Use the subtotal function to calculate subtotals
3 hours with lots of hands-on practical exercises
All training spreadsheets for future practice & full colour booklet to accompany the lesson
£435 Maximum 8 delegates
£54 per additional delegate
Fill out the form below to discover how ALX Training can help you:
Or talk to us directly...
+44 1534 873785
+44 7797 774676