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.

 

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

    - Alex

  • “The author did a good job of setting forth the ethical standards contained in the California State Board of Public Accountancy Rules and the AICPA Code of Conduct.”

    - California Ethics Course

  • ” This was my first experience with CPASelfStudy.com and I was very impressed. I will definitely consider taking CPE through CPASelfStudy.com in the future.”   12/2017

    - Christopher Q.