Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
* Selected Courses ONLY
$ 289*
Application:Excel
Level:Beginner
Version:365
Duration:1 day
Location:
Online via
Microsoft Teams
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel Beginner Course

   (4.84 out of 5)
1768 Excel beginner student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 1 day Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 289

Quick links

Excel Beginner Course

Course Overview

This is a one-day training course tailored to teach absolute beginners the basics of Microsoft Excel. Lead by dedicated instructors who know the Microsoft Office package like the back of their hands, you’ll gain a valuable understanding of the fundamentals of Excel and leave with the confidence to create formatted spreadsheets using basic formulas and shortcuts. We’ll familiarise you with the Excel platform so you can comfortably navigate your way around to enter data, perform calculations, manage information and format worksheets to develop well-designed, print-ready spreadsheets.

Raising the Bar training courses are delivered face-to-face by certified experts using clear, easy to follow instructions. We keep our class sizes small so that all students achieve the best possible learning outcomes and supply all equipment so there’s no need to bring anything. You’ll learn through clear demonstrations and hands-on activities and leave with the skills needed to use Excel in personal and professional settings.

Upon completion of the Excel Beginner course, you’ll receive a certificate of completion, a comprehensive course manual to work through at your leisure and the proficiency required to proceed to one of our more advanced Excel courses.

Who Should Attend This Course

The Excel Beginner Training Course is designed especially for students who have very little or no experience with Microsoft Excel. This course is perfect if you’re a self-taught Excel user or complete newbie who wants to gain a solid understanding of the Excel platform and learn how to create formatted spreadsheets from scratch.

Typically, students who attend this course are looking to familiarise themselves with the basics of Excel and learn how to apply these skills on a daily basis. It is as well suited to individuals wanting to learn how to create household budgets as it is to employees who require Excel skills as part of their job. This course is right for you if you want to understand the basic functions of Excel and learn how to enter data, manage information and format worksheets for future use or print. It’s also suitable to students who are simply looking to gain a greater understanding of the Microsoft Office package and strengthen their computer skills.

Raising the Bar public training courses are available throughout the year in our Sydney training centre, or via closed group training sessions for companies and organisations in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our course is designed especially for beginners, so no prior knowledge of Microsoft Excel is required. All you need is basic computer skills, a general understanding of the Windows operating system and the desire to advance your Excel proficiency to the next level.

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Course Manual

With each course we provide you with a comprehensive online course manual for you to practice post course.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Important Update!

All of our public courses are now all delivered online via MS Teams. We still conduct face to face training for local corporate and interstate customers with groups starting with as little as 3 people. Contact us to discuss your training requirements!

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
02-Dec-25 (Tue)$288.75 0
ON SALE
11-Dec-25 (Thu)$288.75 0
ON SALE
15-Dec-25 (Mon)$385.00 0
07-Jan-26 (Wed)$350.00 0
ON SALE
12-Jan-26 (Mon)$350.00 0
ON SALE
19-Jan-26 (Mon)$350.00 0
ON SALE
21-Jan-26 (Wed)$350.00 0
ON SALE
04-Feb-26 (Wed)$350.00 0
ON SALE
10-Feb-26 (Tue)$350.00 0
ON SALE
23-Feb-26 (Mon)$350.00 0
ON SALE
04-Mar-26 (Wed)$350.00 0
ON SALE
09-Mar-26 (Mon)$350.00 0
ON SALE
24-Mar-26 (Tue)$350.00 0
ON SALE
01-Apr-26 (Wed)$350.00 0
ON SALE
07-Apr-26 (Tue)$350.00 0
ON SALE
20-Apr-26 (Mon)$350.00 0
ON SALE
27-Apr-26 (Mon)$350.00 0
ON SALE
06-May-26 (Wed)$350.00 0
ON SALE
11-May-26 (Mon)$350.00 0
ON SALE
25-May-26 (Mon)$350.00 0
ON SALE
03-Jun-26 (Wed)$350.00 0
ON SALE
09-Jun-26 (Tue)$350.00 0
ON SALE
15-Jun-26 (Mon)$350.00 0
ON SALE
29-Jun-26 (Mon)$350.00 0
ON SALE
Training courses on sale now

Courses start
from $289 (inc GST).
Limited seats.
Book today!

Course Outline

GETTING STARTED

The Excel Environment

The Excel Ribbon

  • Contextual Tabs
  • Live Preview
  • The Quick Access Toolbar
  • Customise The Quick Access Toolbar
  • Removing Icons From The Quick Access Toolbar
  • Display the Quick Access Toolbar Below the Ribbon
  • Dialogue Box Launchers
  • Accessing The Shortcut Menu Using The Mouse
  • Working with Keyboard Shortcuts
  • Changing Views
  • Show And Hide Workbook Elements

