Chat with us, powered by LiveChat

Excel Spreadsheet Auditing Strategies-Video

Price: $29.99

CPE Credits: 2.0

Category: , ,

Course Number: VCXAUDDR

excel auditing strategies

Description:  In this session Excel expert David Ringstrom, CPA shares techniques you can use to test the integrity of any Excel workbook. David demonstrates a number of often overlooked features in Excel that can help you quickly get the lay of the land in any spreadsheet. Techniques that David describes include: locating worksheets that can’t be found via Excel’s main interface; unlocking password-protected workbooks when the password isn’t known; identifying duplicates with Conditional Formatting; menu commands that identify cells with formulas or hard-coded values; and much more. In this presentation, David demonstrates techniques in Excel 2016, but where applicable notes any differences in Excel 2013, 2010, or 2007. Topics covered:

• Decipher and manage Excel’s macro security prompts.
• Discover how to use Excel’s Personal Macro Workbook.
• Learn the risks and frustrations of using merged cells in Excel worksheets.
• Learn what a macro is in Excel, along with the risks and benefits.
• See how to use Excel’s Macro Recorder to create simple macros without any programming knowledge required.
• Use the Text to Columns feature to eliminate unwanted text without retyping, or to separate text into separate columns.

Delivery Method: Online QAS Self Study. – Video

Level: Intermediate.

Version: David demonstrates techniques in Excel 2016, but where applicable notes any differences in Excel 2013, 2010, or 2007

Prerequisites: Experience working in Excel Spreadsheets

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: February 2017

Format:  On-demand webcast. Powerpoint handout covering video is included as well as the Excel file used in the video.
Run-Time: 1 hr; 41 minutes

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 the hidden formula tracing capability that turning off Allow Editing Directly in Cells enables.
  • Identify the keyboard shortcut that launches Excel’s Visual Basic Editor.
  • Recall how to manage iterative calculations (also known as circular references) within Excel workbooks.

 

Description:  In this session Excel expert David Ringstrom, CPA shares techniques you can use to test the integrity of any Excel workbook. David demonstrates a number of often overlooked features in Excel that can help you quickly get the lay of the land in any spreadsheet. Techniques that David describes include: locating worksheets that can’t be found via Excel’s main interface; unlocking password-protected workbooks when the password isn’t known; identifying duplicates with Conditional Formatting; menu commands that identify cells with formulas or hard-coded values; and much more. In this presentation, David demonstrates techniques in Excel 2016, but where applicable notes any differences in Excel 2013, 2010, or 2007. Topics covered:

• Decipher and manage Excel’s macro security prompts.
• Discover how to use Excel’s Personal Macro Workbook.
• Learn the risks and frustrations of using merged cells in Excel worksheets.
• Learn what a macro is in Excel, along with the risks and benefits.
• See how to use Excel’s Macro Recorder to create simple macros without any programming knowledge required.
• Use the Text to Columns feature to eliminate unwanted text without retyping, or to separate text into separate columns.

Delivery Method: Online QAS Self Study. – Video

Level: Intermediate.

Version: David demonstrates techniques in Excel 2016, but where applicable notes any differences in Excel 2013, 2010, or 2007

Prerequisites: Experience working in Excel Spreadsheets

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: February 2017

Format:  On-demand webcast. Powerpoint handout covering video is included as well as the Excel file used in the video.
Run-Time: 1 hr; 41 minutes

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 the hidden formula tracing capability that turning off Allow Editing Directly in Cells enables.
  • Identify the keyboard shortcut that launches Excel’s Visual Basic Editor.
  • Recall how to manage iterative calculations (also known as circular references) within Excel workbooks.

 

  • “..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

  • Your website was easy to navigate and informative.” “This was my first use of your resources but I’m sure it won’t be my last. Thank you for your excellent course material and succinctly stated instructions which expedited order and payment of course selection, completion of exam, and immediate availability of Certificate of Completion. A great experience. Thanks.

    - Draper

  • “Thank you for a high quality CPE resource. As a CPA in a small nonprofit, I find your library quite helpful to meet my needs. I appreciate the service.”- 

    - Cheryl