This training is ideal for anyone who is currently using Excel who wishes to extend
their knowledge and skills beyond building simple workbooks. Participants should
have basic knowledge of Excel and know for example how to create and save an
Excel workbook, enter simple formulas and print and chart data.

Participants will learn how 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 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
• Plus more!

.