Previously Excel Consulting

Excel Training Nexacu

Microsoft Excel Training - Beginner Course

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

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

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. You can build on this course with the Intermediate and Advanced levels when it suits.

Brisbane
Sydney
Parramatta
Melbourne
Canberra
Adelaide
Perth
Upcoming Courses:
Brisbane
Date
Course
City
Status
Fri 22-Nov-19
Excel Beginner
Brisbane
Few Seats
Mon 2-Dec-19
Excel Beginner
Brisbane
Few Seats
Tue 10-Dec-19
Excel Beginner
Brisbane
Scheduled
Wed 18-Dec-19
Excel Beginner
Brisbane
Scheduled
Mon 6-Jan-20
Excel Beginner
Brisbane
Confirmed
Fri 17-Jan-20
Excel Beginner
Brisbane
Confirmed
Tue 21-Jan-20
Excel Beginner
Brisbane
Scheduled
Fri 31-Jan-20
Excel Beginner
Brisbane
Scheduled
Thu 6-Feb-20
Excel Beginner
Brisbane
Scheduled
Mon 17-Feb-20
Excel Beginner
Brisbane
Scheduled
Tue 3-Mar-20
Excel Beginner
Brisbane
Scheduled
Thu 12-Mar-20
Excel Beginner
Brisbane
Scheduled
Wed 18-Mar-20
Excel Beginner
Brisbane
Scheduled
Mon 23-Mar-20
Excel Beginner
Brisbane
Scheduled
Mon 30-Mar-20
Excel Beginner
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Fri 22-Nov-19
Excel Beginner
Sydney
Few Seats
Mon 2-Dec-19
Excel Beginner
Sydney
Scheduled
Wed 18-Dec-19
Excel Beginner
Sydney
Scheduled
Mon 6-Jan-20
Excel Beginner
Sydney
Confirmed
Fri 17-Jan-20
Excel Beginner
Sydney
Scheduled
Tue 21-Jan-20
Excel Beginner
Sydney
Scheduled
Fri 31-Jan-20
Excel Beginner
Sydney
Scheduled
Thu 6-Feb-20
Excel Beginner
Sydney
Scheduled
Mon 17-Feb-20
Excel Beginner
Sydney
Scheduled
Tue 3-Mar-20
Excel Beginner
Sydney
Scheduled
Thu 12-Mar-20
Excel Beginner
Sydney
Scheduled
Wed 18-Mar-20
Excel Beginner
Sydney
Scheduled
Mon 23-Mar-20
Excel Beginner
Sydney
Scheduled
Mon 30-Mar-20
Excel Beginner
Sydney
Scheduled
Fri 3-Apr-20
Excel Beginner
Sydney
Scheduled
Parramatta
Date
Course
City
Status
Tue 26-Nov-19
Excel Beginner
Parramatta
Few Seats
Mon 9-Dec-19
Excel Beginner
Parramatta
Confirmed
Mon 13-Jan-20
Excel Beginner
Parramatta
Scheduled
Tue 28-Jan-20
Excel Beginner
Parramatta
Scheduled
Wed 12-Feb-20
Excel Beginner
Parramatta
Scheduled
Fri 28-Feb-20
Excel Beginner
Parramatta
Scheduled
Mon 23-Mar-20
Excel Beginner
Parramatta
Scheduled
Tue 21-Apr-20
Excel Beginner
Parramatta
Scheduled
Thu 7-May-20
Excel Beginner
Parramatta
Scheduled
Tue 16-Jun-20
Excel Beginner
Parramatta
Scheduled
Melbourne
Date
Course
City
Status
Fri 22-Nov-19
Excel Beginner
Melbourne
Confirmed
Mon 2-Dec-19
Excel Beginner
Melbourne
Confirmed
Tue 10-Dec-19
Excel Beginner
Melbourne
Scheduled
Wed 18-Dec-19
Excel Beginner
Melbourne
Scheduled
Mon 6-Jan-20
Excel Beginner
Melbourne
Scheduled
Fri 17-Jan-20
Excel Beginner
Melbourne
Scheduled
Tue 21-Jan-20
Excel Beginner
Melbourne
Scheduled
Fri 31-Jan-20
Excel Beginner
Melbourne
Scheduled
Thu 6-Feb-20
Excel Beginner
Melbourne
Scheduled
Mon 17-Feb-20
Excel Beginner
Melbourne
Scheduled
Tue 3-Mar-20
Excel Beginner
Melbourne
Scheduled
Thu 12-Mar-20
Excel Beginner
Melbourne
Scheduled
Wed 18-Mar-20
Excel Beginner
Melbourne
Scheduled
Mon 23-Mar-20
Excel Beginner
Melbourne
Scheduled
Mon 30-Mar-20
Excel Beginner
Melbourne
Scheduled
Canberra
Date
Course
City
Status
Tue 26-Nov-19
Excel Beginner
Canberra
Confirmed
Mon 9-Dec-19
Excel Beginner
Canberra
Scheduled
Mon 13-Jan-20
Excel Beginner
Canberra
Scheduled
Tue 28-Jan-20
Excel Beginner
Canberra
Scheduled
Mon 3-Feb-20
Excel Beginner
Canberra
Scheduled
Fri 28-Feb-20
Excel Beginner
Canberra
Scheduled
Mon 23-Mar-20
Excel Beginner
Canberra
Scheduled
Tue 21-Apr-20
Excel Beginner
Canberra
Scheduled
Thu 7-May-20
Excel Beginner
Canberra
Scheduled
Tue 16-Jun-20
Excel Beginner
Canberra
Scheduled
Adelaide
Date
Course
City
Status
Tue 26-Nov-19
Excel Beginner
Adelaide
Few Seats
Mon 9-Dec-19
Excel Beginner
Adelaide
Scheduled
Mon 13-Jan-20
Excel Beginner
Adelaide
Confirmed
Tue 28-Jan-20
Excel Beginner
Adelaide
Scheduled
Mon 3-Feb-20
Excel Beginner
Adelaide
Scheduled
Fri 28-Feb-20
Excel Beginner
Adelaide
Scheduled
Mon 23-Mar-20
Excel Beginner
Adelaide
Scheduled
Tue 21-Apr-20
Excel Beginner
Adelaide
Scheduled
Thu 7-May-20
Excel Beginner
Adelaide
Scheduled
Tue 16-Jun-20
Excel Beginner
Adelaide
Scheduled
Perth
Date
Course
City
Status
Thu 5-Dec-19
Excel Beginner
Perth
Scheduled
Mon 9-Dec-19
Excel Beginner
Perth
Sold Out
Mon 13-Jan-20
Excel Beginner
Perth
Few Seats
Tue 28-Jan-20
Excel Beginner
Perth
Few Seats
Wed 12-Feb-20
Excel Beginner
Perth
Scheduled
Fri 28-Feb-20
Excel Beginner
Perth
Scheduled
Mon 23-Mar-20
Excel Beginner
Perth
Scheduled
Tue 21-Apr-20
Excel Beginner
Perth
Scheduled
Thu 7-May-20
Excel Beginner
Perth
Scheduled
Tue 16-Jun-20
Excel Beginner
Perth
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 10 333 Adelaide St 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3 37 Pitt Street Sydney NSW, 2000
microsoft_gold

