Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
* Selected Courses ONLY
$ 250*
Application:Excel
Level:Advanced
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 Advanced Course

   (4.81 out of 5)
1610 Excel advanced 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)
$ 250

Quick links

Excel Advanced Course

Course Overview

This is a one-day training course tailored to give intermediate Excel users a complete command of Microsoft Excel. Led by dedicated instructors who are fully versed in the Microsoft Office package, you’ll build upon your existing skills and embrace the more complex and technical aspects of Excel. We’ll teach you how to summarise large datasets quickly and confidently using PivotTables, protect data, validate data entry, audit formulas, implement logical functions, nest functions, utilise analytical tools such as Goal Seek and Data tables, create and manage templates as well as automating repetitive tasks using Macros and much more.

Raising the Bar sets a new industry standard for training courses. Our Excel training is delivered face-to-face by industry leading experts who use clear demonstrations and easy to follow instructions to help lead students to success. Our class sizes are small so that all students receive the required attention and achieve the best possible learning outcomes. We also supply all the equipment you need, so you can show up on the day without having to bring a thing. You’ll learn through clear hands-on activities and leave with brand new skills and knowledge of Excel that far exceeds your expectations.

At the end of the Excel Advanced course, you’ll receive a certificate of completion, a detailed course manual to work through at your own pace and the proficiency required to use Excel’s more complex functions.

Who Should Attend This Course

The Excel Advanced Training Course is designed especially for students who already have an intermediate knowledge of Excel and want to expand their skills beyond creating and formatting basic spreadsheets. This course is perfect for users who want to gain confidence and acquire an advanced level knowledge of Excel. It’s also great for companies looking to master spreadsheet creation and streamline services.

Typically, students who attend this course already have a good level of confidence with Excel and know how to create professional and productive spreadsheets. This course is right for you if you’re a relatively experienced Excel user who wants to learn how to report data using PivotTables and learn advanced formula creation, data protection, formula auditing and automation through the use of Macros.

Raising the Bar’s public training courses are available throughout the year in our Sydney CBD training centre. For students in other cities, training sessions are available by appointment for companies and organisations in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our advanced course is designed for experienced Microsoft Excel users. Students should have completed our Excel Intermediate course or have equivalent skills creating and formatting spreadsheets at an intermediate level. 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.

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
18-Jul-24 (Thu)$385.00 0
Limited Seats
26-Jul-24 (Fri)$385.00 0
08-Aug-24 (Thu)$385.00 0
15-Aug-24 (Thu)$385.00 0
20-Aug-24 (Tue)$385.00 0
28-Aug-24 (Wed)$385.00 0
05-Sep-24 (Thu)$385.00 0
13-Sep-24 (Fri)$385.00 0
25-Sep-24 (Wed)$385.00 0
03-Oct-24 (Thu)$385.00 0
18-Oct-24 (Fri)$385.00 0
30-Oct-24 (Wed)$385.00 0
14-Nov-24 (Thu)$385.00 0
29-Nov-24 (Fri)$385.00 0
11-Dec-24 (Wed)$385.00 0
18-Dec-24 (Wed)$385.00 0
09-Jan-25 (Thu)$385.00 0
15-Jan-25 (Wed)$385.00 0
30-Jan-25 (Thu)$385.00 0
05-Feb-25 (Wed)$385.00 0
13-Feb-25 (Thu)$385.00 0
26-Feb-25 (Wed)$385.00 0
12-Mar-25 (Wed)$385.00 0
26-Mar-25 (Wed)$385.00 0
02-Apr-25 (Wed)$385.00 0
17-Apr-25 (Thu)$385.00 0
30-Apr-25 (Wed)$385.00 0
15-May-25 (Thu)$385.00 0

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
18-Jul-24 (Thu)$250.00 0
ON SALE Limited Seats
26-Jul-24 (Fri)$385.00 0
08-Aug-24 (Thu)$385.00 0
15-Aug-24 (Thu)$385.00 0
20-Aug-24 (Tue)$385.00 0
28-Aug-24 (Wed)$385.00 0
05-Sep-24 (Thu)$385.00 0
13-Sep-24 (Fri)$385.00 0
25-Sep-24 (Wed)$385.00 0
03-Oct-24 (Thu)$385.00 0
18-Oct-24 (Fri)$385.00 0
30-Oct-24 (Wed)$385.00 0
14-Nov-24 (Thu)$385.00 0
29-Nov-24 (Fri)$385.00 0
18-Dec-24 (Wed)$385.00 0
09-Jan-25 (Thu)$385.00 0
15-Jan-25 (Wed)$385.00 0
30-Jan-25 (Thu)$385.00 0
05-Feb-25 (Wed)$385.00 0
12-Feb-25 (Wed)$385.00 0
13-Feb-25 (Thu)$385.00 0
26-Feb-25 (Wed)$385.00 0
26-Mar-25 (Wed)$385.00 0
02-Apr-25 (Wed)$385.00 0
17-Apr-25 (Thu)$385.00 0
30-Apr-25 (Wed)$385.00 0
15-May-25 (Thu)$385.00 0

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