Managing Workbooks Using the Backstage View

  • Using Backstage View
  • Opening An Excel Workbook (File)
  • Closing a Workbook (File)
  • Creating a New Workbook
  • Save A Workbook For The First Time
  • Saving Changes to a Workbook

Selection Techniques

  • Select A Single Cell
  • Select A Range of Cells
  • Select A Range Of Cells Using
  • Select Non-Adjacent Ranges
  • Select An Entire Column
  • Select The Entire Row
  • Select The Entire Worksheet

Navigating Excel

  • Activate A Cell Using The Mouse
  • Basic Keyboard Shortcuts for Navigating and Selecting
  • Move To A Cell Using The Name Box
  • Move Within A Selected Range
  • Insert a New Worksheet
  • Move To Other Sheets Within A Workbook

Entering Data Into A Worksheet

  • Enter Text Into A Cell
  • Edit The Contents Of A Cell
  • Edit Text In A Cell Using The Formula Bar
  • Replace The Contents Of A Cell
  • Delete The Contents Of A Cell
  • Undo And Redo Changes
  • Entering A Date In A Cell
  • Enter A Heading
  • Enter A Number As A Value In A Cell
  • Enter A Number As A Label In A Cell
  • Practice Task

AUTOFILLING DATA

AutoFilling Data In Excel

  • AutoFill a Series of Months
  • AutoFill Numbers
  • AutoFill a Series of Months
  • AutoFill Weekdays
  • AutoFill Other Timeframes
  • AutoFill Other Number Sequences
  • AutoFill Dates
  • Altering The Results After AutoFilling Using A Smart Tag
  • AutoFill Ordinal Numbers

Customising AutoFill

  • Customise AutoFill (Create a Custom List)
  • Delete a Custom List
  • Use A List To Enter Data
  • Enter Data into a Range of Cells
  • Fill A Range Of Cells With The Same Data

FLASH FILLING DATA

Flash Fill

  • Separate Data Using Flash Fill
  • Join Data Using Flash Fill
  • Change Case Using Flash Fill
  • Create Email Addresses Using Flash Fill
  • Flash Fill Initials
  • Separating Dates Using Flash Fill

PERFORMING CALCULATIONS

Using A Simple Formula

  • Resize The Formula Bar
  • Enter A Formula Using The Keyboard
  • Entering Cell References in Formulas Using the Mouse
  • Relative Cell References
  • Absolute Cell References
  • Applying an Absolute Cell Reference

Using Simple Functions

  • Entering A Function Manually
  • Use AutoSum To Calculate Totals
  • Practice Task
  • Entering A Function Using the Keyboard
  • Use AutoComplete To Create Formulas
  • Entering Other Functions Using the Extended AutoSum Button
  • Insert a Function Using the Function Library

Using AutoCalculate

  • Using AutoCalculate To Do A Calculation Without Using A Formula
  • Practice Task

MANAGING WORKSHEETS INFORMATION

Managing Worksheet Information

  • Moving Information Using Cut And Paste
  • Drag And Drop Information
  • Copy And Paste Information
  • Using Paste Options
  • Using the Paste Options Smart Tag
  • Drag And Drop To Copy Information
  • Inserting A New Row
  • Inserting Multiple Rows
  • Deleting Rows
  • Inserting A New Column
  • Inserting Multiple Columns
  • Deleting Columns
  • Inserting Cells
  • Deleting Cells
  • Rename A Worksheet
  • Add A New Worksheet
  • Move A Worksheet
  • Delete A Worksheet
  • Practice Task

FORMATTING WORKSHEETS

Adjusting Column Width / Row Height

  • Manually Adjust a Column Width
  • AutoFit a Column
  • Set The Column Width Using the Ribbon
  • Set The Row Height Using The Mouse
  • Hide Rows or Columns
  • Unhide Rows or Columns
  • Freeze Panes
  • Unfreeze Panes
  • Split A Worksheet Into Panes
  • Remove the Split

Formatting Cells Using The Ribbon

  • Change The Font Type
  • Change The Font Size
  • Make Text Bold
  • Italicize Text
  • Underline Text
  • Change The Font Colour
  • Align Data In A Cell Horizontally
  • Aligning Data In A Cell Vertically
  • Indent
  • Data In A Cell
  • Merge and Centre Cells
  • Wrap Text
  • Change Numbers To Percentages
  • Increase / Decrease Decimal Places
  • Format Numbers As Currency
  • Fixing Display Problems
  • Format the Date
  • Copy A Format Using Format Painter

