Loading Events

« All Events

  • This event has passed.

Excel Expert Part 1: Forms and Functions

May 10, 2021 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. 

REGISTER NOW

Details

Date:
May 10, 2021
Time:
8:30 am - 4:30 pm
Cost:
$210

Additional Info

Registration/RSVP Required
Yes (see event description)
Event Type
Workshop/Course
Topic
Personal and Professional Development
Audiences
Faculty, Staff