Community Search
Find a CPB   |   CPB Certification   |   Annual Conference   |   Print Page   |   Contact Us   |   Sign In
IPBC Webinar: Excel Magic
Tell a Friend About This EventTell a Friend

When: Thursday, June 22, 2017
1:00 to 2:00 p.m. (PDT)
Where: On-Line
Contact: Anita Andriash

Online registration is closed.
« Go to Upcoming Event List  

Presented by Alan Salmon, FCPB

How much do you know about Excel and the features and functionality it provides that could make a difference in your productivity? Most bookkeepers use less than 20% of the functionality of this product. Are you taking advantage of the features that are best for you? This webinar is sure to deliver many thought-provoking ideas and tips for getting better results with less effort and in less time.

Major Topics:

· Productivity Tips and Tricks
· Formatting Essentials

Learning Objectives:

· Utilize features such as freeze panes and split windows to optimize the working environment in Excel;
· Identify and select cells with specific characteristics;
· Implement alternate means for adding data to a worksheet, including Paste Special, date and time stamps, Custom Fill Lists, AutoCorrect, and Fill Cells with a Series;
· Enter and copy formulas more efficiently, open workbooks with ease, and group data for presentation purposes; and
· Implement features such as Format Painter, Wrap Text, Indent, the Hidden
Format, and the Accounting Format to improve the appearance of Excel-based reports;
· Create and apply Custom Formats to Excel data;
· Utilize Styles to facilitate consistent formatting in and across Excel documents;
· Manage rounding issues in Excel with the Precision as Displayed feature; and
· Apply Conditional Formats to Excel data to call attention to significant trends and variances and to data points requiring management attention and follow-up.

Presenter's Bio:

Alan Salmon is recognized as Canada’s leading analyst in the area of accounting technology. He has over 27 years of business, management systems, education and journalism experience.

As the Managing Director of K2E, he is responsible for the Canadian operations of this international consulting group, which provides professional development technology education for accountants across Canada and the US.

He has a degree in Science and an Advanced Teaching Certificate from the University of Toronto. He has taught over 100 seminars a year to the CA, CGA and CMA associations in Canada. Alan has now retired from teaching and manages K2E Canada Inc.

He has received many awards for teaching and service, including a Luca award from ICB-Global, a Paul Harris Fellowship, a Melvin Jones Fellowship, the Canadian Internet Award and a life membership in Junior Chamber International.




*Attending this webinar qualifies for one Professional Development Credit* 






Value Pricing

Contact Us

Mission Statement


CPB Certification


Black Swan Project


Board of Directors

Regional Meetings

Member Offers

Who Should Join

Black Swan Blogs 

Membership Inquiries

Code of Conduct

Annual Conference



Black Swan Alumni

General Inquiries


 Award Ceremonies

Member Links


CPB Certification

Resource Links

Code of Ethics Complaints

6 - 6150 Highway 7,- Suite 418, - Woodbridge, ON - L4H 0R6  1-866-616-4722   |   info@ipbc.ca