Course Outline

CREATING A PIVOTTABLE

Creating A PivotTable

  • Create A PivotTable

Updating A PivotTable

  • Update The Information In A PivotTable
  • Adding Multiple Fields To The Row Area
  • Adding Multiple Fields To The Column Area
  • Arrange PivotTable Information
  • Remove A PivotTable Field
  • Filter A PivotTable
  • Remove A Filter
  • Filter A PivotTable Using A Filters Field
  • Clear the Filter
  • Change The Values Field Calculation
  • Format Data In A PivotTable
  • Managing Totals

PivotTables in Excel

  • Inserting A Recommended PivotTable
  • Filter Records Using Slicers
  • Selection Multiple Filter Criteria
  • Clear The Slicer Filter
  • Remove A Slicer

ADVANCED PIVOTTABLE FEATURES

Working With Calculated Fields In A PivotTable

  • Insert A Calculated Field
  • Working With The Values Field
  • Delete Calculated Fields
  • Changing PivotTable Options
  • Show Report Filter Pages
  • Show Detailed Data From A PivotTable Value
  • Show Different Calculations In PivotTable Value Fields

Value Field Calculation Options

Creating A Chart From A PivotTable

  • Create A PivotChart From A PivotTable

DATA VALIDATION AND PROTECTING DATA

Using Data Validation And Tracing Invalid Data

  • Validate Data Input
  • Compose A Data Input Message
  • Create An Error Alert Message
  • Circle Invalid Data

Protecting Worksheet Styles, Contents And Elements

  • Protecting A Worksheet
  • Unprotecting A Worksheet
  • Unlock Cells For Editing In A Protected Sheet
  • Hide A Cell Formula
  • Set A Password To Edit A Specific Range

Protecting Workbook Contents

  • Protect And Unprotect The Workbook Structure

Protecting Your Workbook From Unauthorised Users Access

  • Set A Password To Open A Workbook
  • Remove A Password From A Workbook
  • Set A Password To Modify A Workbook

WORKING WITH TEMPLATES

Creating A New Workbook Based On A Template

  • Create A New Workbook Based On A Template
  • Create A New Template
  • Create A New Workbook Based On Your Own Template
  • Editing A Template

FORMULA AUDITING

Auditing Worksheets And Tracing Cell References

  • Tracing Precedent Cells
  • Tracing Dependent Cells
  • Trace Cells Across Worksheets
  • Error Checking A Worksheet
  • Tracing Errors
  • Set Error Checking Options
  • Using The Watch Window
  • Showing and Hiding Formulas
  • Evaluate A Formula

USING ADVANCED FUNCTIONS

Using Financial Functions

  • The PMT Function
  • Nesting the PMT and ABS Functions

Editing Nested Functions

  • Applying Named Ranges To An Existing Formula

Using Logical Functions

  • Use A Logical Test
  • Use The IF Function To Return A Text Message
  • Use The IF Function To Return A Value
  • Nesting IF Functions
  • The OR Function
  • The AND Function
  • The COUNTIF Function

ANALYSING DATA

The Goal Seek Tool

  • Use The Goal Seek Tool

Exploring What-If Tables

  • Create A One Variable What-If Table
  • Create A Two Variables What-If Table

Using Scenarios

  • Create Scenarios
  • Add a Scenario
  • Displaying the Various Scenarios

Solver Tool

  • Load The Solver Tool Add-In
  • Use The Solver Tool

