Microsoft Excel Functions Course

Microsoft Excel Functions Course

Short courses in Sydney CBD, open to everyone.

Learn to work smarter with your data with our Microsoft Excel courses in Sydney CBD.

Microsoft Excel is one of the world’s most popular spreadsheet software applications. Learn Microsoft Excel with our Microsoft Excel courses in Sydney CBD – short courses open to everyone.

This Microsoft Excel functions course is an advanced Excel course where you will learn to use a variety of Microsoft Excel functions, including logical functions, math functions, date and time and financial functions. This Microsoft Excel course is designed for those already familiar with how functions are used in Microsoft Excel or those who have completed Microsoft Excel Course: Level 2 (Intermediate) and are seeking a more in-depth understanding of key Excel functions.

Learning Outcomes

At the completion of this Microsoft Excel functions course you should be able to:

  1. Use logical functions to test whether a statement is true or false.
  2. Use a range of lookup and reference functions.
  3. Use maths functions to solve complex problems.
  4. Use a variety of statistical functions.
  5. Use a variety of financial functions to perform calculations.
  6. Use the date and time functions to perform calculations.
  7. Use a range of text functions.
  8. Use a range of information functions to test worksheet data.

Course Content

Microsoft Excel Logical Functions

  • Understanding Logical Functions.
  • Using IF With Text.
  • Using IF With Numbers.
  • Nesting IF Functions.
  • Using IFERROR.
  • Using TRUE and FALSE.
  • Using AND.
  • Using OR.
  • Using NOT.

Microsoft Excel Lookup Functions

  • Understanding Data Lookup Functions.
  • Using CHOOSE.
  • Using VLOOKUP.
  • Using VLOOKUP for Exact Matches.
  • Using HLOOKUP.
  • Using INDEX.
  • Using Match.
  • Understanding Reference Functions.
  • Using ROW and ROWS.
  • Using COLUMN and COLUMNS.
  • Using ADDRESS.
  • Using INDIRECT.
  • Using OFFSET.

Microsoft Excel Maths Functions

  • Understanding Maths Functions.
  • Using SQRT.
  • Using ABS.
  • Using INT.
  • Using TRUNC.
  • Using ROUND.
  • Using ROUNDDOWN and ROUNDUP.
  • Using ODD and EVEN.
  • Using CEILINGMATH.
  • Using MROUND.
  • Using PRODUCT.
  • Using SUMIF.
  • Using SUMIFS.
  • Using SUMPRODUCT.

Microsoft Excel Statistical Functions

  • Understanding Statistical Functions.
  • Status Bar Statistics.
  • Using COUNT and COUNTA.
  • Using COUNTBLANK.
  • Using COUNTIF.
  • Using MODE.
  • Using MEDIAN.
  • Using LARGE and SMALL Using STDEV.
  • Using VAR.

Microsoft Excel Financial Functions

  • Understanding Financial Functions.
  • Using PMT.
  • Using FV.
  • Using NPV.
  • Using PV.
  • Using RATE.
  • Using EFFECT.
  • Using NOMINAL.

Microsoft Excel Date and Time Functions

  • Understanding Date and Time Functions.
  • Using NOW.
  • Using HOUR and MINUTE.
  • Using TODAY.
  • Calculating Future Dates.
  • Using DATE.
  • Using Calendar Functions.
  • Using WEEKDAY.
  • Using WEEKNUM.
  • Using WORKDAY.
  • Using EOMONTH.

Microsoft Excel Text Functions

  • Understanding Text Functions.
  • Using the PROPER function.
  • Using the UPPER and LOWER functions.
  • Using the CONCATENATE function.
  • Using the LEFT and RIGHT functions.
  • Using the MID function.
  • Using the LEN function.
  • Using the SUBSTITUTE function.
  • Using the T function.
  • Using the TEXT function.
  • Using the VALUE function.

Microsoft Excel Information Functions

  • Understanding Information Functions.
  • Using the CELL Function.
  • Using the ISBLANK Function.
  • Using the ISERR Function.
  • Using the ISODD and ISEVEN Functions.
  • Using the ISNUMBER and ISTEXT Functions.
  • Using the TYPE Function.

Intended Audience

Providing comprehensive and thorough coverage of a variety of Microsoft Excel functions, including logical functions, math functions, date and time and financial functions, this Microsoft Excel course is ideal for anyone who has completed Microsoft Excel Course: Level 2 (Intermediate) or for existing users familiar with Microsoft Excel functions and seeking to further expand their knowledge.

Delivery Style

This Microsoft Excel functions course is presented as a practical, instructor-led computer-based course in a Microsoft Windows environment. You’ll have dedicated access to a computer exclusively for your use so you can follow instructor training and work through examples.

Course Prerequisites

This Microsoft Excel functions course assumes some knowledge of Microsoft Excel, including an understanding of how functions are used. An understanding of conditional logic, mathematics, statistics and financial concepts is assumed. You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending the Basic Computer Skills Course before attempting this course.

Paul Neale has had vast experience teaching all Microsoft Office applications from basic to advanced levels. His qualifications include Microsoft Certified Professional, Cert IV Workplace Training and Assessment, and Cert IV Small Business Management. He is an experienced Project Management and Team Leader. He is also an IT trouble-shooter, experienced in hardware assembly, network design, back-office apps and helpdesk support.

Discounts

Discounts

Available for alumni, concession cardholders, seniors, staff and students.

Employer Sponsorship

Employer sponsorship

Your employer may be willing to pay for your course. Find out more.

Gift Voucher

Gift voucher

A gift voucher makes the perfect gift to suit every special occasion.

Payment

Need an invoice to make payment?

Use our invoice authorisation to request one for your organisation.

Training

Training for groups of employees

Learn more about enterprise training for organisations.

CorporatePass

Self service enrolment for organisations

CorporatePass enables you to enrol participants with deferred payment.

Course Features

Available dates for Microsoft Excel Functions Course

No dates that suit you? Be the first to know when we schedule more. Join the waiting list.