Excel tips from our certified instructors
One great feature is the Combo Charts, which will allow you to combine two different types of charts to contrast both data sets. For example, you could combine column and line charts, making your charts interesting and saving you time.
VBA (Visual Basic for Applications) is the programming language of Excel that allows you to automate tasks utilising what we call macros. Basically, VBA is the tool we use to develop programs to control and automate functions in Excel.
Well probably the best way to understand it, is to see how its done.
Excel tips and tricks
Before you can start using Pivot Table reports you need to ensure three things:
- Your data headings are across the top of your data, these will be used as the fields in the report
- There are no blanks in your data, this can cause blanks in your reports with figures that relate to no particular data
- If your data contains formulas, check there are no errors as these could lead to incorrect totals or error messages in your report
Sparklines are a great way to help clarify your data.
Sparklines are used to graphically represent data by creating line or column graphs as backgrounds within cells on the Excel sheet. Creating sparklines adjacent to data rows allows you to show patterns and relationships between data on those rows in a clear, compact graphical representation, making analysing relationships simpler and more straightforward.