Our half-day Microsoft Excel courses, from 9:30 am to 12:45 pm. These are in person for a more personalised and focused learning experience and held in our comfortable training room at Perth Airport. These sessions provide hands-on instruction tailored to your needs, ensuring you gain practical skills in a short time.
Excel Training for BeginnersÂ
Our half-day course on Excel for Beginners is designed for those who are new to Excel or looking to refresh their basic skills. This session will introduce you to the core features and functionalities of Excel, helping you build a solid foundation.
Exploring Excel
- Creating a new workbook
- Navigating the ribbon
- Features of a sheet
Formatting data and cells
- Formatting numbers and text
- Colouring data and cells
- Wrapping, shrinking & merging cells & using indents
Working with Data
- Moving & copying data
- Auto & series fill
- Find and replace text
Printing & Page Set Up
- Previewing and printing
- Page Setup / Orientation / Scaling / Margins
Working with Columns & Rows
- Hide & unhide columns & rows
- Insert & delete columns & rows
- Row & column width
Using Large Spreadsheets
- Zoom in and out
- Freeze row & columns
- Split screen
Basic Formulas
- Adding, subtracting, multiplying & dividing formulas
Basic Functions
- Autosum, average, count, max, min
Sorting & Filtering Data
Introduction to Conditional Formatting
Excel Training for Administrators
Our half-day course is tailored specifically for professionals in administrative roles who rely on Excel for daily tasks. In this session, we'll focus on practical techniques and tips that will streamline your workflow, improve your data management skills, and enhance your productivity.
Exploring Excel
- Customising the ribbon
- Using templates
Basic Formulas
- Adding, subtracting, multiplying & dividing
Basic Functions
- Autosum, average, count, max & min
Managing Workbooks
- Formatting & worksheet techniques
- Page set-up and print options
Working with Data
- Sorting (2 or more fields) / custom sorts
- Auto filtering & filter function
- Filling data quickly
Tables
- Creatingandeditingtables
Data Validation
- Dropdownmenus
- Basicdatavalidation&errormessages
Absolute cell referencing & named cells
- Absolute (using $ in a formula)
- Namedcells
Introduction to the IF Function
Basic Conditional Formatting
Basic Pivot Tables
Excel Training For Data Analysis
Our half-day course on Excel for Data Analysis is designed for professionals who already use Excel but would like to deepen their skills in using formulas and functions to extract meaningful insights from data.
Summarising Data
- Using subtotal
- Using3Dformulas
- Usingtheconsolidatefunction
- Using the filter function
Formulas & Functions
- IF, Nested IF, IFS, IF Error
- Switch function
- Using AND / OR within functions
- CountIF/SumIF/AverageIF
- SumIFS/CountIFS
- Lookup Functions
- Date & Time Functions
Advanced Conditional Formatting
- New rule with AND / OR / IF functions
- Highlighting entire rows
- From a dropdown list
Analysing Data with Pivot Tables
- Pivot field settings
- Filtering onto separate worksheets
- Creating additional tables from PT
- Summarising data (sum, average etc)
- Show values as (diff from, % of etc)
- Sorting data & calculated fields
- Pivot table chart
- Slicers in pivot tables
- Intro to Power Pivot & Power Query
Using Chat GPT / AI in Excel