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
North York Central Library, Room 1
5120 Yonge Street, Toronto, ON
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.
Fees: CCPAA Member: Free; Non-CCPAA Member: $10
Seat limitation and enrolment:
R.V.S.P.to firstname.lastname@example.org 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