ComplianceOnline

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-963-2556

Email: customercare@complianceonline.com

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 :
ComplianceOnline Banking Summit 2016 | Risk Management and Data Security - 80390SEM
ComplianceOnline Medical Device Summit 2017

Product Reviews

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

Best Sellers
You Recently Viewed
    Loading