Overview

This one-day course is appropriate if you have used Excel before and are reasonably confident with Excel basics such as simple formula creation, cell formatting, naming of cells, and saving and printing of workbooks.

Audience Profile

It is assumed attendees have good general computing skills, are familiar with the Windows environment and have attended an introductory course in Excel or have equivalent experience.

Course Completion

At the completion of the course you should be familiar with a number of techniques that enable the creation of more sophisticated workbooks. You should be able to create a protected workbook that incorporates embedded charts and use a range of data list management tools.

You will also be able to create well documented and consistently formatted workbooks and automate simple tasks.

Course Topics

• review of spreadsheet basics
• text boxes and drawing objects
• charting review
• worksheet comments
• worksheet and workbook protection
• naming cells
• linking worksheets and workbooks
• conditional formatting
• data list management (sorting, filtering, creating subtotals)
• PivotTables
• using lookup functions
• adding form control to worksheets
• data validation
• creating simple macros using Visual Basic for Applications

NOTE: This course will be given online however if you wish to do the session at Quill please contact us directly as spaces are limited due to the COVID-19 precautions that need to be taken.