Best Practices-Excel Worksheets

Price: $19.99

CPE Credits: 2.0

Category: ,

Course Number: CXBESTMC

best practices

Description:
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. Table of Contents

Delivery Method: Online QAS Self Study.

  • Level: Basic to Intermediate
  • Version: Excel 2010 through Excel 2016
  • Prerequisites: None
  • Advanced Preparation: None

Author: Joseph P. Helstrom, CPA

Publication: November 2014
Updated: February 2017

Format: PDF and Exercise Files
Pages: 87

 

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

• 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

 

Below are Customer’s Comments:
5 Star CPE Rating

Overall Course Rating: 5  – Angela B. 6/2018

“Excellent course material, very easy to follow and was a great refresher course” Overall Course Rating: 5:  John G. 1/2017

5 Star CPE Rating

“I found this to be better than basic.  At first, the book was very over viewed. However, as I proceeded, I found many tools useful and actually have not used any of these tricks or options before.  I think people who use excel a lot may find these helpful”- Kelly

” I did find some of this a little too basic (formatting the page for headers and footers as an example).
But I did really like the part about not embedding your calculations in a formula and the audit trail functionality. Even though I know it , it was a good reminder because it is easy to get lazy and not define the assumptions. – Sharon

“I like these Excel courses. The time is reasonable and the content is useful.” Pam P.

Description:
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. Table of Contents

Delivery Method: Online QAS Self Study.

  • Level: Basic to Intermediate
  • Version: Excel 2010 through Excel 2016
  • Prerequisites: None
  • Advanced Preparation: None

Author: Joseph P. Helstrom, CPA

Publication: November 2014
Updated: February 2017

Format: PDF and Exercise Files
Pages: 87

 

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

• 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

 

Below are Customer’s Comments:
5 Star CPE Rating

Overall Course Rating: 5  – Angela B. 6/2018

“Excellent course material, very easy to follow and was a great refresher course” Overall Course Rating: 5:  John G. 1/2017

5 Star CPE Rating

“I found this to be better than basic.  At first, the book was very over viewed. However, as I proceeded, I found many tools useful and actually have not used any of these tricks or options before.  I think people who use excel a lot may find these helpful”- Kelly

” I did find some of this a little too basic (formatting the page for headers and footers as an example).
But I did really like the part about not embedding your calculations in a formula and the audit trail functionality. Even though I know it , it was a good reminder because it is easy to get lazy and not define the assumptions. – Sharon

“I like these Excel courses. The time is reasonable and the content is useful.” Pam P.

  • “..may I say it is rarer that I ever have gotten a personal reply from a CPE Site! Glad I have found your site.”

    - Tom

  • Great course! Price was right and the material was very thorough.

    - Alex

  • “always love your site and prompt customer service !! ”  Dec. 2017

    - Thank you :)