Independent Contractors and Businesses Association (ICBA)

Microsoft Excel (Advanced)
Gold Seal: 1 Credit
Date
Tuesday, May 30th, 2017
Location
Accent Inn Burnaby
3777 Henning Drive
Burnaby, BC
V5C 6N5
Complimentary Parking
Google Map
Registration Deadline
Tuesday, May 30th, 2017
Early Bird Deadline
Register on or before Tuesday, May 16th, 2017 to receive special pricing.
Event Description

Save hours and minimize errors by learning how to manage data and reporting through tables and with the use of pivot tables, graph data and be able to make dynamic charts and identify trends with trend lines. 

 

Build error proof data entry sheets through the use of data validation techniques so that reporting is virtually error free. Learn to use advanced functions like Vlookup, If function and build complex nested functions with ease. 

 

Come with your questions and learn tips, shortcuts and how to program simple macros from a Microsoft Master Instructor.

 

The following list summarizes skills that participants will be comfortable with after this course.

  • Use advanced functions such as
    o Information
    o Lookup and reference
    o Conditional logic
    o Conditional summary
  • Add data validation, including using pick lists
  • Remove duplicate data; circle invalid data
  • Create, modify or remove a hyperlink
  • Work with shared workbooks
  • Add protection to workbooks and worksheets
  • Track changes
  • Use data analysis tools
  • Create and modify PivotTables or PivotCharts
  • Use slicers with PivotTables
  • Create and run Macros
  • Add form controls

This hands-on course is taught by a certified Microsoft Master Instructor. Participants will receive authorized Microsoft manuals and Microsoft approved practice exercises.

 

All participants will be provided with laptops for the course.

 

Max participants: 12

 

Contact & Support

For more information contact 604-298-7795.

Pricing
All prices in Canadian dollars
Ticket
* Early Bird Price Special
On or before May 16, 2017
Regular Price
After May 16, 2017
Attendee Registration For Workshop
ICBA Member $380.00 $420.00
Non-Member $470.00 $510.00
Agenda
8:00am - 8:30am
Registration
8:30am - 4:30pm
Workshop
Cancellation &
Refund Policy

COURSE REGISTRATION CANCELLATIONS, TRANSFERS & REFUNDS:

 

Cancellations received at least 10 business days prior to the course date will result in a full refund.

 

Cancellations received less than 10 business days but more than 5 full business days prior to the course date are subject to an administration fee of $100 for full and half-day seminars, or $25 for breakfast sessions.

 

Registrants who do not show up for a course, and/or who do not notify ICBA at least 5 full business days prior to the course date will be assessed the full cost of the course. There will be no refunds or credits in this case.

 

Substitution of attendees is permitted up to and including the day of the course.

 

COURSE CANCELLATION BY ICBA:

 

ICBA may have to postpone or cancel courses due to insufficient enrolment, in which case ICBA’s liability will be limited to a refund of the registration fee.

 
^ Back to Top