This course covers date and time functions such as NOW, TODAY, DATE, and NETWORKDAYS. Logical and IF-type functions help you make decisions. This course also covers IF, AND, OR, AVERAGEIFS, COUNTIFS, and SUMIFS.

For an optimal experience please check the minimum computer system requirements.

This online course forms part of the SkillsNet short course suite.

Please note this course is only available to CPA Australia members.

Learning objectives

  • Use date and time functions in Excel 2013
  • Decide how to use date and time functions in Excel 2013
  • Use logical functions in Excel 2013
  • Choose the logical functions to use in Excel 2013
  • Transpose data in Excel 2013
  • Look up data with functions in Excel 2013
  • Decide how to look up data with functions in Excel 2013
  • Trace errors in Excel 2013
  • Decide how to trace errors in Excel 2013

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

60 Minutes

365 Days

loading...