Microsoft Excel Introduction
Instructor-Led Beginner Excel Courses
Learn the basics with with our one-day Excel course.
New to Excel and not sure how to use features such as entering data, sorting and filtering, create a simple calculation, or how to print a worksheet?
Our one-day beginner Excel courses are specifically designed to get you using Excel with confidence.
Explore the important tools for use in Excel.
Gain practical skills from our experienced trainers with plenty of real-world examples. Experience one on one training or have colleagues join you in a private training session.
Beginner Excel Course
Who is this course for?
This beginner Excel course is suited to those who have little to no experience in using Microsoft Excel but want to learn how to navigate and use Excel with confidence.
Course Description
Our beginner Excel course is part of a 3-level study program. This course aims to give participants a thorough understanding of the basics of creating and working with spreadsheets using Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas and basic functions, printing, and charting.
Learning Outcomes
At the completion of Microsoft Excel Introduction you should be able to:
- navigate your way around Microsoft Excel
- open and navigate within workbooks and worksheets
- understand and work with cell ranges
- understand, create and work with formulas and functions
- understand and use formula cell referencing
- understand and use number formatting
- use fill operations available to fill a data series
- sort data in a list in a worksheet
- filter data in a table
- print your workbook data
- create effective charts in Microsoft Excel
Prerequisites
Our beginner Excel course assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.
Course Duration
The Microsoft Excel Introduction course is run over one-day but can be customised to suit your needs.
Course Overview
Getting to know Excel
- The Excel Workbook Screen
- Using the Ribbon
- Access the Excel Options Dialog
- View Recent Files and Folders
- Customise the Quick Access Toolbar
- Customise the Status Bar
Create a new workbook
- Use a Built-in Template
- Save a Workbook
Work with workbooks
- Open an existing workbook
- Navigate a workbook
- Navigate using the keyboard
- Change Workbook Views
- Zoom In & Out of a Worksheet
- Use Freeze Panes
- Use Split Screen Options
Edit a workbook
- Understand Cell References
- Enter Text, Numbers and Dates
- Overwrite Cell Contents
- Highlight Cells, Columns and Rows
- Delete Cell Contents
- Use Undo and Redo
- Insert new Rows & Columns
- Insert new worksheets
- Rename or delete worksheets
- Add a Tab colour
- Copy or move worksheets
- Hide a worksheet
Copy Data
- Use Cut & Paste
- Use Copy & Paste
- Copy a Formula or Function
- Use the Clipboard
Fill Data
- Fill a Data Series
- Fill a Growth Series
- Use Flash Fill
Sort Data
- Sort Data Alphabetically
- Sort Numbers
- Sort Dates
- Create a Custom Sort
Filter Data
- Apply and use a filter
- Clear a filter
- Apply filters on multiple values
- Use Text Filter Options
- Use Date Filter Options
- Use Number Filter Options
Formula and Functions
- Understand BIDMAS
- Create Basic Arithmetic Formulas
- Use the SUM Function
- Sum Non-Adjacent Ranges
- Calculate an Average
- Find the Maximum & Minimum Value
- Use the Count Numbers Function
- Troubleshoot common errors
Printing
- Use Spell Check
- Use Print Preview
- Work with Margins & Orientation
- Use Print Titles
- Use Scaling Options
- Print a Selection
- Print a Range or Entire Workbook
Font Formatting
- Apply font style and font size
- Use various formatting options
- Change Text Alignment
- Use Format Painter
Number Formatting
- Apply General Number Formats
- Format Currency and Percentages
- Format Dates
- Increase and decrease decimal places
Create Charts
- Create a Quick Chart
- View Recommended Charts
- Create a Column Chart
- Create a Pie Chart
- Create a Combo Chart
- Edit chart elements
- Customise chart options
Course Inclusions
Skills Analysis
Take advantage of our free online skills analysis prior to your training to ensure have are undertaking the correct course.
Certificate
After completing the course you’ll receive a certificate to show off your new-found knowledge and skills.
We come to you
To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.
Hands-on training
We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.
Email Support
Access unlimited support following your training course to build on your learning and ask any burning questions.
Real-world examples
You'll work through real-world examples to reinforce learning and increase your confidence.
Course Pricing
Our bespoke training courses allow you to pick and choose the content for your session. We provide a cost-effective way of training small teams or larger groups.
Pricing as of 1st April 2024. All prices are including GST.
| Number of participants |
In-Person* Cost per day |
Online Cost per day |
|---|---|---|
| 1 participant | $660.00 inc GST | $605.00 inc GST |
| 2 participants | $836.00 inc GST | $781.00 inc GST |
| 3 participants | $1,012.00 inc GST | $957.00 inc GST |
| 4 participants | $1,188.00 inc GST | $1,133.00 inc GST |
| 5 participants | $1,364.00 inc GST | $1,309.00 inc GST |
| 6 participants | $1,540.00 inc GST | $1,485.00 inc GST |
Contact us for pricing with 6+ participants.
* Within 50km driving distance from NSW 2567. Additional travel costs may apply outside this distance.
