Title
Excel for Accountants
Status
Cancelled
When
9:00 AM - 4:30 PM
Location
Holiday Inn Express and Suites Kingston,
11 Benson Street,
Kingston, Ontario, K7K 5W2
Who can attend
All
Pricing
Personal Passport Price $280.00
Organization Passport Price $330.00
Member Price $420.00
New Member Price $420.00
Student Price $420.00
Public Price $520.00
CPD hours
420
Event type
Seminar
Event description
This event has now passed, please click here to view all available upcoming events and courses

Excel is the accountant's tool of choice for analyzing and reporting financial data, yet most accountants have never received any formal Excel training. As a result, many accountants use time-consuming and error-prone processes to complete everyday tasks.

This highly acclaimed course contains hundreds of tips, tricks, and techniques to improve your productivity. Its content is based on over twenty years of experience in delivering Excel training to accountants and on feedback from tens of thousands of accounting just like you. The course has six major areas of topical coverage: productivity tips and tricks, formatting essentials, customizing Excel, formula-building essentials, three-dimensional workbooks, and printing essentials. If you are an Excel user, regardless of your level of experience, and you have never taken a formal Excel training course for accountants, you need this course!

LEARNING OBJECTIVES:

  • Identify tips and tricks in Excel such as Freeze Panes, Split Windows, Selecting Cells with Special Characteristics, Using AutoCorrect, Adding Date and Time Stamps, Working with the Office Clipboard, and Paste Special and describe how to use each to increase productivity with Excel
  • Describe tools and techniques for formatting in Excel, including Multiline Column Headings, The Accounting Format, Custom Date and Number Formats, and Conditional Formatting
  • Identify opportunities to customize Excel and describe procedures for Customizing the Ribbon, Customizing the Quick Access Toolbar, Adjusting Excel’s Options, Using Templates to Increase Productivity, Modifying Excel’s Global Templates, and Working with Custom Themes
  • Describe Excel’s formula building tools, including Absolute vs. Relative Cell References, The Formula Tab, Performing Calculations on Dates, Splitting and Combining Text Strings, Using the Text to Columns Wizard, Working with Defined Names, Conditional Calculations, VLOOKUPs and HLOOKUPs
  • Describe how to link data from multiple Excel workbooks, including Creating Links, Handling Broken Links, Combining Single-Sheet Workbooks, Creating Sum-through Formulas and Rolling Reports
  • Define the process for printing data from Excel, including describing How to Adjust Various Print Settings, Using the Camera Feature to Create Report Forms, and Working with Custom Views to Automate Print Settings to Print Reports
  • WHO WILL BENEFIT:

    Accountants who want to learn how to use Excel more efficiently and effectively.

Special instructions
  • Participants will have access to sample data files.
  • Participants should have fundamental knowledge of Excel operations.
  • Group-live demo and discussion using color computer projection.
  • This course is “laptop friendly”, so feel free to bring your laptop equipped with Excel 2007 or above.
  • This course will be taught in Windows Excel 2016. Reference will be made to the differences between Excel 2016 and Excel 2013, 2010 and 2007.

Hard copy seminar material is NOT provided at seminars. More information can be found here..

Electronic material can be accessed one week prior to the program at https://pdlms.cpaontario.ca/ and should be downloaded in advance.

Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.

Speaker
Speaker Bio

K2E Canada Inc, and its US partner K2 Enterprises is the pre-eminent provider of technology-focused continuing professional education to accountants and other professionals in Canada and the United States. We offer seminars on Excel, Word, PowerPoint, Outlook and Access. In addition, our catalogue includes seminars on Internal Controls, Cloud Computing, Tech Tools to Prevent Fraud, Adobe PDF and overviews of current technology for accountants.

Karen Granville, Hons. BMath, is a Senior Associate with K2 Enterprises. Karen has an Honours Bachelor of Mathematics degree in Operations Research and Combinatorics and Optimization from the University of Waterloo, a Teacher Training Certificate in adult teaching from Durham College, and is also a Microsoft Office Specialist - Master Instructor. She has several years business experience in the oil industry, and has taught at many educational institutions.