Course Description

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 features to manage and analyse data.

Outcomes

At the completion of this course, participants will be able to:

• 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 techniques to enter data into cells
• Use a range of logical functions.