Loading Events

« All Events

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. 

REGISTER NOW

Add to your calendar:

Details

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

Venue

Online virtual event
Online

Additional Info

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