Chat with us, powered by LiveChat

Best Practices — Excel Worksheets (STMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Basic/Intermediate
Credits
2
Qualifies For
IRS CPE



Price:  $19.99
Remember when you went to update last year’s budget projections and you wonder why certain formulas were there? Ever opened up a spreadsheet that someone else created and wondered: “What the heck?” Chances are they were put together on the fly rather than designed well. It takes a little bit of time up front, but it is definitely worth it. Take a look at this course as you set up your budgets and year-end financial information and it will pay dividends next year when you open them because you won’t need to wonder why that 10% is in cell J4 and why you can’t figure out what that formula in cell T300 is doing. This course provides step by step instruction and Excel practice exercises as well as answer files.

Additional information

Credits

2

Format

Self-Study Download

Company Code

Self Study

Yellow Book Approved

0

CFP Approved

0

IRS Approved

1

CTEC Approved

0

Field of Study Credits

Computer Software & Applications (Non-Technical) (2)

Field of Study Department

Computer Software & Applications (Non-Technical)

Course Version

2019-01

CPE Approved

1

Pre-requistes:

None

Knowledge Level:

Basic/Intermediate

Major Topics:

  • Overview of best practices for Excel


Learning Objectives:

  • Recognize worksheet practices and Excel features that promote data clarity 
  • Differentiate Excel features that help ensure calculation accuracy 
  • Define data validation tools, formula auditing tools, workbook passwords and worksheet and cell protection tools

Designed For:

All CPAs
Follow by Email
Facebook
Twitter
LinkedIn