Microsoft Excel Series - Part 2: Learn More about Macros

Instructor: David H Ringstrom
Product ID: 704648
  • Duration: 120 Min
Purchase option for this webinar is currently unavailable. Please contact our Customer Care for more info.

Customer Care

Fax: +1-650-362-2367


Read Frequently Asked Questions

This training program in the Microsoft Excel series will define how to adjust Excel’s macro security settings. Attendees will learn how to apply an enhanced understanding of Visual Basic for Applications (VBA) macros and also learn identify how to enhance the code you’ve created with the Macro Record feature. The program will discuss Excel’s Goal Seek feature, which is useful in simplifying what-if analyses and illustrate how to eliminate unwanted text using the Text to Columns feature.

Other Webinars in the Series:

Microsoft Excel Series - Part 1: Shake Hands with Macros
Microsoft Excel Series - Part 3: Beyond IF and Excel Macros
Microsoft Excel Series - Part 4: Creating Custom Excel Interfaces with UserForms

Why Should You Attend:

This second webinar in the four-part series will offer attendees a deeper understanding of Excel macros. Program participants will learn to create a macro that can automatically remove unwanted rows and columns from reports. They will also become aware of nuances involved in saving workbooks that contain macros, understand some of the risks involved with macros, and learn to avoid frustrations that can occur when using Excel’s Macro Recorder.

Learning Objectives:

  • Identify how to disable a line of programming code.
  • Define how to adjust Excel’s macro security settings.
  • Recognize which rows in a spreadsheet are affected when you filter data.
  • Apply an enhanced understanding of Visual Basic for Applications (VBA) macros.
  • List techniques, features, and keyboard shortcuts that will help you eliminate repetitive tasks.
  • Identify how to enhance the code you’ve created with the Macro Record feature.

Areas Covered in the Webinar:

  • Adding error-handling features to Excel macros to compensate for unexpected or missing data entry inputs.
  • Bypassing filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
  • Understanding how to enable the Developer tab in Excel 2007 and later.
  • Learning about Excel’s Goal Seek feature, which is useful in simplifying what-if analyses.
  • Playing back macros you’ve recorded so as to eliminate repetitive or tedious tasks.
  • Using form controls to simplify data entry as well as to control the input of other users.
  • Eliminating unwanted text using the Text to Columns feature.

Who Will Benefit:

  • Banking
  • Finance
  • Insurance
  • Education
  • Telecom
  • IT
  • CPAs
  • CFOs
  • Controllers
  • Marketing
  • Sales
  • Investments
  • Pharmaceutical
  • Medical Devices
  • FDA
  • Aviation
  • Energy
  • Retail
  • Human Resource
  • Logistics and Supply Chain
  • Accountants
  • Audit
Instructor Profile:
David H Ringstrom

David H Ringstrom
Owner, Accounting Advisors, Inc

David H. Ringstrom, CPA, is an author and nationally recognized instructor who inducts multiple webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.

Follow us :
Computer System Validation - Reduce Costs and Avoid 483s
FDA's New Import Program for 2018 - Strict Precision

Refund Policy

Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange.

Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time.

If you have any concern about the content of the webinar and not satisfied please contact us at below email or by call mentioning your feedback for resolution of the matter.

We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email call +1-888-717-2436 (Toll Free).

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed