$55

Microsoft Excel: Lookup and Reference functions - Snap 2.5 hour Seminar

Event Information

Share this event

Date and Time

Location

Location

Greater Toronto Area

Toronto, ON

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Microsoft Excel: Lookup and Reference functions - Snap 2.5-hour training seminar

Saturday, May 12, 2018; Duration: 2.5 hours (10:30 pm - 1:00 pm)


About the seminar: No gimmicks, just snap action, 2.5-hour intensive training is for busy MS Excel users who do not have the time to sit for a long session. Participants will learn to use "Lookup" and "Reference" functions and use those in calculation formulas. Lookup functions are set of functions enables the user to bring specific data from another table /file; and Reference functions allow to bring the cell addresses, by combining these functions with other MS Excel functions substantial efficiency in data linking and summarising is accomplished. Throughout the course, the instructor will provide numerous tips. Designed for Professionals with intermediate level MS Excel skills working in different departments, e.g. Marketing, Administration, Shipping, Accounting, Finance, Human Resources. Students are welcome to join. Only Ten [10] participants for this event. If you know how to write a basic MS Excel formula using Sum function, then this course is for you!



Required computer setup: Participants need to have MS Excel installed on their computers, and should be able to join the Webinar via the internet. Applicable MS Excel Versions: 2010, 2013, 2016

Key Functions covered: Vlookup, Hlookup, Index, Match, Offset, Indirect and combining multiple functions for efficient data processing. Tips will include Absolute, Relative and Dynamic referencing

Delivery Method: Instructor-led, Live Online Webinar

Registration fee includes A practice workbook, PDF booklet and Certificate of attendance, Follow-up email support.

Location: Greater Toronto Area, Ontario, Canada


Refund: 7 days prior to the event

Session dates to be announced: Pivot Tables, Logical Functions, Information Presentation (Charts - Conditional formatting - Sparklines) and Dashboard

Customized training: Available on request. Contact us at (email) to arrange a date.

Questions? www.learningbudds.com click email button or post on the Facebook Page



Share with friends

Date and Time

Location

Greater Toronto Area

Toronto, ON

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved