Free Excel Skills Assessment

Very short questionnaire to establish your skill level with Microsoft Excel.

Excel Assessment

Free Microsoft Word Skills Assessment

Very short questionnaire to establish your skill level with Microsoft Word.

Word Assessment

Free PowerPoint Skills Assessment

Very short questionnaire to establish your skill level with Microsoft PowerPoint.

PowerPoint Assessment

Tips for using Pivot Tables to Analyse Data Tuesday, March 6, 20180

Tips for using Pivot Tables to Analyse Data

Analysing data has become an important part of any modern organisation. It can optimise our time and it can help us to make better and quicker business decisions. However, when you have a lot of data and aren’t an expert, it can be difficult to know where to start. Pivot Tables in Excel are a great place to start and can be helpful in the process of getting data ready to analyse.

Using Pivot Table Reports Wednesday, July 6, 20160

Using Pivot Table Reports

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
RSS

Theme picker

Loader

Categories

Subscribe to our Newsletter

cheat sheet resources

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

Subscribe


Follow us on Linkedin for the lastest cheat sheets and learning resources