Excel Macros for Beginners -Part 1 -Video

Price: $29.99

CPE Credits: 2.0

Category: , ,

Course Number: VCXMB1DR

macros

Description:  In this session Excel expert David Ringstrom, CPA introduces one of Excel’s most powerful features. David will get you started with macros in Excel, which are a means of automating repetitive tasks. Part 1 of this series focuses primarily on the risks, opportunities, and nuances of Excel’s Macro Recorder. You can use this feature to automate simple repetitive tasks. This session gives you some foundational experience with macros in Excel, which you can build upon in Part 2 of this series. David teaches from Excel 2010 in this presentation but every aspect of the material applies equally to Excel 2007, 2013, and 2016.

Topics typically 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.

Level: Basic.

Version: David teaches from Excel 2010 in this presentation but every aspect of the material applies equally to Excel 2007, 2013, and 2016.

Prerequisites: A familiarity with Excel.

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: August 27, 2015

Format:  On-demand webcast. Powerpoint handout covering video is included as well.
Run-Time: 1 hr; 42 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:

  • Distinguish Excel macros from formulas and other Excel features
  • Use the Relative Reference feature to control aspects of Excel’s Macro Recorder
  • Identify the Excel feature that easily transforms text-based numbers to values

 

Below are Customers’ Comments:
“Excellent course. Instructor was easy to understand.” – Anonymous 11/2016
Overall Course Rating: 5 Stars  “Very good course!!” Linda M.

5 Star CPE Rating

Description:  In this session Excel expert David Ringstrom, CPA introduces one of Excel’s most powerful features. David will get you started with macros in Excel, which are a means of automating repetitive tasks. Part 1 of this series focuses primarily on the risks, opportunities, and nuances of Excel’s Macro Recorder. You can use this feature to automate simple repetitive tasks. This session gives you some foundational experience with macros in Excel, which you can build upon in Part 2 of this series. David teaches from Excel 2010 in this presentation but every aspect of the material applies equally to Excel 2007, 2013, and 2016.

Topics typically 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.

Level: Basic.

Version: David teaches from Excel 2010 in this presentation but every aspect of the material applies equally to Excel 2007, 2013, and 2016.

Prerequisites: A familiarity with Excel.

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: August 27, 2015

Format:  On-demand webcast. Powerpoint handout covering video is included as well.
Run-Time: 1 hr; 42 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:

  • Distinguish Excel macros from formulas and other Excel features
  • Use the Relative Reference feature to control aspects of Excel’s Macro Recorder
  • Identify the Excel feature that easily transforms text-based numbers to values

 

Below are Customers’ Comments:
“Excellent course. Instructor was easy to understand.” – Anonymous 11/2016
Overall Course Rating: 5 Stars  “Very good course!!” Linda M.

5 Star CPE Rating

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

    - Alex

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

    - Lily

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