[Ontario Chapter] Microsoft Excel 2014 Workshop

Microsoft Excel Workshop (Intermediate and Advanced Level)

Canadian-Chinese Professional Accountants Association (CCPAA) is going to hold an Excel Workshop (Intermediate and Advanced Level) on Sunday, May 11th 2014 in the North York Central Library.
The workshop will discuss the following Excel functions and features (attendees’ prior knowledge of VLOOKUP functions and IF function is required):

Ø Nested IF Functions to Handle More Complicated Business Scenarios

Nested IF functions use an IF function as one of the arguments of another IF function. You can nest up to 64 levels of functions.

Ø The Magical Approximate Match VLOOKUP That Looks Up a Range Instead of a Specific Value

Most people use VLOOKUP function for five or ten years, but never know about the approximate match of the Vlookup function, which looks for values in a range and return corresponding information for the range.

Ø Pivot Table to Quickly Summarize Large Volume of Data in One Minute

Pivot Table is an interactive table that automatically extracts, organizes, and summarizes your data. You can use it to analyze the data, make comparisons, detect patterns and relationships, and discover trends.

Ø Regression Analysis is Simple, Don’t Be Scared

Regression analysis can be very helpful for analyzing large amounts of data and making forecasts and predictions. The workshop will show you how to run regression analysis in Microsoft Excel.

Ø Array Formula Makes Impossible to Possible

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.

Date, time and agenda:
1:30 PM – 4:45 PM, May 11, 2014, Sunday
1:30 PM to 1:45 PM– Registration
1:45 PM to 3:00 PM – Excel Workshop – part 1
3:00 PM to 3:15 PM – Break
3:15 PM to 4:15 PM – Excel Workshop – part 2
4:15 PM to 4:45 PM – Networking

Venue:
North York Central Library, Room 1
5120 Yonge Street, Toronto, ON
M2N 5N9

Instructor: Steve Huang

Steve is the Excel instructor at Super Excel Inc. He has been teaching the Super Excel course for the past five years in GTA with more than 700 people who had taken the training. His Excel training focuses on functions and formulas to help people to process and analyze data effectively and efficiently.
Steve worked at LCBO as senior supply chain analyst for nine years, and worked at Wal-Mart Canada as distribution analyst for three years. Before coming to Canada, he worked as the civil engineer building bridges for five years in China.

Language: English

CPD Credit/Hour:1.5hours

Fees: CCPAA Member: Free; Non-CCPAA Member: $10

Seat limitation and enrolment:

R.V.S.P.to onconference@ccpaa.ca to register before 12 a.m., May 4, 2014.

Max limit of space: 30 persons.
When you register, please provide your contact email address which will be used to provide the training materials for the workshop in advance.

For the participants, we suggest you to bring your laptop to the workshop which you may need it to practice the functions taught by the instructor.

Visit www.ccpaa.ca to get more information. Please call us at 416-856-2830 if you have any questions.
*Online enrollment is available. http://www.ccpaa.ca/index.php?route=information/event

Meeting Fee(member): $0

Meeting Fee(no-member): $10