Basic Excel Course
(Microsoft Excel Introduction)
Instructor-led Excel training for beginners
Build Essential Skills with Our Basic Excel Course
Learn the core Excel skills you need to work confidently with spreadsheets in our one day basic excel course. Perfect for beginners, this course covers the fundamentals such as entering data, sorting and filtering, creating simple calculations and preparing a worksheet for printing. If you are new to Excel or feel unsure about the basic features, this is the ideal place to start.
Practical, Hands On Training for Beginners
Our basic excel course is designed to help you understand and use essential Excel tools through clear demonstrations and real world examples. Taught live by an experienced trainer, you will learn in a relaxed setting with plenty of opportunities to ask questions. Choose a one on one session or include colleagues in a private small group to build confidence together.
Beginner Excel Course
Who is this course for?
This basic or introductory Excel course is suited to those who have little to no experience in using Microsoft Excel but want to learn basic Excel skills such as how to navigate Excel, entering and editing data, sorting and filtering, basic calculations plus printing.
Course description
Our basic 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 basic Excel course (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 basic 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 basic Excel course course is run over one-day but can be customised to suit your needs.
What you will learn in this basic Excel course
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 Assessment
Take advantage of our free skills assessment prior to your training.
Course Manual
Course manual included in PDF format.
We come to you
We bring the training to you to avoid staff travel.
Ongoing Support
Access unlimited email support following your training course.
Course Pricing
Our bespoke training courses allow you to pick and choose the content you need in your training session. We provide a cost-effective way of training small teams or large groups.
Pricing as of 1st January 2026. All prices are including GST.
| Number of participants |
In-Person* Cost per day |
Online Cost per day |
|---|---|---|
| 1 participant | $670.00 inc GST | $610.00 inc GST |
| 2 participants | $850.00 inc GST | $790.00 inc GST |
| 3 participants | $1,030.00 inc GST | $970.00 inc GST |
| 4 participants | $1,210.00 inc GST | $1,150.00 inc GST |
| 5 participants | $1,390.00 inc GST | $1,330.00 inc GST |
| 6 participants | $1,570.00 inc GST | $1,510.00 inc GST |
Contact us for pricing with 6+ participants.
* Includes travel within 50km driving distance of NSW 2567.
Travel beyond this distance is available, additional costs may apply.
Ready to find out more?
Simply fill out the form below to receive more information about our training services and how we can help your staff to improve their productivity.
We reply within 1-2 business days. No spam, no hard sell, just expert advice.
0418 820 572
available Monday to Friday
9:00am till 5:00pm
Email: info@beltan.com.au