About this course

Are you using Microsoft Excel spreadsheets with calculations and want to expand your skills? Building upon Microsoft Excel Foundations, this course will equip you to become proficient with your own spreadsheets, making effective use of formulas, auto functions, and drop-down lists to aid data entry and management.

Delivered by an experienced Microsoft Office trainer (in person at our Rozelle Computer Training Lab), this course will help you enhance your productivity.

As a participant, on course completion, you will receive a manual to provide you with additional guidance for use in the workplace.

Who should attend?

This course is appropriate for any staff member experienced with Microsoft Excel who needs additional skills in formulas, functions, and lists.

What will you learn?

By the end of this course, you will be able to:

Use Microsoft Excel formulas to perform calculations – topics include:

1. Using the formula bar, cell content versus cell value
2. Fill down, when to use relative and absolute references
3. Precedents and dependents
4. Formula auditing
5. Error checking
6. Text to columns
7. What if analysis

Use Microsoft Excel functions to perform specific calculations or to return information about your spreadsheet data – topics include:

1. Autosum (), sum all rows and columns
2. Arguments – form and multiple arguments
3. Vlookup ()
4. Create names from list
5. Using names in functions
6. Text functions: Len, Left, Right, Mid, Find, Trim
7. Indirect-lookup and lookup

Use Microsoft Excel to perform list functions– topics include:

1. Design, auto complete, using pick lists, applying data validation, filling in gaps in data
2. Go to special
3. Freeze frames
4. Named areas

Apply now

Course Feedback

Previous participants in this program told us they would recommend this course to others and that they feel more confident working with Microsoft Excel formulas, functions, and lists.

“The instructions and tips were so helpful with building spreadsheets”.

“Having the manual to work and take home was a real bonus”.

“Trainer was excellent and really knew Excel”.