Excel

Use Microsoft Excel to analyse your data

Overview

Microsoft Excel is a  spreadsheet program in the Office 365 suite used to store, sort, and calculate data. Excel is not a database but it can be used in data analysis to assess large amounts of information and create visualizations.

Create Excel Dashboards

Learn how to use Excel’s many formulas and charts to represent your data visually

Introduction

1 Day

£130

This course is for absolute beginners who have not used Excel before or just recently begun to use it

  • The Ribbon
  • The Backstage View
  • Creating, Opening, Editing and Saving Workbooks
  • Worksheets, Cells, Ranges, Tables
  • Printing

Intermediate

1 Day

£150

This course is for users  who want to enhance their knowledge of Excel  to accomplish everyday tasks

  • Excel Overview
  • Formatting
  • Formulas
  • Functions
  • Charts

Advanced

1 Day

£170

This course is for Excel users who would like to dig deeper into the use of formulas, tables, charts and macros.

  • More Formulas
  • Pivot Tables
  • Pivot Charts
  • Slicers
  • Macros
  • Introduction to VBA