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. View our full Excel Beginner Course Outline below. 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
Thu 6-Feb-20
Excel Beginner
Brisbane
Confirmed
Mon 17-Feb-20
Excel Beginner
Brisbane
Few Seats
Tue 25-Feb-20
Excel Beginner
Brisbane
Confirmed
Tue 3-Mar-20
Excel Beginner
Brisbane
Scheduled
Thu 12-Mar-20
Excel Beginner
Brisbane
Confirmed
Wed 18-Mar-20
Excel Beginner
Brisbane
Scheduled
Mon 23-Mar-20
Excel Beginner
Brisbane
Confirmed
Mon 30-Mar-20
Excel Beginner
Brisbane
Scheduled
Fri 3-Apr-20
Excel Beginner
Brisbane
Scheduled
Tue 14-Apr-20
Excel Beginner
Brisbane
Scheduled
Tue 21-Apr-20
Excel Beginner
Brisbane
Scheduled
Tue 28-Apr-20
Excel Beginner
Brisbane
Scheduled
Tue 5-May-20
Excel Beginner
Brisbane
Scheduled
Wed 13-May-20
Excel Beginner
Brisbane
Scheduled
Mon 25-May-20
Excel Beginner
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Fri 31-Jan-20
Excel Beginner
Sydney
Confirmed
Mon 17-Feb-20
Excel Beginner
Sydney
Confirmed
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
Tue 14-Apr-20
Excel Beginner
Sydney
Scheduled
Tue 28-Apr-20
Excel Beginner
Sydney
Scheduled
Wed 13-May-20
Excel Beginner
Sydney
Scheduled
Mon 25-May-20
Excel Beginner
Sydney
Scheduled
Tue 9-Jun-20
Excel Beginner
Sydney
Scheduled
Wed 24-Jun-20
Excel Beginner
Sydney
Scheduled
Parramatta
Date
Course
City
Status
Tue 28-Jan-20
Excel Beginner
Parramatta
Confirmed
Wed 12-Feb-20
Excel Beginner
Parramatta
Few Seats
Fri 28-Feb-20
Excel Beginner
Parramatta
Confirmed
Mon 23-Mar-20
Excel Beginner
Parramatta
Confirmed
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 31-Jan-20
Excel Beginner
Melbourne
Confirmed
Thu 6-Feb-20
Excel Beginner
Melbourne
Confirmed
Mon 17-Feb-20
Excel Beginner
Melbourne
Scheduled
Thu 27-Feb-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
Fri 3-Apr-20
Excel Beginner
Melbourne
Scheduled
Tue 14-Apr-20
Excel Beginner
Melbourne
Scheduled
Tue 28-Apr-20
Excel Beginner
Melbourne
Scheduled
Wed 13-May-20
Excel Beginner
Melbourne
Scheduled
Mon 25-May-20
Excel Beginner
Melbourne
Scheduled
Tue 9-Jun-20
Excel Beginner
Melbourne
Scheduled
Wed 24-Jun-20
Excel Beginner
Melbourne
Scheduled
Canberra
Date
Course
City
Status
Tue 28-Jan-20
Excel Beginner
Canberra
Scheduled
Mon 3-Feb-20
Excel Beginner
Canberra
Few Seats
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 28-Jan-20
Excel Beginner
Adelaide
Confirmed
Mon 3-Feb-20
Excel Beginner
Adelaide
Scheduled
Fri 28-Feb-20
Excel Beginner
Adelaide
Scheduled
Mon 23-Mar-20
Excel Beginner
Adelaide
Confirmed
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
Tue 28-Jan-20
Excel Beginner
Perth
Sold Out
Wed 12-Feb-20
Excel Beginner
Perth
Few Seats
Fri 28-Feb-20
Excel Beginner
Perth
Scheduled
Tue 10-Mar-20
Excel Beginner
Perth
Scheduled
Mon 23-Mar-20
Excel Beginner
Perth
Confirmed
Tue 31-Mar-20
Excel Beginner
Perth
Scheduled
Wed 8-Apr-20
Excel Beginner
Perth
Scheduled
Tue 21-Apr-20
Excel Beginner
Perth
Scheduled
Fri 1-May-20
Excel Beginner
Perth
Scheduled
Thu 7-May-20
Excel Beginner
Perth
Scheduled
Tue 19-May-20
Excel Beginner
Perth
Scheduled
Fri 29-May-20
Excel Beginner
Perth
Scheduled
Tue 16-Jun-20
Excel Beginner
Perth
Scheduled
Tue 23-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
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 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 WA 6000
microsoft_gold

Excel Course Outlines

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 Visio Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses
  • Microsoft Project Training Courses
Course Rating
Microsoft Excel Training Courses

4.74 5 Microsoft Excel Training Courses
4.74 out of 5
8749 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 18419 Reviews
Excellent Course well presented by Steven. Excited to expand the horizons another step to power BI heaven -Power BI Advanced Brisbane
Terry - Power BI Advanced, .
Great content, Steve kept things going as slower users tend to slow things down but parked questions well and kept things going. Well explained -Power BI Advanced Brisbane
Matthew - Power BI Advanced, .
Great Course, Thanks Steven -Power BI Advanced Brisbane
Savindren - Power BI Advanced, .
Good presentation and hand on the task. -Power BI Advanced Brisbane
Yuejing - Power BI Advanced, .
Well presented and informative. -Power BI Advanced Brisbane
Brent - Power BI Advanced, .
Good training. -Power BI Advanced Brisbane
Shergeoh - Power BI Advanced, .
It was a good course, good speed and trainer explained tasked very well. Exercises were good and training material very helpful. -Excel Advanced Sydney
Stephanie - Excel Advanced, .
Very knowledgeable trainer and was able to adapt to circumstance that could be beneficial and understood by the group -Excel Advanced Sydney
Danielle - Excel Advanced, .
Good content, and explained in a calm and efficient manner -Excel Advanced Sydney
SonyParimi - Excel Advanced, .
Great documentation and files for the training sessions. Rajashree is really good at keeping the class on track and is quick to identify issues when a user is having problems. -Excel Advanced Sydney
Libby - Excel Advanced, .
Very useful and speed of session was good. Good mix of exercises. More detail on macros would be great. -Excel Advanced Sydney
Jessica - Excel Advanced, .
Michael was fantastic he really made this course informative and enjoyable. I got a lot out of this course. -Office365 Beginner Parramatta
Renee - Office365 Beginner, .
Instructor didn't take a linear path through the workbook, but did manage to cover all area, it was good to see pragmatic approach to student learning -Power BI Advanced Sydney
Stuart - Power BI Advanced, .
Very well explained. -Office365 Beginner Parramatta
Felicity - Office365 Beginner, .
Thoroughly enjoyable. John moved quickly through examples, but not too quick for people to get lost. Very happy that the group was very capable. -Excel Advanced Melbourne
Matthew - Excel Advanced, .
Thank you John for the very informative and interesting course! I learn a lot of useful tricks on how to improve my excel skills on a day to day basis. -Excel Advanced Melbourne
Maria - Excel Advanced, .
Great course -Office365 Beginner Parramatta
Courtney - Office365 Beginner, .
John was really good, going through the content clearly and in a way for us novices to understand the steps involved in different processes. -Excel Advanced Melbourne
Benji - Excel Advanced, .
Helpful and interactive, but intensive -Excel Advanced Melbourne
Oussama - Excel Advanced, .
Nice presentation Covered interested topics -Excel Advanced Melbourne
gunjan - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia