Course Details close

Course Details

(inc GST)
$ 385
Sale Price:
(inc GST)
* Selected Courses ONLY
$ 250*
Duration:1 day
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel Intermediate Course

   (4.79 out of 5)
2901 Excel intermediate student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
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)
$ 250

Quick links

Excel Intermediate Course

Course Overview

This is a one-day training course tailored to teach current Excel users the intermediate features of Microsoft Excel. Lead by dedicated instructors who know the ins and outs of the Microsoft Office package, you’ll build upon your existing skills and learn valuable techniques to help you create more professional and productive spreadsheets. We’ll teach you how to manage data in multiple workbooks, use 3D formulas, apply range names, create tables and charts, use data outlining, review formulas and work with advanced formatting, style and themes. You’ll learn streamlined methods to develop reports and analyse and manipulate data quicker than you ever thought possible.

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 brand new skills to produce more professional and effective spreadsheets than ever before.

Upon completion of the Excel Intermediate 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 Intermediate training course is designed especially for students who want to enhance their existing Excel skills to go beyond creating basic spreadsheets. This course is perfect for those wanting to gain confidence before moving onto expert level tasks and for companies looking to improve efficiency through more advanced spreadsheet management.

Typically, students who attend this course are already familiar with the fundamentals of Excel and know how to create basic spreadsheets and are ready to take these skills to the next level.

This course is right for you if you want to learn how to manage large datasets, summarise data, create and edit complex formulas, apply more intricate formatting, create and present professional looking charts and work more effectively with existing worksheets and workbooks.

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

Course Prerequisites

Our Intermediate course is designed for current Microsoft Excel users, so prior knowledge of Excel is required. Students should have completed our Excel Beginners course or have equivalent skills entering data, creating basic formulas, formatting and printing spreadsheets. You will also need general computer skills using the Windows operating system.

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.

Public Course Dates

Course Date Price Add Course Qty Status
04-Dec-23 (Mon)$385.00 0
14-Dec-23 (Thu)$250.00 0
09-Jan-24 (Tue)$385.00 0
18-Jan-24 (Thu)$385.00 0
23-Jan-24 (Tue)$385.00 0
31-Jan-24 (Wed)$385.00 0
13-Feb-24 (Tue)$385.00 0
22-Feb-24 (Thu)$385.00 0
27-Feb-24 (Tue)$385.00 0
13-Mar-24 (Wed)$385.00 0
19-Mar-24 (Tue)$385.00 0
28-Mar-24 (Thu)$385.00 0
09-Apr-24 (Tue)$385.00 0
24-Apr-24 (Wed)$385.00 0
30-Apr-24 (Tue)$385.00 0
09-May-24 (Thu)$385.00 0
15-May-24 (Wed)$385.00 0
21-May-24 (Tue)$385.00 0
30-May-24 (Thu)$385.00 0
04-Jun-24 (Tue)$385.00 0
12-Jun-24 (Wed)$385.00 0
20-Jun-24 (Thu)$385.00 0
25-Jun-24 (Tue)$385.00 0

Virtual Course Dates (via Zoom)

Course Date Price Add Course Qty Status
04-Dec-23 (Mon)$250.00 0
14-Dec-23 (Thu)$250.00 0
09-Jan-24 (Tue)$385.00 0
18-Jan-24 (Thu)$385.00 0
23-Jan-24 (Tue)$385.00 0
31-Jan-24 (Wed)$385.00 0
13-Feb-24 (Tue)$385.00 0
22-Feb-24 (Thu)$385.00 0
27-Feb-24 (Tue)$385.00 0
13-Mar-24 (Wed)$385.00 0
19-Mar-24 (Tue)$385.00 0
28-Mar-24 (Thu)$385.00 0
09-Apr-24 (Tue)$385.00 0
24-Apr-24 (Wed)$385.00 0
30-Apr-24 (Tue)$385.00 0
09-May-24 (Thu)$385.00 0
15-May-24 (Wed)$385.00 0
21-May-24 (Tue)$385.00 0
30-May-24 (Thu)$385.00 0
12-Jun-24 (Wed)$385.00 0
20-Jun-24 (Thu)$385.00 0
25-Jun-24 (Tue)$385.00 0

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

Course Outline


Managing Data in Multiple Worksheets

  • Renaming Worksheets
  • Select Adjacent Worksheets
  • Selecting Non-Adjacent Worksheets
  • Enter Data Into Multiple Worksheets
  • Preparing the Summary Sheet

Using A 3-D Formula Across Worksheets

  • Enter A 3-D Formula Across Worksheets
  • Enter A 3-D Formula Across Worksheets Using A Function


Using Range Names

  • Define Names Quickly
  • Define Multiple Name Ranges
  • Insert A Name In A Formula
  • Enter a Named Range From a List
  • Using ‘Paste Name’ in Formulas


General Table Rules

Creating Tables

  • Create A Table
  • Change The Style Of A Table
  • Create A New Table Style
  • Show Or Hide Table Elements
  • Create A Calculation In A Table
  • Insert And Delete A Table Row
  • Resize A Table

Sorting Data

  • Perform A Simple Sort (quick sort)
  • Perform A Multi-Level Sort (more than one column)
  • Customise The Sort Order

Filtering Data

  • Enable / Disable The AutoFilter
  • Apply / Remove The Filter
  • Customise The Filter
  • Using A Search To Create A Filter
  • Convert A Table To A Range


Using The VLOOKUP Function

  • Range Names
  • Creating The Vlookup Formula
  • Using the Insert Function Wizard to enter the VLOOKUP
  • Using Vlookup Functions To Assist with Data Entry
  • Use The Closest Match For The Lookup Value


Using Data Outlining

  • Create An Outline Automatically
  • Remove An Outline
  • Auto Outlining on Large Worksheets
  • Create An Outline Manually
  • Copy an Outline Using Visible Cells Only
  • Use A Subtotal To Create An Outline
  • Show / Hide Details Using Outline Symbols
  • Remove a Subtotal


Customising The Appearance Of Data With Advanced Formatting

  • Use The Built-In Number Formats
  • Custom Number Format Examples
  • Customise The Number Format
  • Customise The Date Format

Using Conditional Formatting

  • Use The Conditional Formatting To Highlight Cells
  • Use The Data Bars
  • Use The Colour Scales
  • Use The Icon Sets
  • Create New Rules
  • Edit Rules
  • Change The Precedence Of The Rules
  • Stop A Rule
  • Clear The Rules

Maintaining Format Consistency With Styles And Themes

  • Apply A Built-in Cell Style
  • Create A Custom Cell Style
  • Apply A Custom Cell Style
  • Modify / Delete A Cell Style
  • Apply A Theme


Creating A Chart

  • Insert A Chart
  • Move An Embedded Chart
  • Resize An Embedded Chart
  • Change The Chart Type
  • Add, Edit or Remove A Chart Data Source
  • Swap Labels In The Legend With The Horizontal Axis
  • Change The Order Of A Data Series
  • Move An Existing Chart To A New Worksheet

Modifying A Chart

New Features For Modifying A Chart In 2016/2013

  • Change A Chart Layout And Style (2010)
  • Change The Chart Title
  • Change The Axis Titles
  • Change The Legend
  • Insert Data Labels
  • Add A Data Table
  • Adding and Removing Gridlines
  • Insert A New Chart Element
  • Delete A Chart

Formatting A Chart

  • Select A Chart Element
  • Format The Chart Elements
  • Format Text In A Chart Using WordArt
  • Create A Picture Chart
  • Create A Combination Of Chart Types
  • Create A Pie Chart
  • Set The 3D Rotation
  • Explode A Wedge In A Pie Chart
  • Inserting Sparklines
  • Enhancing Sparklines

Student Comments

  • Excel Intermediate Training Course
    Very friendly and great tutor. Wonderful facilities. Extremely happy
    - Danielle
  • Excel Intermediate training course
    Usually training days can be not that helpful. I found this course very helpful. The course was run at a great pace and the instructor was clear and concise, and clearly new the content very well. I would most definitely recommend this course to others.
    - Stephen
  • Excel Intermediate training course
    great course with plenty of information and informations packs provided
    - Jayden
  • Excel Intermediate training course
    Craig was very knowledgeable and made things relatable.
    - Karen
  • Excel Intermediate training course
    Trainer explained concepts very concisely and created a very positive and fun learning mood throughout!
    - Suyi
  • Excel Intermediate training course
    Really great. Challenging to do a whole day online course. The presenter is very clear and engaging which enabled me to keep paying attention and participating.
    - Liz
  • Excel Intermediate Training Course
    Really well presented course - to be exposed to all that excel can do will greatly enhance my knowledge and will allow me to develop more comprehensive uses for excel.
    - Julie
  • Excel Intermediate Training Course
    Craig knows his stuff. Found the course to be excellent.
    - Ian
  • Excel Intermediate training course
    The trainer was really great, and the course content was well presented and easy to follow/understand
    - Cameron
  • Excel Intermediate training course
    The instructor was great and taught the material really well
    - Sogol
  • Excel Intermediate training course
    Very well run and learning friendly
    - Fong
  • Excel Intermediate training course
    Craig is a very good and professional trainer
    - Ruth
  • Excel Intermediate Training Course
    I found the size of the training group to be just right allowing the feel of a more personalised approach. The trainer was excellent and I will definitely be returning to complete the advanced excel course with this provider.
    - Toni
  • Excel Intermediate Training Course
    Excellent course - my neutral scores above are due to it being run in-house.
    - Nick
  • Excel Intermediate training course
    Great presenter! Made something I would normally find not so fun, actually fun!
    - Kathryn
  • Excel Intermediate Training Course
    Have had many excel trainers, Sean was by far the most enjoyable, experience and professional in his delivery of the course. Would like to do advance excel next.
    - Peter
  • Excel Intermediate training course
    The course was extremely useful and very clearly run. Was great to learn about multiple excel functions in depth, and also learn great tips along the way.
    - Lewis
  • Excel Intermediate training course
    Found Craig very patient and strongly know the subject. The Course content is very engaging given there was a lot of content and quite long hours.
    - Iuri
  • Excel Intermediate Training Course
    Was fantastic - a little slow at times, but only to accommodate for someone who was not at the correct level.
    - Lara
  • Excel Intermediate Training Course
    Great course. Fantastic trainer
    - Ellen
  • Excel Intermediate Training Course
    Great to have a trainer who was so knowledgeable (especially with tricky questions) and happy to share knowledge, and who connected so well with our class.
    - Stephanie
  • Excel Intermediate Training Course
    - Kay
  • Excel Intermediate Training Course
    A well lead instruction and update on excel
    - David
  • Excel Intermediate Training Course
    No, was fantastic, thank you
    - Steve
  • Excel Intermediate training course
    Craig is an excellent teacher very clear to understand patient and also very skilled at demonstrating virtually which isn't always easy to do.
    - Michele
  • Excel Intermediate training course
    Craig was a great teacher and was well explained! Highly recommend!
    - Corey
  • Excel Intermediate training course
    This was excellent I have always feared excel and often would get lost or confused. Craig was outstanding it was great that he showed his screen and then we get to do this with examples ready to work from. He was clear and concise great pace and time to practise. His top tips and short cuts were brilliant too. Craig's time management was great and breaks were perfect timing too. The manual is a great go to guide too. A very valuable course.
    - Jayne
  • Excel Intermediate training course
    Great course to learn useful tips and tricks which makes our jobs pretty easy when it comes to excel.
    - Pavithra
  • Excel Intermediate Training Course
    Tom is an excellent instructor. Clear and interesting.
    - Aisha
  • Excel Intermediate training course
    great course content and easy to understand!
    - Matthew

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

1300 937 782 Contact us