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
Thu 14-Nov-19
Excel Beginner
Sydney
Few Seats
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
Parramatta
Date
Course
City
Status
Tue 26-Nov-19
Excel Beginner
Parramatta
Confirmed
Mon 9-Dec-19
Excel Beginner
Parramatta
Scheduled
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
Fri 15-Nov-19
Excel Beginner
Adelaide
Scheduled
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
8170 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 16376 Reviews
The course was very informative for someone who has never used VBA before. I learned a lot during the two days. Thank you -Excel Macros/VBA 2 Day Brisbane
Bhavna - Excel Macros/VBA 2 Day, .
Good introduction -Excel Macros/VBA 2 Day Brisbane
Ian - Excel Macros/VBA 2 Day, .
Good introductory course -Excel Macros/VBA 2 Day Brisbane
Harold - Excel Macros/VBA 2 Day, .
Fantastic course and trainer was awesome, explained everything and a small group which was good. - Excel Macros/VBA 2 Day Brisbane
David - Excel Macros/VBA 2 Day, .
- -SharePoint Site Owner Brisbane
Gabrielle - SharePoint Site Owner, .
Overall i have come away with additional knowledge and skills from the course. -SharePoint Site Owner Brisbane
Leisa - SharePoint Site Owner, .
Got what I expected. -SharePoint Site Owner Brisbane
Alice - SharePoint Site Owner, .
Good course, Very helpful should come into a lot of use. Thank You -SharePoint Site Owner Brisbane
Linda - SharePoint Site Owner, .
Well structured and very well presented by Mr. Michael -SharePoint Site Owner Sydney
Umar - SharePoint Site Owner, .
A comprehensive course, but I would have spent more time explaining Permissions using more examples -SharePoint Site Owner Sydney
Anya - SharePoint Site Owner, .
Great course -SharePoint Site Owner Sydney
Karen - SharePoint Site Owner, .
Clive is very knowledgeable and is very helpful. -Excel Macros/VBA 2 Day Sydney
Katherine - Excel Macros/VBA 2 Day, .
Excellent course which has improved my understanding of Excel VBA. Greg answered all my questions and has given me some ideas to improve my macros back in the work place. -Excel Macros/VBA 2 Day Canberra
Brad - Excel Macros/VBA 2 Day, .
I enjoyed every minute of the course. This has been a excellent experience that I learnt much about VBA coding. Clive is a knowledgeable instructor! -Excel Macros/VBA 2 Day Sydney
UQ - Excel Macros/VBA 2 Day, .
Excellent review of Project basics, thanks! -Project Beginner Melbourne
Johan - Project Beginner, .
An informative an interactive session -Project Beginner Melbourne
Christina - Project Beginner, .
Good and handy feedback for building a better schedule. -Project Beginner Melbourne
Ivana - Project Beginner, .
The design and delivery of the course is systematic and effective. However, it would be more helpful, if the design and delivery of the course is aligned towards doing a programming. -Excel Macros/VBA 2 Day Canberra
sonam - Excel Macros/VBA 2 Day, .
. -Excel Macros/VBA 2 Day Sydney
peggy - Excel Macros/VBA 2 Day, .
Great tips that I didn't even know about! -Excel Advanced Melbourne
Sabrina - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia