All courses available in-class and remotely.

Microsoft Excel Training - Beginner Course

Learn basic Excel skills on our intensive one-day course.

All courses available in-class or remotely. 
To attend remotely, select "Remote Online" as your location on book now.

Learn how to analyse, share and manage your day-to-day data using Excel spreadsheets on our one-day course. This course is Excel for beginners. 

Our Excel Training beginner course, includes creating and formatting spreadsheets and charts, learning to sort and filter and gaining an understanding of Excel’s advanced formulas and functions. View our full Excel Beginner Course Outline below. You can build on this course with the Intermediate and Advanced levels when it suits. This course is Excel for beginners and covers content that is applicable for someone with little to no experience. 

Microsoft Excel Training - Beginner Course

Learn how to analyse, share and manage your day-to-day data using Excel spreadsheets on our one-day course.

$330
10 max
1 day
$330
10 max
1 day
$330
10 max
1 day
$330
10 max
1 day
$330
10 max
1 day
$330
10 max
1 day
$330
10 max
1 day
$330
10 max
1 day

Remote

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Remote Online
Date
Course
City
Status
Thu 30 Jun 22
Thu
30
Jun
Excel Beginner
Remote Online
Status: Few Seats
Few Seats
Tue 5 Jul 22
Tue
5
Jul
Excel Beginner
Remote Online
Status: Few Seats
Few Seats
Wed 13 Jul 22
Wed
13
Jul
Excel Beginner
Remote Online
Status: Few Seats
Few Seats
Wed 20 Jul 22
Wed
20
Jul
Excel Beginner
Remote Online
Status: Confirmed
Confirmed
Wed 27 Jul 22
Wed
27
Jul
Excel Beginner
Remote Online
Status: Few Seats
Few Seats
Tue 2 Aug 22
Tue
2
Aug
Excel Beginner
Remote Online
Status: Confirmed
Confirmed
Wed 3 Aug 22
Wed
3
Aug
Excel Beginner
Remote Online
Status: Confirmed
Confirmed
Thu 4 Aug 22
Thu
4
Aug
Excel Beginner
Remote Online
Status: Confirmed
Confirmed
Fri 19 Aug 22
Fri
19
Aug
Excel Beginner
Remote Online
Status: Confirmed
Confirmed
Mon 22 Aug 22
Mon
22
Aug
Excel Beginner
Remote Online
Status: Confirmed
Confirmed
Fri 9 Sep 22
Fri
9
Sep
Excel Beginner
Remote Online
Status: Scheduled
Scheduled
Thu 15 Sep 22
Thu
15
Sep
Excel Beginner
Remote Online
Status: Scheduled
Scheduled
Mon 19 Sep 22
Mon
19
Sep
Excel Beginner
Remote Online
Status: Scheduled
Scheduled
Mon 26 Sep 22
Mon
26
Sep
Excel Beginner
Remote Online
Status: Scheduled
Scheduled
Wed 19 Oct 22
Wed
19
Oct
Excel Beginner
Remote Online
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Tue 5 Jul 22
Tue
5
Jul
Excel Beginner
Brisbane
Status: Few Seats
Few Seats
Wed 13 Jul 22
Wed
13
Jul
Excel Beginner
Brisbane
Status: Few Seats
Few Seats
Wed 20 Jul 22
Wed
20
Jul
Excel Beginner
Brisbane
Status: Confirmed
Confirmed
Wed 27 Jul 22
Wed
27
Jul
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Thu 4 Aug 22
Thu
4
Aug
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Mon 22 Aug 22
Mon
22
Aug
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Fri 9 Sep 22
Fri
9
Sep
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Mon 19 Sep 22
Mon
19
Sep
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Mon 26 Sep 22
Mon
26
Sep
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Wed 19 Oct 22
Wed
19
Oct
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Thu 3 Nov 22
Thu
3
Nov
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Mon 21 Nov 22
Mon
21
Nov
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Tue 6 Dec 22
Tue
6
Dec
Excel Beginner
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Wed 20 Jul 22
Wed
20
Jul
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Wed 27 Jul 22
Wed
27
Jul
Excel Beginner
Sydney
Status: Few Seats
Few Seats
Thu 4 Aug 22
Thu
4
Aug
Excel Beginner
Sydney
Status: Confirmed
Confirmed
Mon 22 Aug 22
Mon
22
Aug
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Fri 9 Sep 22
Fri
9
Sep
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Mon 19 Sep 22
Mon
19
Sep
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Mon 26 Sep 22
Mon
26
Sep
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Wed 19 Oct 22
Wed
19
Oct
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Thu 3 Nov 22
Thu
3
Nov
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Mon 21 Nov 22
Mon
21
Nov
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Tue 6 Dec 22
Tue
6
Dec
Excel Beginner
Sydney
Status: Scheduled
Scheduled
Parramatta
Date
Course
City
Status
Tue 5 Jul 22
Tue
5
Jul
Excel Beginner
Parramatta
Status: Few Seats
Few Seats
Tue 2 Aug 22
Tue
2
Aug
Excel Beginner
Parramatta
Status: Confirmed
Confirmed
Wed 3 Aug 22
Wed
3
Aug
Excel Beginner
Parramatta
Status: Scheduled
Scheduled
Fri 19 Aug 22
Fri
19
Aug
Excel Beginner
Parramatta
Status: Confirmed
Confirmed
Thu 15 Sep 22
Thu
15
Sep
Excel Beginner
Parramatta
Status: Scheduled
Scheduled
Mon 31 Oct 22
Mon
31
Oct
Excel Beginner
Parramatta
Status: Scheduled
Scheduled
Tue 13 Dec 22
Tue
13
Dec
Excel Beginner
Parramatta
Status: Scheduled
Scheduled
Mon 19 Dec 22
Mon
19
Dec
Excel Beginner
Parramatta
Status: Scheduled
Scheduled
Melbourne
Date
Course
City
Status
Tue 5 Jul 22
Tue
5
Jul
Excel Beginner
Melbourne
Status: Few Seats
Few Seats
Wed 27 Jul 22
Wed
27
Jul
Excel Beginner
Melbourne
Status: Few Seats
Few Seats
Thu 4 Aug 22
Thu
4
Aug
Excel Beginner
Melbourne
Status: Confirmed
Confirmed
Mon 22 Aug 22
Mon
22
Aug
Excel Beginner
Melbourne
Status: Few Seats
Few Seats
Fri 9 Sep 22
Fri
9
Sep
Excel Beginner
Melbourne
Status: Scheduled
Scheduled
Mon 19 Sep 22
Mon
19
Sep
Excel Beginner
Melbourne
Status: Scheduled
Scheduled
Mon 26 Sep 22
Mon
26
Sep
Excel Beginner
Melbourne
Status: Scheduled
Scheduled
Wed 19 Oct 22
Wed
19
Oct
Excel Beginner
Melbourne
Status: Scheduled
Scheduled
Thu 3 Nov 22
Thu
3
Nov
Excel Beginner
Melbourne
Status: Scheduled
Scheduled
Mon 21 Nov 22
Mon
21
Nov
Excel Beginner
Melbourne
Status: Scheduled
Scheduled
Tue 6 Dec 22
Tue
6
Dec
Excel Beginner
Melbourne
Status: Scheduled
Scheduled
Canberra
Date
Course
City
Status
Tue 5 Jul 22
Tue
5
Jul
Excel Beginner
Canberra
Status: Few Seats
Few Seats
Tue 2 Aug 22
Tue
2
Aug
Excel Beginner
Canberra
Status: Confirmed
Confirmed
Wed 3 Aug 22
Wed
3
Aug
Excel Beginner
Canberra
Status: Scheduled
Scheduled
Fri 19 Aug 22
Fri
19
Aug
Excel Beginner
Canberra
Status: Confirmed
Confirmed
Thu 15 Sep 22
Thu
15
Sep
Excel Beginner
Canberra
Status: Scheduled
Scheduled
Mon 31 Oct 22
Mon
31
Oct
Excel Beginner
Canberra
Status: Scheduled
Scheduled
Tue 13 Dec 22
Tue
13
Dec
Excel Beginner
Canberra
Status: Scheduled
Scheduled
Mon 19 Dec 22
Mon
19
Dec
Excel Beginner
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Tue 5 Jul 22
Tue
5
Jul
Excel Beginner
Adelaide
Status: Few Seats
Few Seats
Tue 2 Aug 22
Tue
2
Aug
Excel Beginner
Adelaide
Status: Confirmed
Confirmed
Wed 3 Aug 22
Wed
3
Aug
Excel Beginner
Adelaide
Status: Confirmed
Confirmed
Fri 19 Aug 22
Fri
19
Aug
Excel Beginner
Adelaide
Status: Confirmed
Confirmed
Thu 15 Sep 22
Thu
15
Sep
Excel Beginner
Adelaide
Status: Scheduled
Scheduled
Mon 31 Oct 22
Mon
31
Oct
Excel Beginner
Adelaide
Status: Scheduled
Scheduled
Tue 13 Dec 22
Tue
13
Dec
Excel Beginner
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Thu 30 Jun 22
Thu
30
Jun
Excel Beginner
Perth
Status: Few Seats
Few Seats
Tue 12 Jul 22
Tue
12
Jul
Excel Beginner
Perth
Status: Confirmed
Confirmed
Tue 19 Jul 22
Tue
19
Jul
Excel Beginner
Perth
Status: Scheduled
Scheduled
Tue 2 Aug 22
Tue
2
Aug
Excel Beginner
Perth
Status: Scheduled
Scheduled
Thu 11 Aug 22
Thu
11
Aug
Excel Beginner
Perth
Status: Scheduled
Scheduled
Mon 22 Aug 22
Mon
22
Aug
Excel Beginner
Perth
Status: Scheduled
Scheduled
Tue 6 Sep 22
Tue
6
Sep
Excel Beginner
Perth
Status: Scheduled
Scheduled
Fri 16 Sep 22
Fri
16
Sep
Excel Beginner
Perth
Status: Scheduled
Scheduled
Mon 3 Oct 22
Mon
3
Oct
Excel Beginner
Perth
Status: Scheduled
Scheduled
Wed 26 Oct 22
Wed
26
Oct
Excel Beginner
Perth
Status: Scheduled
Scheduled
Thu 10 Nov 22
Thu
10
Nov
Excel Beginner
Perth
Status: Scheduled
Scheduled
Mon 28 Nov 22
Mon
28
Nov
Excel Beginner
Perth
Status: Scheduled
Scheduled
Mon 5 Dec 22
Mon
5
Dec
Excel Beginner
Perth
Status: Scheduled
Scheduled
Tue 13 Dec 22
Tue
13
Dec
Excel Beginner
Perth
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Frequently Asked Questions

