Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250
Application:Excel
Level:Advanced Formulas
Version:All-Versions
Duration:1 day
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
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 Formulas Course

   (4.68 out of 5)
218 Excel advanced formulas 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 Formulas Course

Course Overview

This is a one-day training course tailored to give experienced Excel users the skills required to use Excel’s most commonly used formulas. Lead by dedicated instructors who are experts in the Microsoft Office package, you’ll learn real world tips and tricks for creating and using advanced Excel formulas and functions. We’ll teach you how to enter common formulae using name ranges, sums and dates, utilise helpful functions including database functions, rounding functions, logical functions, financial functions, nesting functions and working up to array formulas and more.

Our courses are taught face-to-face using simple instructions, clear demonstrations and hands on activities. Class sizes are kept small to ensure students receive personalised support and achieve the highest learning outcomes possible. Training with Raising the Bar will provide you with brand new skills and knowledge of Excel, allowing you to create efficient spreadsheets using advanced formulas. We supply all the equipment so all you need to do is show up.

Upon completion of the Excel Advanced Formulas course, you’ll have the proficiency required to use Excel’s common formula functions. You'll also leave with a certificate of completion and a comprehensive course manual to work through at your leisure so you can further develop your skills at your own pace.

Who Should Attend This Course

The Excel Advanced Formulas Training Course is designed especially for students who already have an advanced knowledge of Excel and want to expand their skills to utilise more complex formula functions. This course is perfect for users who want to gain confidence to create, edit and troubleshoot the Excel formulas and functions that they currently utilise in their Excel spreadsheets and workflows.

Most students who attend this course are already comfortable with Excel and know how to use its more complex and technical features to create professional, productive spreadsheets. This course is right for you if you’re an experienced Excel user who wants to learn how to use nesting, name ranges, sum functions, count functions, date and time formulas, various database functions, audit formulas, arrays, concatenation and more.

Our public training courses are delivered throughout the year in the Raising the Bar training centre in North Sydney. Alternatively, private training sessions are available by appointment for organisations in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our course is designed for experienced Microsoft Excel users. Students should have completed our Excel Advanced course or have equivalent skills with the more complex functions of Excel and its associated tools. 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

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

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.

Course Dates

Course Date Price Add Course Qty Status
23-Aug-19 (Fri)$250.00 0
ON SALE
26-Sep-19 (Thu)$385.00 0
18-Oct-19 (Fri)$385.00 0
15-Nov-19 (Fri)$385.00 0
12-Dec-19 (Thu)$385.00 0
24-Jan-20 (Fri)$385.00 0
07-Feb-20 (Fri)$385.00 0
13-Mar-20 (Fri)$385.00 0
Training courses on sale now

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

Course Outline

COMMON FORMULAE

PEMDAS (BOMDAS) or (BEMDAS)

Named Ranges

  • Naming Ranges Individually
  • Creating Names in Bulk
  • Using Names in Formulas

Simple Formulae

  • Sum function
  • Average function
  • Min function
  • Max function
  • If function
  • Mode function
  • Large function

COUNT FORMULAE

  • Count function
  • Counta function
  • Countblank function
  • Countif function

DATE AND TIME FORMULAE

  • Today function
  • Now function
  • Day function
  • Month function
  • Year function
  • Networkdays function
  • Datedif function

LOOKUP AND REFERENCE FORMULAE AS WELL AS AN INTRO TO NESTING

  • Vlookup function
  • Hlookup function
  • Lookup function
  • Index And Nested Match functions

DATABASE FUNCTIONS

  • Daverage function
  • Dcount function
  • Dcounta function
  • Dmax function
  • Dmin function
  • Dsum function
  • Dget function
  • Dvar function
  • Dvarp function
  • Dstdevp function
  • Dstdev function

ROUNDING FUNCTIONS

  • Round function
  • Roundup function
  • Rounddown function
  • Ceiling function
  • Floor function
  • Int function

FINANCIAL FUNCTIONS

  • Rate function
  • Nper function
  • Pv function
  • Pmt function

