By Neil Shorney, Director, Naturally Sales Ltd.
Pivot tables are a great way to present complex data in a flexible way. Select your data, then click Insert-Pivot table. You can then build your pivot table quickly and easily. For more permanent and nicely-presented reports, such as a dynamic dashboard, it's better to use formulas to interpret your data which will update as new data is added.
We look at this in more detail in Advanced Microsoft Excel. Alternatively, we can customise training to your needs and include your own spreadsheets as exercises.
No comments:
Post a Comment