Our half-day Microsoft Excel courses, from 9:30 am to 12:30 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 Introduction to Excel course is designed for beginners or those looking to refresh their basic skills. You'll be introduced to Excel’s core features and essential functions, building a strong foundation for confident spreadsheet use.
Exploring Excel
- Creating a new workbook
- Navigating the ribbon
- Features of a sheet
Formatting Numbers, Text & Cells
- Formatting numbers and text
- Colouring data and cells
- Wrapping, shrinking & merging cells & using indents
Moving, Copying and Filling Data
- Moving & copying data
- Auto & series fill
- Find and replace text
Preparing your Spreadsheet for Printing
- Previewing and printing
- Page Setup / Orientation / Scaling / Margins
Managing Columns & Rows
- Hide & unhide columns & rows
- Insert & delete columns & rows
- Row & column width
Navigating & Managing 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 Excel for Administrators course is tailored for professionals in administrative roles who use Excel in their daily work. This session focuses on practical techniques and time-saving tips to streamline your workflow, manage data more effectively, and boost 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
- Creating and editing tables
Data Validation
- Drop down menus
- Basic data validation & error messages
Absolute cell referencing & named cells
- Absolute (using $ in a formula)
- Named cells
Introduction to the IF Function
Applying Basic Conditional
- To highlight Important Information
Creating Simple PivotTables to Summarise Data
Excel Training For Data Analysis
Our half-day Excel for Data Analysis course is designed for professionals who already use Excel and want to strengthen their skills in analysing and interpreting data. You'll learn how to use formulas, functions, and PivotTables to uncover insights and make more informed decisions.
Summarising & Preparing Data
- Using Subtotal to summarise grouped data
- Applying Filter to focus on specific data sets
- Cleaning data with Remove Duplicates & the TRIM function
Core Formulas and Functions for Data Analysis
- IF & IFS Function
- To perform logical tests
- Conditional Aggregates
- Applying COUNTIF, SUMIF, AVERAGEIF functions to analyse specific conditions
- XLookUp function
- Performing lookups to find and retrieve data across tables
Quick Visual Analysis Tools
- Quick Analysis:
- To create instant summaries
- Conditional Formatting
- To highlight key trends, exceptions insights
- Sparklines
- For mini data visualisations
Analysing Data with Pivot Tables
- Building & customising PivotTables to summarise large data sets
- Using filters & sorting within PivotTables
- Showing values as percentages or differences
- Creating PivotCharts and adding slicers for interactivity
Introducing AI in Excel
- Exploring how AI tools like ChatGPT or Copilot can assist with Excel