OTHER USEFUL FUNCTIONS

  • Var function
  • Varp function
  • Stdev function
  • Stdevp function
  • Small function
  • Rank function
  • Text function
  • Upper function
  • Lower function
  • Proper function
  • Offset function
  • Median function
  • Isblank function
  • Istext function
  • Iserror function
  • Isnumber function
  • Istext function
  • Sumif function
  • Subtotal function

ARRAYS, CONCATENATION & MORE

Joining Results With Concatenation

Nailing More Nested Formulae

Array Formulae

  • Custom {Average(If)} function
  • Custom {Sum(If)} function
  • Custom {Min(If)} function

FORMULA AUDITING

Auditing Formulas

  • Auditing formulas

Locating And Resolving Errors

  • Using the formula checker to resolve errors

Finding Precedents

Student Comments

  • Excel Advanced Formulas training course
    Great Course, will be letting other work mates to come along!
    - Darren
  • Excel Advanced Formulas training course
    The facilitator Craig was nice friendly and a great teacher, service & quality was perfect. 10/10 from me.
    - Nouha
  • Excel Advanced Formulas training course
    Always good!
    - Lilian
  • Excel Advanced Formulas training course
    Tom was excellent presenter, fast and attention grabbing, i would definately recommend him to others, and would in fact request him.
    - Nelson
  • Excel Advanced Formulas training course
    Great... had good fun learning :)
    - Valerie
  • Excel Advanced Formulas training course
    Most of the Advanced Formulas were great and would impact positively on our work environment.
    - Laurence
  • Excel Advanced Formulas training course
    Fantastic base to go forward with, worked well to complete earlier training in Excel.
    - Emma
  • Excel Advanced Formulas training course
    The trainer was great, extremely helpful in keeping content relevant.
    - Kaila
  • Excel Advanced Formulas training course
    Excellent, solidified my knowledge from the previous sessions.
    - Tamlyn
  • Excel Advanced Formulas training course
    Great course! Learnt a lot of new tricks that will make some of my tasks much faster.
    - Bryce
  • Excel Advanced Formulas training course
    I found the course very helpful and informative. I learnt alot that I can use everyday in my role.
    - Kylie
  • Excel Advanced Formulas training course
    Learn`t heaps. Thanks Tom!
    - Dominique
  • Excel Advanced Formulas training course
    Great course. Would recommend.
    - Marc
  • 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 Formulas training course
    Thanks, the session was very helpful.
    - Yeri
  • Excel Advanced Formulas training course
    Alot was learnt over the period of the course. Very instructive & very informative, as well as easy to follow. It helps alot, too when you have an instructor that is well versed in the topic. I would commend Sean for his efforts.
    - Ben
  • Excel Advanced Formulas training course
    Bridging course between Adv xls which just does pivot tables and intro to VBA is great!
    - Nicole
  • Excel Advanced Formulas training course
    Tom is a great presenter and really talks us through the most difficult formulas.
    - Charles
  • Excel Advanced Formulas training course
    Excellent course well presented definitely recommend to other employees and friends.
    - Chris
  • Excel Advanced Formulas training course
    Excellent course!
    - Henry
  • Excel Advanced Formulas training course
    Awesome, thank you very much for the tips and tricks :)
    - Kylie
  • Excel Advanced Formulas training course
    Tom was great in really helping me understand the bits i had not previously got to grips with from the Excel course
    - Matt
  • Excel Advanced Formulas training course
    It was good being able to you data from my workplace to use for examples. Also tips about the general way in which you should organise (structure) your data.
    - Rodney
  • Excel Advanced Formulas training course
    Tom was an excellent trainer and knew his content with great explanations and examples.
    - Elizabeth
  • Excel Advanced Formulas training course
    great course!
    - Guy
  • Excel Advanced Formulas training course
    Delivered in easy to understand language, very professional and knowledgable. Has improved my confidence with formulas & functions.
    - Monique
  • Excel Advanced Formulas training course
    Great facility, great presenter. very friendly
    - Jasmin
  • Excel Advanced Formulas training course
    Very helpful course.
    - Sarah
  • Excel Advanced Formulas training course
    The course is very well organised and easy to follow. Thanks.
    - Yvonne
  • Excel Advanced Formulas training course
    The trainer was very professional and knew his stuff back the front. Very good and highly recommended.
    - Phil

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us