Excel Beginner Course Details

Price
$330
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3 90 Phillip 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 1 (Ethos House) 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 1 140 St Georges Tce Perth CBD, WA, 6000
microsoft_gold

Excel Course Outlines

  • Excel Intermediate
Other Courses
  • Microsoft Power BI Training Courses
  • Microsoft Office 365 Training Courses
  • Microsoft Excel Specialist Training Courses
  • Microsoft SharePoint Training Courses
  • Microsoft PowerApps Training Courses
  • Microsoft Project Training Courses
  • Microsoft Visio Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses
Course Rating
Microsoft Excel Training Courses

4.74 5 Microsoft Excel Training Courses
4.74 out of 5
8175 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.

Excel Beginner Learning Outcomes

  • navigate your way around Microsoft Excel
  • 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 used to perform calculations
  • understand points to consider to avoid problems in your worksheets

 

  • use font formatting techniques to greatly enhance the look of a worksheet
  • alter the layout of a worksheet
  • sort and filter data in a worksheet
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it

 

Excel Beginner Course Content

  • Basics
  • Starting Excel from the Desktop
  • Understanding the Excel Start Screen
  • The Excel Workbook Screen
  • How Excel Works
  • Using the Ribbon
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Understanding the Status Bar
  • Exiting Safely From Excel
  • Workbooks
  • Understanding Workbooks
  • Using the Blank Workbook Template
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Typing Formulas
  • Easy Formulas
  • Saving a New Workbook
  • Checking the Spelling
  • Making Basic Changes
  • Safely Closing a Workbook
  • Navigating
  • 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
  • Ranges
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • Understanding Copying in Excel
  • Using Fill for Quick Copying
  • Copying from One Cell to Another
  • 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
  • Understanding Moving in Excel
  • Moving Cells and Ranges
  • Formulas/Functions
  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply and Divide
  • Understanding Functions
  • Using The SUM Function
  • Summing Non-Contiguous Ranges
  • Calculating An Average
  • Finding a Maximum Value
  • Finding a Minimum Value
  • 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 Message
  • Formatting
  • 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
  • Using the Format Painter
  • Understanding Cell Alignment
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells
  • Understanding Number Formatting
  • Applying General Formatting
  • Formatting for Money
  • Formatting Percentages
  • Formatting as Fractions
  • Formatting as Dates
  • Using the Thousands Separator
  • Increasing and Decreasing Decimals
  • Layout
  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting the Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights
  • Understanding Worksheets
  • Changing the Worksheet View
  • Worksheet Zooming
  • Viewing the Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting Cells into a Worksheet
  • 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
  • Sorting/Filtering
  • Understanding Lists
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Sorting on Multiple Columns
  • Understanding Filtering
  • Applying and Using A Filter
  • Clearing a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
  • 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
  • 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
  • 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
  • Help
  • Understanding How Help Works
  • Accessing the Help Window
  • Navigating the Help Window
  • Using the Office Website for Help
  • Using Google to Get Help
  • Printing a Help Topic
  • Other Sources of Assistance
  • Guidelines
  • Nothing Beats Good Planning
  • Organisation and Design
  • Spot On Formulas
  • Documented and Easy to Use
  • The Appropriateness of Spreadsheets

