|
Training Index
Power Courses index
Reporting on data in Microsoft Excel
|
|
|
Excel is often used to report on data. The best reporting tool in Excel
is the Pivot Tables and Conditional Formatting. To get this far you should
have knowledge on Cleaning up
Data and Manipulating
Data which are available as short tutorials on the linked pages. In all courses we have assumed that
you have been through our basics
course. |
Be aware that these video clips use Windows Media Player. Click on the
hyperlink and, depending on your connection speed, you may need to wait a
few moments.
| Title |
Price
|
Video
Clip
(Windows Media Player) |
Pivot Tables
Pivot Tables must rate as one of the best tools in Excel. If the
data is set up correctly, there is almost a limitless number of
reports that can be extracted by a simple click and drag. This is a
quick intro into using Pivot Tables. |
FREE
|
|
 |
Conditional Formatting
It is always useful to use colours and formatting in general to
emphasis certain aspects of information. What is even more useful is
if Excel can change the format of a cell based on some pre defined
criteria. With conditional formatting this is possible (and involves
NO macros) |
FREE
|
|
|
Next Step
Learn more about Excel by using our other
Power Courses. |
|
|
|
|
Quote of the page:
Results! Why, man, I have gotten a lot of results. I know several
thousand things that won't work. - Thomas Edison (Inventor)
|
|
|
Spreadsheet Professional can reduce the risk you
face due to spreadsheet errors. Find out more on the
Spreadsheet Professional
pages. |
Do you like what you see. Tell your friends. If you
have a training coordinator
at your organisation tell them that there is free excel training available
at this site.
Don't like what you see. Tell us at
training@AuditExcel.co.za .
Do you have suggestions of what you would like to see. Tell us at
training@AuditExcel.co.za .
|
