Blog banner
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. 

Monday, February 20, 2017/Author: Liam Phelan/Number of views (454)/Comments (0)/ Article rating: 5.0
Tags: Excel
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.

Wednesday, November 23, 2016/Author: Liam Phelan/Number of views (678)/Comments (0)/ 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
Wednesday, July 6, 2016/Author: Edith Byrne/Number of views (1278)/Comments (0)/ 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. 
Wednesday, March 23, 2016/Author: Ronnie McGovern/Number of views (1338)/Comments (0)/ Article rating: 5.0
RSS

Subscribe to our Newsletter

cheat sheet resources

Subscribe to our Newsletter for all the latest cheat sheets and resources.

Subscribe