Microsoft Excel Introduction

Microsoft Excel new logo with Microsoft Partner written on it.
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Excel Introduction

$450per person

In Person Virtual

Location: Level 1 Cloisters, 863 Hay Street, Perth WA 6000
Time: 9:00 am to 4:00 pm
Duration: 1 Day

Join in-person at our vibrant Perth CBD training centre. Morning tea and afternoon tea are provided for all in-person attendees. Our training centre is centrally located and easily accessible by public transport.

Course Overview

Course Overview

In this one day Excel course, you will learn how to confidently create, format and manage professional spreadsheets using Microsoft Excel, covering essential skills such as entering and organising data, applying formatting to enhance readability, performing basic calculations and using simple formulas, as well as setting up worksheets for efficient printing and presentation, giving you a strong foundation to work productively with Excel in a business environment.

Book a course

Course Information

Course Content

Spreadsheet Concepts

  • Introduction to the Excel environment & the components available to the user

Working In The Worksheet

  • Navigating around the worksheet
  • Entering and editing text, numbers and dates
  • Selecting cells and ranges
  • Cutting, copying and pasting text and numbers
  • Inserting and deleting cells, columns and rows
  • Adding, deleting and copying sheets

Working With Excel Files

  • Saving files
  • Opening and closing files

Basic Formulas and Functions

  • Creating formulae using addition, subtraction, multiplication, and division
  • Using Excel functions: SUM, COUNT, COUNTA, AVERAGE, MIN, MAX
  • Copying formulae and functions

Data Presentation

  • Formatting cells
  • Formatting text, numbers and dates
  • Using the Format Painter

Working with Lists

  • Understanding Lists
  • Sorting and filtering list data
  • Freezing part of the worksheet

Creating Basic Charts

  • Creating simple charts
  • Changing the chart type and moving charts

Print Options

  • Printing worksheets
  • Printing charts

On completion of this course, participants will be able to create and print a spreadsheet using basic editing and formatting.

A familiarity with the computer keyboard, Window and Word Processing is desirable.

“Following this course, I feel more confident when I need to use Excel. I feel more familiar with the program, and I think I can trouble shoot any future issues with greater ease. I really enjoyed this class. I feel very informed. Our instructor Joe was friendly, easy to listen too and clearly very passionate about the training.” – Meagan from City of Bunbury

“Awesome course and easy to follow. I knew nothing about excel I’m walking out with a better understanding” – Anonymous 

“I believe the course was very knowledgeable and informative. There wasn’t too much of a information overload but just enough” – Teah from Fortescue

“Joe was really engaging and made the learning easy to absorb. He is a great trainer! I will be able to immediately start implementing these skills in my work, and save myself lots of time!” – Lauretta from Health Support Services

“Tricia was really helpful and took her time to assist everyone skills and capabilities.” – Shayna from Mineral Resources

“Joe Foley was an amazing trainer, very informative and helpful. Made the content very easy to understand. I feel confident moving forward with making the most of excel.” – Shakira from Rio Tinto

“Algis was extremely knowledgeable and helpful. The lunch voucher was a great idea, and the facilities were well located, clean and very modern.” – Jon from Jet Aviation

“I thoroughly enjoyed this training session today. Trainer explained everything in such a calm, patient and engaging manner that kept the whole class engaged with her throughout the day. I would happily come back after today’s experience.” – Heba from BGC

“The trainer delivered subject in a friendly manner with lots of support and practical and user friendly examples” – Pauline from Dept of Communities

“I found the course well suited to my needs, within the first 40 minutes I felt as though the course was already worth it. I am really happy with what I have learnt today and look forward to putting it in to practice.” – Trevor from Rio Tinto

“I would recommend to my colleagues who lack confidence in excel to do this course. I was very happy with the overall experience and have learnt a great deal.”  – Nikki from WA Police

“Developed my basic skills in a number of areas. I got what I wanted out of the course and I’m more confident to work in Excel to build my skills further” – Emily from Kimberley Aboriginal Medical Services

FAQs

Are your courses available online or in person?