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.

 

  • “It is rare that i can actually say that I enjoyed a CPE course but I found this one informative and very interesting, relying more on the author’s examples and not just quoting tax code!  [Healthcare Reform: The affordable Care Act Tax Provisions]

    - Thomas

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

    - Thank you :)

  • I wanted to compliment you on the Accounting Fraud – Recent Case Studies (AUCASEMC) course I just took. The ebook was fantastic! Concise, easy to understand, very well structured, and very interesting. Exactly the way I like it. Thank you for putting it together. I feel it took me enough time to be worth 2 CPEs, but it was fantastic nonetheless. Thank you.

    - Mark R.