Blog banner
New Excel Charts to improve your productivity

New Excel Charts to improve your productivity

Take a sneak peek at our chart tips and improve your spreadsheets

Microsoft has been improving the Office suite more frequently in the recent years. The features are based on what people are looking for in general and with the aim of saving time for end users. All the changes are conducted by a mixed team of project managers, team leaders, analysts, and administrators to ensure they are relevant and easy to use. In this article, we will provide some useful tips to help you make use of some of these features in your Excel spreadsheets.  
Monday, August 28, 2017/Author: Suellen Machado/Number of views (246)/Comments (0)/ Article rating: 5.0
Microsoft Office Quick Start Guides

Microsoft Office Quick Start Guides

Word, Excel, Outlook, PowerPoint and OneNote quick reference cards to speed up your working day.

Did you know that Microsoft produce quick start guides for Word, Excel, Outlook, PowerPoint and OneNote that go some way towards helping people with common tasks and give a nice overview of the software.

Tuesday, August 1, 2017/Author: Liam Phelan/Number of views (212)/Comments (0)/ 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. 

Monday, February 20, 2017/Author: Liam Phelan/Number of views (596)/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 (872)/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 (1424)/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 (1484)/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