Blog banner
How to master your presentations

How to master your presentations

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.
Author: Liam Phelan
0 Comments
Article rating: 5.0
How to combine two charts in Excel

How to combine two charts in Excel

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. 

Author: Liam Phelan
0 Comments
Article rating: 5.0
VBA and Macros in Excel - Explained

VBA and Macros in Excel - Explained

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.

Author: Liam Phelan
0 Comments
Article rating: 5.0
Using Pivot Table Reports

Using Pivot Table Reports

Excel tips and tricks

Before you can start using Pivot Table reports you need to ensure three things:

  1. Your data headings are across the top of your data, these will be used as the fields in the report
  2. There are no blanks in your data, this can cause blanks in your reports with figures that relate to no particular data
  3. If your data contains formulas, check there are no errors as these could lead to incorrect totals or error messages in your report
Author: Edith Byrne
0 Comments
Article rating: 5.0
Adding Signatures to your Outlook Emails

Adding Signatures to your Outlook Emails

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.
0 Comments
Article rating: 5.0
Using Excel Sparklines to Depict Data Graphically

Using Excel Sparklines to Depict Data Graphically

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. 
0 Comments
Article rating: 5.0
RSS
123

Sign up for our Newsletter