Excel Macros for Beginners -Part 2 -Video

Price: $29.99

CPE Credits: 2.0

Category: , ,

Course Number: VCXMB2DR

macros

Description:
In this session Excel expert David H. Ringstrom, CPA builds on the concepts in Part 1 of this series to help you go beyond Excel’s Macro Recorder. David leads off with an introduction of Excel’s Goal Seek feature, and then uses that feature as the basis to explain the concepts of prompting a user for information, and then handling the various actions that could cause a macro to crash. The session then covers debugging techniques for identifying and resolving problems in your code, and then closes with expanding on the accounting report macro recorded in Part 2. You’ll see how to ask users yes/no questions, allow the user to select a file for a macro to process, and then offer a completion notification at the end of the macro.
David teaches from Excel 2010 in this session, but covers differences in Excel 2007, 2013, and 2016 where applicable. Excel 2003 is not addressed specifically other than onscreen notes on certain slides.

Topics typically covered:

• Add error handling features to Excel macros to compensate for unexpected or missing data entry inputs.
• By-pass the filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
• Gain an understanding of Excel’s Goal Seek feature, which is useful in simplifying what-if analyses.
• Learn how to play back macros that you’ve recorded so as to automate repetitive or tedious tasks.
• Learn the nuances of Macro-Enabled workbooks in Excel 2007 and later.
• Learn what to do next if a Debug prompt appears.
• See how to enable the Developer tab in Excel 2007 and later.
• See how to use Excel’s Macro Recorder to create simple macros without any programming knowledge required.
• Understand the nuances of assigning keyboard shortcuts to macros in Excel and avoid superseding shortcuts for built-in features.
• Use form controls to simplify data entry but also control user’s inputs.
• 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.

Level: Intermediate.

Version: David teaches from Excel 2010 in this session, but covers differences in Excel 2007, 2013, and 2016 where applicable. Excel 2003 is not addressed specifically other than onscreen notes on certain slides.

Prerequisites: Practitioners that have some experience with macros, or that have attended David’s Excel for Beginners Part 1 course.

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: October  2019

Format:  On-demand webcast ( video of a webinar)
Run-Time: 1 hr; 46 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:

  • Differentiate between Objects, Methods, and Variables.
  • Identify the color coding schemes used to identify error conditions in your programming code.
  • Recognize which method in Excel that can suppress unwanted prompts while a macro is running.

 

Description:
In this session Excel expert David H. Ringstrom, CPA builds on the concepts in Part 1 of this series to help you go beyond Excel’s Macro Recorder. David leads off with an introduction of Excel’s Goal Seek feature, and then uses that feature as the basis to explain the concepts of prompting a user for information, and then handling the various actions that could cause a macro to crash. The session then covers debugging techniques for identifying and resolving problems in your code, and then closes with expanding on the accounting report macro recorded in Part 2. You’ll see how to ask users yes/no questions, allow the user to select a file for a macro to process, and then offer a completion notification at the end of the macro.
David teaches from Excel 2010 in this session, but covers differences in Excel 2007, 2013, and 2016 where applicable. Excel 2003 is not addressed specifically other than onscreen notes on certain slides.

Topics typically covered:

• Add error handling features to Excel macros to compensate for unexpected or missing data entry inputs.
• By-pass the filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
• Gain an understanding of Excel’s Goal Seek feature, which is useful in simplifying what-if analyses.
• Learn how to play back macros that you’ve recorded so as to automate repetitive or tedious tasks.
• Learn the nuances of Macro-Enabled workbooks in Excel 2007 and later.
• Learn what to do next if a Debug prompt appears.
• See how to enable the Developer tab in Excel 2007 and later.
• See how to use Excel’s Macro Recorder to create simple macros without any programming knowledge required.
• Understand the nuances of assigning keyboard shortcuts to macros in Excel and avoid superseding shortcuts for built-in features.
• Use form controls to simplify data entry but also control user’s inputs.
• 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.

Level: Intermediate.

Version: David teaches from Excel 2010 in this session, but covers differences in Excel 2007, 2013, and 2016 where applicable. Excel 2003 is not addressed specifically other than onscreen notes on certain slides.

Prerequisites: Practitioners that have some experience with macros, or that have attended David’s Excel for Beginners Part 1 course.

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: October  2019

Format:  On-demand webcast ( video of a webinar)
Run-Time: 1 hr; 46 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:

  • Differentiate between Objects, Methods, and Variables.
  • Identify the color coding schemes used to identify error conditions in your programming code.
  • Recognize which method in Excel that can suppress unwanted prompts while a macro is running.

 

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

    - Lily

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

  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet