Excel has an awesome collection of tools that you can use to summarise and analyse large lists of data. Apply your learnings from our Excel Summarise and Analyse Data manual and you'll impress your bosses or clients with worksheets what show is really happening in their business. The manual has sections on:
- Acquiring and preparing data
- Summarising data with formulas
- Summarising data with subtotals, tables and lookup functions
- Summarising data with pivot tables
- Creating charts with a secondary axis
All of our In the Office
manuals have practise tasks give you the chance to use the features showcased in that particular manual. Most of the practise tasks require "master files".
You can download the master files
that accompany this manual at any time.