Course Details close

Course Details

Price:
(inc GST)
$ 385
Application:Excel
Level:Beginner
Version:365
Duration:1 day
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
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)
1696 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)
$

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.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

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

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

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

View Course Dates

Face to Face (public course dates)

Online via Webinar (via Microsoft Teams)

Public Course Dates

Course Date Price Add Course Qty Status
23-Sep-24 (Mon)$385.00 0
01-Oct-24 (Tue)$385.00 0
16-Oct-24 (Wed)$385.00 0
29-Oct-24 (Tue)$385.00 0
12-Nov-24 (Tue)$385.00 0
27-Nov-24 (Wed)$385.00 0
09-Dec-24 (Mon)$385.00 0
16-Dec-24 (Mon)$385.00 0
07-Jan-25 (Tue)$385.00 0
13-Jan-25 (Mon)$385.00 0
28-Jan-25 (Tue)$385.00 0
03-Feb-25 (Mon)$385.00 0
11-Feb-25 (Tue)$385.00 0
24-Feb-25 (Mon)$385.00 0
10-Mar-25 (Mon)$385.00 0
24-Mar-25 (Mon)$385.00 0
31-Mar-25 (Mon)$385.00 0
15-Apr-25 (Tue)$385.00 0
28-Apr-25 (Mon)$385.00 0
13-May-25 (Tue)$385.00 0

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
23-Sep-24 (Mon)$385.00 0
01-Oct-24 (Tue)$385.00 0
16-Oct-24 (Wed)$385.00 0
29-Oct-24 (Tue)$385.00 0
12-Nov-24 (Tue)$385.00 0
27-Nov-24 (Wed)$385.00 0
16-Dec-24 (Mon)$385.00 0
07-Jan-25 (Tue)$385.00 0
13-Jan-25 (Mon)$385.00 0
28-Jan-25 (Tue)$385.00 0
03-Feb-25 (Mon)$385.00 0
10-Feb-25 (Mon)$385.00 0
11-Feb-25 (Tue)$385.00 0
24-Feb-25 (Mon)$385.00 0
24-Mar-25 (Mon)$385.00 0
31-Mar-25 (Mon)$385.00 0
15-Apr-25 (Tue)$385.00 0
28-Apr-25 (Mon)$385.00 0
13-May-25 (Tue)$385.00 0

Course Outline

GETTING STARTED

The Excel Screen

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

Backstage View

  • Using Backstage View
  • Opening An Excel File
  • Closing a File
  • Creating a New Workbook

Selection Techniques

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

Navigating Excel

  • Activate A Cell Using The Mouse
  • Move To A Cell Using The Keyboard
  • Move To A Cell Using The Name Box
  • Move Within A Selected Range
  • Insert a Worksheet
  • Move To Other Sheets Within A Workbook

Entering Data into 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

AutoFilling In Excel

  • Use AutoFill To Enter Months
  • AutoFill To Enter Days
  • AutoFill To Enter Dates
  • AutoFilling Numbers

Customising the AutoFill

  • Customise AutoFill
  • Deleting 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

Managing Workbooks

  • Save A Workbook For The First Time
  • Save Another Copy Using Save As
  • Save With A Different File Format
  • Save To Another Folder
  • Save To A USB
  • Close The Current Workbook
  • Open A Workbook

PERFORMING CALCULATIONS

Using A Simple Formula

  • Resize The Formula Bar
  • Enter A Formula Using The Keyboard
  • Using Manual Operators
  • Relative References
  • Absolute References
  • Applying an Absolute Reference

Using Simple Functions

  • Entering A Function
  • Use AutoSum To Calculate Totals
  • AutoSum and Manual Selections
  • Entering A Function
  • Use AutoComplete To Create Formulas
  • Turn Formula AutoComplete On Or Off
  • Insert Other Functions Using AutoSum Button
  • The Insert Function

Using AutoCalculate

  • Using AutoCalculate To Do A Calculation Without Using A Formula

MANAGING WORKSHEETS AND WORKBOOK INFORMATION

Managing Worksheet Information

  • Move Information Using Cut And Paste
  • Drag And Drop Information
  • Copy And Paste Information
  • Using Paste Options
  • Drag And Drop To Copy Information
  • Insert A New Row
  • Insert Multiple Rows
  • Delete Rows
  • Insert A New Column
  • Insert Multiple Columns
  • Delete Columns
  • Insert Cells
  • Deleting Cells
  • Rename A Worksheet
  • Add A New Worksheet
  • Move A Worksheet
  • Delete A Worksheet

FORMATTING WORKSHEETS

Adjusting Column Width / Row Height

  • Adjust The Column Width Using The Mouse
  • Adjust The Column Width Using The Menu
  • Adjust The Row Height Using The Mouse
  • Hide / Unhide Rows or Columns
  • Freeze Columns And Or Rows
  • Unfreeze Panes
  • Split A Worksheet Into Panes
  • Removing the Split

Formatting Cells Using The Ribbon

  • Change The Font
  • Change The Font Size
  • Make Text Bold
  • Italicize Text
  • Underline Text
  • Change The Font Colour
  • Align Data In A Cell
  • Indent Data In A Cell
  • Merge Cells
  • Wrap Text
  • Change Numbers To Percentages
  • Increase / Decrease Decimal Places
  • Copy A Format Using Format Painter
  • Fixing Display Problems

Formatting Cells Using The Format Cells Dialogue Box

  • Double Underline Using The Menu Option
  • Change Text Orientation
  • Wrap Text In A Cell
  • Format Numbers As Currency
  • Format Dates
  • Change The Background Colour Of A Cell
  • Add An Outline Border
  • Adding More Default Borders
  • Add A Double Line Border
  • Draw A Border Using The Mouse

SETTING UP A PAGE AND PRINTING

Setting Up A Page

  • Insert And Remove A Page Break
  • Set And Clear The Print Area
  • Change The Margin In The Page Layout View
  • Change The Page Orientation
  • Change The Scaling
  • Change The Paper Size
  • Change The Page Margin
  • Align To The Centre Of The Page
  • Add A Header / Footer

Previewing and Printing in Excel

  • View The Print Preview
  • Print Preview Options
  • Print Active Sheets
  • Print Selected Cells
  • Print Multiple Copies

Student Comments

  • Excel VBA Basic training course
    Very professional, knowledgeable and helpful in all aspects. Blended conventional training/instruction with real-world helpful examples with the utility and benefit of an excel forum.
    - Philip
  • Excel VBA Training Course - Basic
    I liked that fact that not too much was covered which can scramble your brains, but what we did do was in enough detail to get a good grasp.
    - Keegan
  • Excel Beginner training course
    I feel more confident in my ability to work with Excel and enjoyed the process
    - Fiona
  • Excel Beginner training course
    This course was well prepared and easy to understand. Thank you - excel is not so scary now.
    - Talitakumi
  • Excel Beginner training course
    Craig is a good & patient teacher
    - Deegan
  • Excel VBA Basic training course
    The course tracks closely to the notes which meant I could listen without having to take notes at the same time and the content covered a broad spectrum of concepts and ways VBA could be applied to real life scenarios. I felt almost everything covered was necessary in order to create foundation on which to learn properly.
    - Mike
  • Excel Basic Training Course
    Great feeling that I’m leaving with less hate towards excel.
    - Lydia
  • Excel Beginner training course
    Great course and very helpful
    - Matthew
  • Excel Basic Training Course
    It was a great course, mainly because I just love to learn and I have struggled with excel for so long. I really can’t fault anything. As far as "course content" I like to squeeze in as much as possible. Thank you very much. Martina
    - Martina
  • Excel Beginner training course
    Craig was very clear with what he was doing and moved at a pace that I could follow and went back if I got lost.
    - Christine
  • Excel Beginner training course
    Thanks Craig cleared up a lot of areas I struggled with.
    - Simon
  • Excel Beginner training course
    Feel more comfortable now with Excel instead of feeling a bit of dread every time I have to use the application.
    - Laura
  • Excel Basic Training Course
    Excellent course, well presented.
    - Ian
  • Excel Beginner training course
    Everyone should look at this course if using Excel.
    - Shaun
  • Excel Beginner training course
    Craig presented really well, knew the content and was able to keep the entire group engaged.
    - Hiba
  • Excel Course - Basic
    First few pages of very basic information but Craig was good at picking up on our skill level & moved on without wasting time. I thought the course flowed at a good pace & I really enjoyed it.. Thank you...:)
    - Anna
  • Excel Basic Training Course
    Fantastic course, very happy with the whole day
    - Susan
  • Excel VBA Basic training course
    Everything - it was better than I expected. It was enlightening. I have learnt so much in the three days. Thank you Craig
    - Jean-Guy
  • Excel VBA Basic training course
    Particularly enjoyed being able to bounce ideas off of Craig. I'm confident based on the real life examples Craig was able to provide that all parts of the course will be relevant.
    - Liam
  • Excel Course - Basic
    The course addressed all my objectives, my trainer was very professional and obviously knew his subject very thoroughly.
    - Leif
  • Excel Basic training course
    Easy to understand with a good presenter
    - Steve
  • Excel Beginner training course

    - Marie
  • Excel Basic Training Course
    Fantastic trainer who went at a pace we could all follow
    - Cameron
  • Excel Training Course - Basic
    The entire course was useful and very relevant to myself. I had no idea about excel prior to this course and I now have a basic idea, (which is why I came). I will definitely be returning to complete other subjects/courses on offer.
    - Hayley
  • Excel Beginner training course
    Craig was a great trainer, really helpful and explained everything really well
    - Tanya
  • Excel Basic training course
    Enjoyed the course.
    - Samantha
  • Excel Basic training course
    As someone who uses Excel on a daily basis, it was a fantastic refresher
    - Amy
  • 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
    Craig was very helpful and patient. I really benefited from today.
    - Danielle
  • 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

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us