Top Excel Tips and Tricks

Top Excel Tips and Tricks
K2E Canada Inc. presents a broad curriculum of technology-focused on-demand webinars. Participants who take these webinars will have the opportunity to learn from an award-winning team of instructors with literally hundreds of years of experience in helping professionals identify, address, and solve issues through the practical application of technology. Webinars address a variety of topics, including Excel, QuickBooks, PDFs, accounting solutions, and Microsoft Office.

NOTE: Course login details are normally sent to registrants within one week from date of registration.


Even in the newest versions of Excel, many time-tested, tried-and-true tips and tricks continue to provide great value to Excel users. This session will cover some of the top Excel tips and tricks based on twenty-five years of delivering continuing education to accountants and business professionals. Some of the tips covered include enabling global rounding to avoid the "one-cent" rounding error in Excel, using the Camera to create dynamic reports from multiple ranges, and using Data Validation to automate data entry and reduce error rates. Whether you are a new or experienced Excel user, don't miss this opportunity to improve your spreadsheet skills.


  • Improving worksheet accuracy with global rounding
  • Using AutoCorrect and Data Validation effectively
  • Producing reports in less time and with less effort
  • Pasting Excel ranges into Word without losing formatting
  • Identifying cells and ranges with formulas or other specific characteristics

Upon completing this course, you should be able to:

  • Describe how to use global rounding to eliminate rounding errors in Excel and eliminate positive and negative zeroes in worksheet reports
  • Explain the impact of the accounting format on underlines and cell alignment
  • Use the Camera to create dynamic reports from worksheet snippets and to paste Excel data into Word documents
  • Describe Data Validation and how to use it to automate data entry and reduce errors
  • Employ sum-through formulas more effectively using the SUM function rather than using an arithmetic formula

Good working knowledge of Excel
Program Level: Intermediate 
Advance Preparation: None 

Accounting and financial professionals who want to use Excel more effectively and efficiently

CPD: 2 Hours

4/1/2022 - 3/31/2023 11:59 PM