| Attend upcoming webinar and earn continuing education credits. | Excel Macro Basics (2-part series) | | | | | | | | July | | | | 16 | 1 pm - 2:40 pm ET
&
3 pm - 4:40 pm ET | | | Presenter: David Ringstrom, an author and nationally recognized instructor | | | Credits: CPE (Credit Details) | | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | Excel Macro Basics: Part 1
July 16th, 2018, 1:00 PM to 2:40 PM, ET
In this comprehensive webcast, Excel expert David Ringstrom, CPA, introduces you to Visual Basic for Applications (VBA) macros—one of Excel's most powerful features.
You'll learn how to use Excel's Record Macro feature to automate repetitive tasks and create your own keyboard shortcuts for Excel features. In addition, David demonstrates how to manage macro security prompts, how to use Excel's Personal Macro Workbook, and how to convert .XLS workbooks to the up-to-date .XLSX format.
After participating in Part 1 of Excel Macro Basics, you'll be equipped to begin using macros immediately to speed up your work in Excel.
Topics Typically Covered: - Convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes.
- Decipher and manage Excel's macro security prompts.
- Discover how to use Excel's Personal Macro Workbook.
- Learn how to use Excel's Record Macro feature to create simple macros, without having any knowledge of programming.
- Learn the risks and frustrations of using merged cells in Excel worksheets.
- Understand how macros are used in Excel, along with the risks and benefits associated with them.
Learning Objectives: - Apply Visual Basic for Applications (VBA) macros in Excel.
- Define how to use the Record Macro feature.
- Apply the Hide and Unhide commands in an Excel Personal Macro Workbook as needed.
Excel Macro Basics: Part 2
July 16th, 2018, 3:00 PM to 4:40 PM, ET
In Part 2 of Excel Macro Basics, Excel expert David H. Ringstrom, CPA, guides you beyond the basics of Excel's Record Macro feature. He demonstrates how to enhance the code you've created by adding error-handling features, interactive features, and decision-making capabilities.
In addition, David explains how to: - Filter based on cell contents.
- Simplify what-if analysis with Excel's Goal Seek feature.
- Play back recorded macros to eliminate repetitive tasks.
- Create simple macros with the Record Macro feature... and more.
Topics Typically Covered: - Add error-handling features to Excel macros to compensate for unexpected or missing data entry inputs.
- Bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
- Discover how to enable the Developer menu in Excel 2007 and later.
- Gain an understanding of Excel's Goal Seek feature, which is useful in simplifying what-if analyses.
- Learn how to play back macros you've recorded so as to eliminate repetitive or tedious tasks.
- Learn how to use Excel's Record Macro feature to create simple macros, without having any knowledge of programming.
- Learn the nuances of the Excel Macro-Enabled Workbook in versions 2007 and later.
- Learn what to do if a Debug prompt appears.
- Understand the nuances of assigning keyboard shortcuts to macros in Excel and avoid superseding shortcuts for built-in features.
- Use form controls to simplify data entry as well as to control the input of other users.
Learning Objectives: - Recall what to do if a Debug prompt appears.
- Apply Excel's Goal Seek feature.
- Define the benefits of adding error-handling features to macros.
| | | | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David'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. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,500 on-demand courses | | | | | | |
No comments:
Post a Comment