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

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


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* 

 

About

Events

Benefits

Join IPBC

Value Pricing

Contact Us

Mission Statement

Webinars

CPB Certification

Overview

Black Swan Project

1-866-616-4722

Board of Directors

Regional Meetings

Member Offers

Who Should Join

Black Swan Blogs 

Membership Inquiries

Code of Conduct

Annual Conference

Benefits

Testimonials

Black Swan Alumni

General Inquiries

Privacy

 Award Ceremonies

Member Links

FAQ


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