CGA-BC Richmond / South Delta Chapter PD Seminar
Excel Workshop – Macro Training
Date: Saturday, May 25, 2013
Time: Registration & Breakfast: 8:00 a.m. – 8:30 a.m.
Seminar: 8:30 a.m. – 12:30 p.m.
Location: Executive Airport Plaza Hotel, Fraser Room, 7311 Westminster Hwy, Richmond
4 CPD Hours
Cost: Members $80, Non-members $100
($2 from each registration is donated to CGA-BC Educational Foundation
in support of CGA students and members in financial need)
Microsoft Excel is a powerful tool to use for managing your business. But this often requires tedious, repetitive and time consuming work to get the results you need. The macro or VBA feature is a powerful tool that can help you automate your work. In this seminar, you will gain hands-on experience creating your own macros. Some of the work we will be doing includes:
1. Create macros to improve productivity at the office by automating routine tasks. Some of the examples would include automatically printing all the worksheets in a workbook, searching and replacing text across all worksheets, manipulating data to create custom reports.
2. Using macros to extract data from a database such as MS Access to create reports and interactive dashboards with Pivot Tables.
3. Automatically consolidate data from multiple workbooks for reporting with the push of a button.
4. Creating custom User Forms to accept, display and validate data that users enter into Excel.
You should have an Intermediate level of knowledge in using Microsoft Excel.
Please bring a laptop with Microsoft Office 2007 or 2010 already installed.
A week or two prior to the seminar, a tutorial will be emailed out for participants to work on. This will probably take 1-2 hours to complete.
Speaker: Richard Jang, BCom,DipIT, MCP, CGA
Richard Jang has been providing software and computer networking support to international and North American clients for over 10 years. He has also presented many technical sessions on these topics at corporate conferences in the U.S. and overseas. He is the Director of Technical Services with Sage Software.
Photography and Video
As part of our coverage of CGA-BC events, participants may be videotaped, photographed and/or quoted, with or without attribution. If you object to being photographed or videotaped, please let one of the organizers know.
Note: Space is limited to only 35 people for this Excel Workshop.
Chapter Newsletter and RSS Feed
Please follow the link http://blogs.cga-bc.org/richmondsd/ for more info on future PD seminars and Chapter events of CGA BC Richmond/South Delta Chapter.
To automatically receive updates from The Monitor, Chapter Newsletter, please provide your email address through this link Get The Monitor delivered by email.