Excel Expert Part 1: Forms and Functions
May 10 at 8:30 am - 4:30 pm$210
If you are experienced in Excel but need to start building more complex calculations and sequential operations, attend this advanced Excel course to learn how to assemble complex operations simply, one step at a time. Also learn to manage multiple sheets or multiple books and to apply protection, navigation and form controls.
Upon course completion, participants will be able to:
• Create, modify or remove a hyperlink; Use advance functions such as: information, lookup and reference, conditional logic, conditional summary.
• Work with shared workbooks;
• Add protection to workbooks and worksheets;
• Track changes;
• Consolidate data;
• Create and run macros;
• Add form controls; and
• Use advance functions such as: information, lookup and reference, conditional logic, conditional summary.
Course Prerequisites: This course assumes that learners have completed the Excel Core course or have equivalent knowledge.
Registration Note: When registering, please enter UBC as the company name under Contact Info for invoicing purposes, as we have negotiated preferred pricing for UBC staff in the amount of $210 + taxes.