Microsoft Excel Series - Part 2: Learn More about Macros
Instructor:
David H Ringstrom
Product ID: 704648
- Duration: 120 Min
Other Webinars in the Series:
Microsoft Excel Series - Part 1: Shake Hands with MacrosMicrosoft 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
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.
Refund Policy
Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
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. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar 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 [email protected] call +1-888-717-2436 (Toll Free).