Formatting Cells Using The Format Cells Dialogue Box

  • Double Accounting Underline Style
  • Change Text Orientation
  • Change The Background Colour Of A Cell
  • Add A Thick Bottom Border
  • Add a Top and Double Bottom Border
  • Add a Custom Border
  • Practice Task

PAGE SETUP AND PRINTING

Setting Up A Page

Previewing and Printing in Excel

  • View The Print Preview
  • Select The Printer
  • Print Multiple Copies
  • Page Layout View
  • Change The Page Orientation
  • Change The Scaling
  • Change The Paper Size
  • Add A Header And Footer
  • Insert A Page Break Using Page Break Preview
  • Change the Margins
  • Centring Content On The Page
  • Set And Clear The Print Area
  • Print Selection
  • Practice Task

INDEX

Student Comments

  • Excel Beginner training course
    I really enjoyed the course and Craig was very patient with me
    - Angela
  • Excel Basic Training Course
    Excellent course, well presented, very useful, thoroughly recommended
    - nick
  • Excel Basic Training Course
    excellent course, well presented, very useful, thoroughly recommended
    - nick
  • Excel Basic Training Course
    Fantastic course, very happy with the whole day
    - Susan
  • Excel Basic Training Course
    Fantastic. Thank you so much.
    - Diane
  • Excel Beginner training course
    I highly recommend.
    - Sophia
  • Excel Basic Training Course
    Very easy for us computer illiterate people like me to upgrade my skills, and I now feel able to work through my manual at my own leisure
    - Kerrie
  • Excel Basic Training Course
    I would like to say that the Staff here are Exceptional To your Business, Polite Easy to talk to and very helpful. Cheryl Mason
    - Cheryl
  • Excel Beginner training course
    Craig was a great instructor he explained everything in a way that I was never left confused and the pace of the course was extremely manageable to follow. Thank you!
    - Annalena
  • Excel Beginner training course
    Excellent trainer. Very knowledgeable accommodating and such a five star! I enjoyed the course very much!
    - Bernadette
  • Excel Beginner training course
    Craig was so very knowledgeable on Excel, but so patient with the students. Made me feel like it was OK to not quite get it the first time, and could ask questions or re-hash over something that was not quite understood the first time. Thanks Craig !
    - Lyndall
  • Excel Basic Training Course
    Our trainer was very professional and was able to address all aspects of queries and provide assistance. She was very comprehensive
    - Storm
  • Excel Basic Training Course
    Our facilitator, Caroline, was fantastic. Her methods and approach to teaching and explaining the course material kept me engaged and interested.
    - Alitia
  • Excel Beginner training course
    Manual was very helpful. This was an online course and Craig did a wonderful job at keeping all attendees engaged and was very accommodating for any questions that were asked. Craig was great! Look forward to doing the intermediate course in the near future.
    - Chantelle
  • Excel Basic Training Course
    Sean was a fantastic facilitator. He made me comfortable to ask questions about anything I didn't understand. His manner didn't make feel silly as I have in other computer training courses.
    - Sandra
  • Excel Beginner training course
    glad i enrolled enhanced on areas i knew little on.
    - Anna
  • Excel Beginner training course
    Great course easy to follow. Excellent presentation.
    - Joanne
  • Excel Basic training course
    Libby is very professional, definitely learnt a lot from her.
    - Roseanna
  • Excel Basic Training Course
    Trainer, staff and facilities were fantastic! Would love to come back for another course.
    - Natalie
  • Excel Beginner training course
    all good thanks Craig for the day
    - Paul
  • Excel Beginner training course
    The course was fantastic very useful. I was a bit worried that attending virtually would be challenging but the way the course was set up and the content organised made it very easy to practice the tasks as we went. Craig is very articulate and good at explaining concepts in a concise manner.
    - Maggie
  • Excel Beginner training course
    Very well organised and presented by Craig.
    - Gavin
  • Excel Basic training course
    Just to thank Craig for his patience and great teaching.
    - Maria
  • Excel Beginner training course
    It was great!
    - Kaitlin
  • Excel Basic Training Course
    Enjoyable but I just have to practice as I have not had any exposure on excel. Thank you .
    - Maria
  • Excel Basic Training Course
    Excellent course, well presented.
    - Ian
  • Excel Basic Training Course
    Craig was fantastic and we will definitely get him back out to do further training for the company
    - Kristie
  • Excel Beginner training course
    Knowledge of the trainer and examples given. Greatly related to common mistakes & errors beginner users may have.
    - Rui
  • Excel Beginner training course
    Well presented. Instructor was very knowledgeable. Although I have used excel before and am familiar with several aspects of it, I still learned a lot from the course as it was well structured.
    - Allan
  • Excel Beginner training course
    Thank you for your patience in teaching this over zoom with little interaction!
    - Megan

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us