PowerPoint presentation tips
Great presentations do not necessarily equal extensive slides full of figures and data. Slides are much more about supporting your point, rather than being main subject of the presentation. Here are some tips to improve your presentations and help you impress everyone in the office.
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
And Adding an Electronic Business Card to an Email
Adding signatures allows you to personalise your Outlook emails and add contact information. Your job title, contact phone numbers, website address can all be included in a signature. Even your hand-written signature can be included as an image.
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.