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.

 

  • Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

    - Connie K.

  • Thank you for providing very informative CPEs. I have enjoyed your courses for years now. Yours is truly my go-to CPE sources.

    - Lily

  • ” I was able to get a head start on my credit losses research through your CPE self study this past weekend.  Excellent quality format – so much better than some of the other resources I’ve been using lately.”  Dec 12, 2018

    - Andrea Ll.