Webinar: Top Excel Tips and Tricks

WK254  |  Partner Virtual Events  |  Intermediate  |  Scheduled


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.


Number of Credits Type of Credits
2 Other


Good working knowledge of Excel


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




This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.


Member (Early Bird)
Non-Member (Early Bird)
Registration for this event has closed. If you have any question or concerns please give us a call at 615-377-3825 or send us an e-mail at registrar@tscpa.com


Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators