This course explores organising data in Excel 2010 using the built-in features. It also covers arranging objects for better viewing as well as the use of hyperlinks to organise data.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
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 more than one column or row
- Create a custom filter
- Outline data using the Subtotal, Auto Outline, or Group commands
- Arrange objects on a worksheet page
- Recognise how you can arrange data to fit a specified page layout for printing
- Create a hyperlink
- Modify hyperlinks
- Sort and filter data
- Create an outline so you can group and summarise data
- Arrange objects on a page
- Create a hyperlink from a worksheet to a web page
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level.
