This course explores organising data in Excel 2013 using the built-in features. It also covers converting text to columns for easy of splitting text.

Excel 2013 provides multiple features for organising and managing data, including sorting and filtering tools that are essential to data analysis. Using data organisation features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Data tab allows you to present your data in a logical and easy to understand manner.

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

  • Sort data in Excel 2013
  • Group data in Excel 2013
  • Decide how to sort and group data in Excel 2013
  • Filter data in Excel 2013
  • Choose how to filter data in Excel 2013
  • Convert text to columns in Excel 2013
  • Decide how to convert text to columns 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 Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

60 Minutes

365 Days

loading...