Are your courses suitable for an Excel beginner?

 

Yes, our Excel Beginner Course is aimed at those with little or no experience in Excel. You will learn all key basic excel skills and be ready to put them into practice in the workplace. We also offer Excel Intermediate, Advanced and specialist courses for those looking to take the next step. We want to stress that this is Excel for beginners

Excel Beginner Course Details

Price
$330
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 10
333 Adelaide Street
Brisbane QLD 4000
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 10
100 Walker Street
North Sydney NSW 2060
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
79 George Street
Parramatta NSW 2150
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3
466 Little Lonsdale St
Melbourne VIC 3000
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Ethos House
Level 1
28 Ainslie Place
Canberra ACT 2601
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3
97 Pirie Street
Adelaide SA 5000
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 4
220 St Georges Tce
Perth WA 6000
microsoft_gold

Excel Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Excel Specialist Training Courses
Microsoft Project Training Courses
R Programming Training Courses
Python Training Courses
Power Apps Training Courses
SQL Training Courses
SharePoint Training Courses
Microsoft Teams Training Courses
Power Automate Training Courses
Microsoft Visio Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Course Rating
Microsoft Excel Training Courses

4.75 5 Microsoft Excel Training Courses
4.75 out of 5
14697 Student Reviews

Contact Us


What do I need to know to attend?

There is no requirement for the Excel Basics course. The course is suitable for people who have never worked with Excel or have just had very limited exposure to it. We will walk you through, right from the start. This is an excel course for beginners. 

Excel Beginner Learning Outcomes

  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Understand and work with ranges in a worksheet
  • Understand, create and work with formulas and functions
  • Use font formatting techniques
  • Format rows and columns in a worksheet
  • Use a range of techniques to work with worksheets
  • Sort data in a list in a worksheet
  • Create effective charts in Microsoft Excel
  • Apply a variety of page setup techniques
  • Print your workbook data

Excel Beginner Course Content

  • Your First Workbook 
  • Understanding Workbooks 
  • Using the Blank Workbook Template 
  • Typing Text 
  • Typing Numbers 
  • Typing Dates 
  • Understanding the Fill Handle 
  • Typing Formulas 
  • Easy Formulas 
  • Saving a New Workbook on Your Computer 
  • Checking the Spelling 
  • Making Basic Changes 
  • Safely Closing a Workbook
  • Working With Workbooks 
  • Opening an Existing Workbook 
  • Navigating a Workbook 
  • Navigating Using the Keyboard 
  • Using Go To 
  • Recent Files and Folders 
  • Understanding Data Editing 
  • Overwriting Cell Contents 
  • Editing Longer Cells 
  • Editing Formulas 
  • Clearing Cells 
  • Deleting Data 
  • Using Undo and Redo
  • Cells and Ranges
  • Understanding Cells and Ranges 
  • Selecting Contiguous Ranges
  • Selecting Non Contiguous Ranges
  • Using Special Selection Techniques
  • Selecting Larger Ranges 
  • Selecting Rows 
  • Selecting Columns 
  • Understanding Copying in Excel 
  • Using Fill for Quick Copying 
  • Copying From One Cell to Another
  • Cells and Ranges (cont'd)
  • Copying From One Cell to a Range 
  • Copying From One Range to Another 
  • Understanding Filling 
  • Filling a Series 
  • Filling a Growth Series 
  • Extracting With Flash Fill 
  • More Complex Flash Fill Extractions 
  • Understanding Moving in Excel 
  • Moving Cells and Ranges 
  • Moving by Dragging
  • Formulas and Functions 
  • Understanding Formulas 
  • Creating Formulas That Add 
  • Creating Formulas That Subtract 
  • Formulas That Multiply and Divide 
  • Understanding Functions 
  • Using the SUM Function to Add 
  • Summing Non-Contiguous Ranges 
  • Calculating an Average 
  • Finding a Maximum Value 
  • Finding a Minimum Value 
  • Formulas and Functions (cont'd)
  • Creating More Complex Formulas 
  • What if Formulas 
  • Absolute Versus Relative Referencing 
  • Relative Formulas 
  • Problems With Relative Formulas 
  • Creating Absolute References 
  • Creating Mixed References 
  • Common Error Messages
  • Worksheet Appearance 
  • Understanding Font Formatting 
  • Working With Live Preview 
  • Changing Fonts 
  • Changing Font Size 
  • Growing and Shrinking Fonts 
  • Making Cells Bold 
  • Italicising Text 
  • Underlining Text 
  • Changing Font Colours 
  • Changing Background Colours
  • Worksheet Appearance (cont'd)
  • Using the Format Painter 
  • Applying Strikethrough 
  • Subscripting Text 
  • Superscripting Text 
  • Understanding Cell Alignment 
  • Horizontal Cell Alignment 
  • Vertical Cell Alignment 
  • Indenting Cells 
  • Understanding Number Formatting 
  • Applying General Formatting 
  • Formatting for Money 
  • Worksheet Appearance (cont'd) 
  • Formatting Percentages 
  • Formatting as Fractions 
  • Formatting as Dates 
  • Using the Thousands Separator 
  • Increasing and Decreasing Decimals 
  • Understanding Borders 
  • Applying a Border to a Cell 
  • Applying a Border to a Range 
  • Applying a Bottom Border 
  • Applying Top and Bottom Borders 
  • Removing Borders
  • Worksheet Layout 
  • Approximating Column Widths 
  • Setting Precise Columns Widths 
  • Setting the Default Column Width 
  • Approximating Row Height 
  • Setting Precise Row Heights 
  • Hiding Rows and Columns 
  • Unhiding Rows and Columns 
  • Understanding Worksheets 
  • Changing the Worksheet View 
  • Worksheet Zooming 
  • Viewing the Formula Bar 
  • Viewing Worksheet Gridlines 
  • Inserting Cells Into a Worksheet 
  • Worksheet Layout (cont'd)
  • Deleting Cells From a Worksheet 
  • Inserting Columns Into a Worksheet 
  • Inserting Rows Into a Worksheet 
  • Deleting Rows and Columns 
  • More Than One Worksheet 
  • Worksheet Wisdom
  • Worksheet Techniques 
  • Inserting and Deleting Worksheets 
  • Copying a Worksheet 
  • Renaming a Worksheet 
  • Moving a Worksheet 
  • Hiding a Worksheet 
  • Unhiding a Worksheet 
  • Copying a Sheet to Another Workbook 
  • Moving a Sheet to Another Workbook 
  • Changing Worksheet Tab Colours
  • Worksheet Techniques (cont'd)
  • Grouping Worksheets 
  • Hiding Rows and Columns 
  • Unhiding Rows and Columns 
  • Freezing Rows and Columns 
  • Splitting Windows 
  • New Windows
  • Sorting and Filtering Data 
  • Understanding Lists 
  • Performing an Alphabetical Sort 
  • Performing a Numerical Sort 
  • Sorting on More Than One Column 
  • Understanding Filtering 
  • Applying and Using a Filter 
  • Clearing a Filter 
  • Creating Compound Filters 
  • Multiple Value Filters 
  • Creating Custom Filters 
  • Using Wildcards
  • Creating Charts 
  • Understanding the Charting Process 
  • Choosing the Right Chart 
  • Using a Recommended Chart 
  • Creating a New Chart From Scratch 
  • Working With an Embedded Chart 
  • Resizing a Chart 
  • Repositioning a Chart 
  • Printing an Embedded Chart 
  • Creating a Chart Sheet
  • Creating Charts (cont'd)
  • Changing the Chart Type 
  • Changing the Chart Layout 
  • Changing the Chart Style 
  • Printing a Chart Sheet 
  • Embedding a Chart Into a Worksheet 
  • Deleting a Chart
  • Page Setup 
  • Strategies for Printing Worksheets 
  • Understanding Page Layout 
  • Using Built in Margins 
  • Setting Custom Margins 
  • Changing Margins by Dragging 
  • Centring on a Page 
  • Changing Orientation 
  • Specifying the Paper Size 
  • Setting the Print Area 
  • Clearing the Print Area 
  • Inserting Page Breaks 
  • Page Setup (cont'd)
  • Using Page Break Preview 
  • Removing Page Breaks 
  • Setting a Background 
  • Clearing the Background 
  • Settings Rows as Repeating Print Titles 
  • Clearing Print Titles 
  • Printing Gridlines 
  • Printing Headings 
  • Scaling to a Percentage 
  • Fit to a Specific Number of Pages
  • Printing 
  • Understanding Printing 
  • Previewing Before You Print 
  • Selecting a Printer 
  • Printing a Range 
  • Printing an Entire Workbook 
  • Specifying the Number of Copies 
  • The Print Options 
  • Supplementary Content 
  • Applying Borders
  • Using brackets in excel formulas
  • The Quick Analysis Tools
  • Starting With Excel Online
  • Working With Excel Online

 

Contact Us

What is Remote Training?

Valued by Individuals

4.75 / 5
Over 14697 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us