Microsoft Excel Functions Course

Microsoft Excel Functions Course

Microsoft Excel short courses in Sydney, open to everyone.

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

Microsoft Excel is one of the world’s most popular spreadsheet software applications. Learn Microsoft Excel with our Microsoft Excel courses in Sydney - 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. This includes navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening and 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.

Bring Your Own Device Option

This course is also available to participants who are seeking a BYOD (Bring Your Own Device) option for users of Windows or Mac devices. Participants are able to bring and use their own laptop provided that they have a recent version of the software installed on their device. BYOD course participants are required to contact us on 02 8262 6400 (Option 4) between 9AM to 5PM Monday to Friday to enrol in this course. This option may also be available for any classes currently marked as full.

About your instructor

Paul Neale

Paul Neale

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.


Get $25 off

Get $25 off

Apply for a $25 gift voucher to use toward your first enrolment.

Employer Sponsorship

Employer sponsorship

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

Payment

Need an invoice before your organisation can pay?

Request an invoice and enrolment for employees of your organisation.

Training

Training for groups of employees

Learn more about enterprise training for organisations.

Corporate Pass

Self service enrolment for organisations

Corporate Pass enables you to enrol participants with deferred payment.


Course Features

Available classes for Microsoft Excel Functions Course

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

The University of Newcastle, Sydney Campus is a leading provider of short courses in Australia, with industry qualified and experienced educators that bring up-to-date real-world skills directly to the classroom.