Vermont Society of Certified Public Accountants
Cart: 0 items

Courses

K2's Excel Best Practices for CPAs - JUST CANCELLED!

« View All Courses Add to Calendar

Registration Closed

Member Price: $0.00
Non-Member Price: $0.00

Registration Closed view cart

Date/Time:
Jun 5, 2019, 8:30am–4:30pm
Venue:
Hampton Inn by Hilton Colchester (Colchester, VT 05446)
42 Lower Mountain View Drive
Colchester, VT 05446
Developer:
K2 ENTERPRISES

Objective

  • List critical spreadsheet design fundamentals
  • Identify techniques used to minimize data input errors
  • Utilize Excel’s Table feature as a foundational component of spreadsheets
  • Identify and implement three different techniques for consolidating data
  • Utilize various Excel features, such as Go To Special to solve specific spreadsheet issues
  • List and apply four techniques for sharing an Excel workbook and collaborating with others
  • Implement various techniques for auditing and error-checking Excel workbooks, including Trace Precedents, Trace Dependents, and Formula Auditing
  • Identify the advantages of working with Defined Names in Excel
  • List and apply six techniques for securing Excel data

Prerequisite

Fundamental knowledge of Microsoft Office Excel 2007 or newer

Advanced Preparation

None
back to list