This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency. Be taken through the useful features of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
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
- Identify the characteristics of functions in Excel
- Perform basic calculations using Excel's most commonly used functions
- Use financial functions
- Use date and time functions
- Use logical functions to help perform calculations on worksheet data
Audience
Individuals and business users with basic computer literacy
