If you have a lot of data, manual editing and formatting of cells isn't an option anymore. However, Excel
provides you many group operations that make those manipulations quick and easy.
Using simple tricks, you can convert your Excel spreadsheet from a table with rows and columns to an
interactive application that will help you to represent the data more appealingly and conveniently.
To make your data more information, you can combine different chars in many ways.
Gantt charts illustrate project schedules and, thus, often used by project managers. Project management
tools like Microsoft Project are better suited for Gantt charts, but it is easy to create a Gantt chart in
Excel following the simple steps.
Several different Excel features can make your presentation less boring:
The default installation of Excel has reasonable presets for chart types and colors, but you can change those
defaults according to your own preferences.
Excel is heavily used by all Microsoft Office users and automatically opened workbooks, customizations of
the menu, recent documents, and start screen allow you to save a lot of time.
There are several useful features in Excel that can help to create your charts, which automatically change
visual appearance depending on data.
For some presentations will be interesting to add a title that contains changeable data, for example,
dependent on volume:
For some presentation of the competition will be more informative to see points that missed to achieve the
Goal. This tip is about how to create a simple competition chart with residual data.