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

  • ” 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.

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

    - Thank you :)

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

    - Connie K.