This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and to use the sorting and filtering feature to manage and analyse data.

 Download pdf brochure

• Work with one or more workbooks at once
• Use a range of techniques to work with worksheets
• Adjust the sizing of columns and rows in a workbook
• Use a variety of viewing techniques to view worksheets
• Format cells in a workbook
• Understand and use absolute referencing in a workbook
• Use the fill technique to enter data into cells
• Use names and labels
• Use a range of logical functions
• Use the various Lookup functions
• Sort data in lists in a workbook
• Use autofilter to display data in lists selectively

• •    Use safe work practices
• •    Create databases
• •    Create database queries
• •    Use databases and a variety of functions