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 Window 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 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.


Seven great reasons to enrol in a short course with us

99.28% average satisfaction

Join thousands of satisfied participants who have completed short courses with us. Read what they have to say.

Small class sizes

Our small class sizes and personalised approach gives you greater access to a quality education. There’s plenty of opportunity to interact with your instructor and ask questions.

Modern facilities and equipment

We have spacious, modern, purpose-built facilities equipped with the latest technology.

Quality instructors

Our educators bring first-hand experiences and knowledge to your learning, incorporating cutting-edge practices from diverse industries.

For business, or for pleasure

Our courses help you to develop your skills and knowledge, whether it be for professional development or personal interest. We also offer customised training for organisations.

24/7 secure online enrolment

With enrolment available online 24 hours a day, 7 days a week, registering for a course is as easy as it is convenient.

Enrol as easy as 1-2-3

Pay for your course securely online in 3 simple steps: select your course, provide your details and select your payment method. It’s that simple. Organisations seeking payment other than via credit card can enrol participants using our Invoice Authorisation.

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.