Webcast: K2's Top Excel Tips and Tricks (XKTET117)
Register Tell a Friend About This EventTell a Friend
 

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

 Export to Your Calendar 7/13/2017
When: 07/13/2017
9:00 AM until 11:00 AM
Where: Webcast
K2
United States
Presenter: Mac McClelland


Online registration is available until: 7/11/2017
« Go to Upcoming Event List  

Acronym XKTET117
CPE 2 hours
Vendor K2 Enterprises
Category
Management
Level Intermediate
Prerequisite Good working knowledge of Excel
Adv Prep None
Yellow Book? No
Designed for Accounting and financial professionals who want to use Excel more effectively and efficiently
Registration
Member $79
CPA Non-Member $104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

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.

Objectives

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

Topics

  • 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