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

  • Overall I was very pleased with the course. Previously I knew just enough about pivot tables to be dangerous. Now I see the power that they have and I feel much more confident using pivot tables. The course materials were very clear and well prepared. I’ll be looking at your website for future CPE hours.

    - Scott

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

    - Thank you :)

  • Your website was easy to navigate and informative.” “This was my first use of your resources but I’m sure it won’t be my last. Thank you for your excellent course material and succinctly stated instructions which expedited order and payment of course selection, completion of exam, and immediate availability of Certificate of Completion. A great experience. Thanks.

    - Draper