1. Introduction to Excel (The Basics)
New to Excel? This session will show you some basic features to get started on the creation, formatting and printing of an Excel Workbook.
- Create and edit a worksheet (New, Open, Save, Save As)
- Format a worksheet (Font, Alignment, Format Painter, Cut/Copy/Paste)
- Print a worksheet (Page Setup and Printing)
2. Basic Formulas
Using Excel, but don’t know how to create basic formulas? This session is for you, showing you how to get started on the creation of basic Excel Formulas and Functions.
- Create basic formulas
- Insert functions
- AutoSum / AutoCalc
3. Pivot Tables and Pivot Charts
Analysing Data Lists can be much simpler with the use of Pivot Tables as they allow you to summarise, filter and chart large amounts of data quickly.
- Create and modify a Pivot Table
- Add Calculated Fields
- Group Data
- Pivot Charts
- Filter with Slicers and Timelines
4. Date and Text Functions
This session will show you some of the Text Functions within Excel to allow you to extract data from a cell, add cells together and use functions and shortcuts for dates.
- DATE Functions
- TEXT Functions
- Text to Columns
- Flash Fill
5. If and VLookup Functions
Use some of Excel’s Logical Functions to test conditions within cells and how to use VLOOKUPs to help you extract data within a data list.
- IF, COUNTIF and SUMIF
6. Using Visual Tools
How can you make your Excel Workbook look professional? In this session you will insert various Charts, use Sparklines to show trends and apply Conditional Formatting to highlight cells under various conditions.
- Insert Charts
- Insert Sparklines
- Quick Analysis Tool
- Conditional Formatting
7. Excel Tables and Data List Management
Currently using Basic Sort and Filter for Data Lists? This session will show you how to use Excel Tables for Data Lists which will allow you to add calculations quickly to the list and also how to manage lists with Freeze Panes.
- Introducing Excel Tables
- Format a Table
- Create a calculated row
- Freeze Panes
8. Creating and Running Macros
Repetitive tasks can be time-consuming; recording a Macro to automate those tasks and running the Macro as many times as you like could be time-saving!
- Create, run, edit and delete Macros
- Create a Macro Ribbon Tab
9. Collaborating with Others
Making sharing workbooks easier to control, this session will show you how to password protect cells and worksheets and track all changes made to a shared workbook.
- Cell, Worksheet and Workbook Protection
- Share a Workbook
- Set Revision Tracking
- Review Tracked Changes