Microsoft Excel Functions Course

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

Microsoft Excel is one of the world’s most popular spreadsheeting software applications. Learn Microsoft Excel with Microsoft Excel courses in Sydney – created for you by the University of Newcastle.

The skills and knowledge acquired in this Microsoft Excel functions course are sufficient to be able 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 and are seeking a more in-depth understanding of key Excel functions.

Learning Outcomes

At the completion of this Microsoft Excel training 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 ODD and EVEN.
  • Using MROUND.
  • Using PRODUCT.
  • Using SUMIF.
  • Using SUMIFS.

Microsoft Excel Statistical Functions

  • Understanding Statistical Functions.
  • Status Bar Statistics.
  • Using COUNT and COUNTA.
  • 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 training course is ideal for anyone who has completed Microsoft Excel Course: Level 2 or for existing users familiar with Microsoft Excel functions and seeking to further expand their knowledge.

Delivery Style

This Microsoft Excel course is presented as instructor-led computer-based training 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 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.

Course Features

Available course dates

This course has no dates available. Be the first to know when we schedule more. Get notified.