AUTOMATING ROUTINE TASKS WITH MACROS

Understanding Macros

Types of Macros

  • Show The Developer Tab
  • Record A New Macro
  • Run A Macro
  • Create A Run Macro Button On The Quick Access Toolbar
  • Create A Macro Command Button On A Worksheet
  • Edit The Command Button

Editing A Macro

  • Edit Macro Coding
  • Rename A Macro
  • Delete A Macro

Using A Relative Reference Macro

  • Record A Relative Reference Macro
  • Run A Relative Reference Macro
  • Saving a Macro Workbook
  • Open a Macro Workbook

Student Comments

  • Excel Advanced training course
    The course covers topics which are all very practicable and which we could literally apply to work straight away. Love the shortcuts taught, tricks and excel features which are so handy but you wouldn`t know otherwise unless you`re told.
    - Susie
  • Excel Advanced Training Course
    Sean once again very friendly, helpful and professional.
    - Luke
  • Excel Advanced Formulas training course
    The trainer went out of his way to make the course interesting by going into detail on topics we wanted to know more about.
    - Marcus
  • Excel Advanced training course
    Thanks Craig. Very approachable professional and friendly.
    - Philip
  • Excel Advanced Formulas training course
    Great Course, will be letting other work mates to come along!
    - Darren
  • Excel Advanced training course
    Craig was excellent! The content was interesting, useful and easy to follow. Would highly recommend!
    - Christina
  • Excel Advanced training course
    Craig is a really knowledgeable and helpful trainer and makes complex tasks and concepts easy to understand.
    - Maria
  • Excel Advanced Training Course
    No.. Good course and well worth the investment
    - Andrew
  • Excel Advanced training course
    Excellent course for refresher and good tips & tricks to apply for every day excel use.
    - Benny
  • Excel Advanced Formulas training course
    Excellent, solidified my knowledge from the previous sessions.
    - Tamlyn
  • Excel Advanced Formulas training course
    Would highly recommend the course for my colleagues who have a heavy reliance on microsoft excel
    - Carolyn
  • Excel Advanced Training Course
    Thank you very much. Once again I have thoroughly enjoyed the advanced excel course.
    - Sally
  • Excel Advanced Training Course
    Mandy was fantastic. Thanks
    - Palana
  • Excel Advanced training course

    - Lainie
  • Excel Advanced training course
    Great course Craig was very helpful and happy to offer additional assistance if required. Always checking if everyone was on the same page! Great work!
    - Brooke
  • Excel Advanced training course
    Craig is very knowledgeable and also willing to show practical examples on specific excel files we provided
    - Jasmine
  • Excel Advanced Formulas training course
    Craig is very knowledgeable helpful and friendly. Good course. Thank you!!
    - Merrilyn
  • Excel Advanced training course
    Thanks so much Craig - Mind blown!!!
    - Debbie
  • Excel Advanced Formulas training course
    Great facility, great presenter. very friendly
    - Jasmin
  • Excel Advanced Training Course
    Excellent articulation knowledge
    - alex
  • Excel Training Course Sydney - Advanced
    Wish I knew how to do some of these things years ago - it would have made my job so much easier. Great course.
    - Leanne
  • Excel Advanced training course
    Great course, Craig was great.
    - Charmaine
  • Excel Advanced Training Course
    Excellent course
    - Joanne
  • Excel Advanced training course
    THANK YOU! The manual is fantastic, it helped me follow what was happening as I need to write everything I learn to absorb it. I found the course extremely useful for my professional development.
    - Amy
  • Excel Advanced Formulas training course
    Great instructor, funny and enthusiastic and kept the whole class interested through out.
    - Lisa
  • Excel Advanced Formulas training course
    Really great course! Learnt so much!
    - Sarah
  • Excel Advanced Formulas training course
    It was really interesting to be able to build all these nested formulas and learn all the keyboard shortcuts!
    - Belinda
  • Excel Advanced training course
    Thank you Craig. I found your teaching style very interesting and easy to follow.
    - Sandra
  • Excel Advanced training course
    This is a good training and I really enjoy it.
    - Haixia
  • Excel Advanced Training Course
    I thought the course was great and Sean was a fantastic trainer I got a lot out of the course today
    - Ryllana

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us