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