ADVANCED - PIVOT TABLES, TABLES, GRAPHS AND CREATING VISUAL REPORTS

Sometimes it is easier to understand something when it is represented in pictures or some other visual medium. This also helps when making decisions, analysing trends and reviewing results. Excel is bursting at its seams with all kinds of techniques to visually represent data in a way that is organised and easier to digest. Numbers can be a bit overwhelming sometimes, so join us as we explore various ways numbers/data can be organised and simplified by converting them into graphs, tables and other visual reports to help with decisions.

The objective of this session is to enable delegates to become comfortable with using visual aids within Excel and turn copious amounts of data into a visual expression, so as to perform better decision making. To achieve this, we will cover the following:

· Tables and Graphs

o Quick analysis

o Pivot tables

o Charts.

All individuals who make use of Microsoft Excel as part of their daily work duties in the capacity at receptionist or other administrative area, or who are involved in various finance fields including auditing, accounting, taxation and financial management as well as individuals who prepare reports and need to be able to edit text and numbers, will benefit from attending 1 or more of these sessions.