Microsoft Excel Training

Excel Intermediate 2016

Course Overview:

In this course you will be taught how to not only develop spreadsheets using formulas and formatting but will be shown how to create charts ensuring you leave with a comprehensive knowledge of how to make Excel work for you.

Course Content:

  • Cell formatting
  • Columns and rows
  • Working with formulae
  • Managing and using worksheets
  • Using functions (Sum, AutoSum, Average Max, Text)
  • Conditional Formatting
  • Creating and editing charts
  • Analysing and formula auditing
Availability
  • 3 June 2021
  • 13 July 2021
  • 30 July 2021

Select & copy the date, to paste into the booking form

Pre-requisite:

Computer literate, basic Excel knowledge.

Excel Essentials 2016

Course Overview:

Excel Essentials will equip you with the knowledge to take advantage of the basic features of Microsoft Excel as a business information tool to manipulate and present information. Delegates who are inexperienced in the use of Microsoft Excel would benefit from attending this short course.

Availability
  • 7 June 2021
  • 12 July 2021
  • 2 August 2021

Select & copy the date, to paste into the booking form

Pre-requisite:

Computer literate, basic Excel knowledge.

Excel On Steroids

Course Overview:

Excel on Steroids is more than just an advanced Excel course. It focuses on Excel features that are key for business reporting.

Course content

1. Data analysis:
Smart Lookup | Sorting, subtotalling | Filtering | Data validation | Macros

3. PivotTables & PivotCharts:
New options | Formatting | Calculated items and fields | Sort and filter | Consolidate | Sparklines | 3DMaps

2. Formulas and functions:
Data consolidation | Conditional formatting | Cell references | Statistical & mathematical functions | Date and time functions

Availability
  • 20 - 21 May 2021
  • 9 - 10 June 2021
  • 14 - 15 July 2021
  • 19 - 20 August 2021

Select & copy the date, to paste into the booking form

Pre-requisite:

Excel Intermediate or passing of pre-assessment

Excel on Steroids Plus

Course Overview:

Excel on Steroids Plus will teach you how to model your data, so you can create interactive dashboard reports that will make analysing your data much easier. This will give you clearer insights into your company, enabling you to make smart business decisions.

Course content

  1. Design meaningful Dashboard Reports catering to your audience’s requirements and goals following Dashboard design best practise.
  2. Create dynamic data models which will serve as the back-end of your Dashboard using advanced functions and formula.
  3. Explore alternative visualization techniques, like sparklines and conditional formatting. Create advanced and custom charts.
  4. Create an interactive, macro-charged Dashboard.

Excel on Steroids and a sound knowledge of the advanced features and functionality in Excel used for business reporting

Availability
  • 25 - 26 May 2021
  • 14 - 15 June 2021
  • 22 - 23 July 2021
  • 25 - 26 August 2021

Select & copy the date, to paste into the booking form