Why choose Nexacu?

Valued by Individuals

4.8/5
Over 16426 Reviews
Thank you, a good beginners course. - Power BI Beginner Brisbane
Kellie - Power BI Beginner, .
Steve was excellent - patiently guided me through PB Beginner - something I have never experienced. Will be very useful in work and hope will get there. Thanks very much. -Power BI Beginner Brisbane
Athula - Power BI Beginner, .
Thank you for a very informative session. It is great to learn Power BI and I am looking forward to use this in my work. -Power BI Beginner Brisbane
Yudith - Power BI Beginner, .
Steven was very insightful and expertly displayed his knowledge in manageable terms for beginners. I really enjoyed this session and feel confident in engaging with the software further in work contexts -Power BI Beginner Brisbane
Daniel - Power BI Beginner, .
Session was very beneficial. Great tools and tips to assist in getting started in Power BI. -Power BI Beginner Brisbane
Cassandra - Power BI Beginner, .
Great introductory course to Power BI -Power BI Beginner Brisbane
Clinton - Power BI Beginner, .
Excellent beginner course and Steven was a very knowledgeable and engaging presenter. Highly recommended. -Power BI Beginner Brisbane
Emerson - Power BI Beginner, .
A really great introductory session including a foundation of a variety of useful tools. Loved the follow up on questions asked throughout the day, and the facilitation was fabulously involved. Much enjoyed and very useful. - Power BI Beginner Melbourne
Virginia - Power BI Beginner, .
Tim was amazing and very very helpful . Always happy to assist with any queries -Power BI Beginner Melbourne
Daren - Power BI Beginner, .
course was useful to enhance my knowledge. -Power BI Beginner Melbourne
Amita - Power BI Beginner, .
Enjoyed the training, very informative and good content. -Power BI Beginner Melbourne
Manoja - Power BI Beginner, .
Tim was a brilliant facilitator, he made PowerBI look simple and easy. I'll definitely sign up for the intermediate course in the not too distant future. -Power BI Beginner Melbourne
Damien - Power BI Beginner, .
Good introduction into Microsoft BI -Power BI Beginner Melbourne
Kate - Power BI Beginner, .
Very thorough -Power BI Beginner Melbourne
Pia - Power BI Beginner, .
Really easy to follow and will definitely use the information I have learnt. -Power BI Beginner Melbourne
Sapphire - Power BI Beginner, .
Covered a lot of ground in one day. Good introduction to Power BI. -Power BI Beginner Melbourne
Piya - Power BI Beginner, .
Had a great day and Jason was very professional and helpful. I learnt heaps to help my career. -Excel Beginner Brisbane
Joel - Excel Beginner, .
Jason was very good and made it simple for us to understand -Excel Beginner Brisbane
Warren - Excel Beginner, .
good -Power BI Beginner Sydney
Hong - Power BI Beginner, .
Very good overview of PowerBI -Power BI Beginner Sydney
Ingrid - Power BI Beginner, .

Trusted by Business

Procured by Government

Map of Australia