| Excel Macro Basics (2-part series) | | | | | | | | June | | | | 9 & 10 | | 1 pm - 2:40 pm ET each day | | | Presenter: David Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. | | | 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 for 6 months, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | Excel Macro Basics: Part 1
June 9th, 2016, 1:00 PM to 2:40 PM, ET
In Part 1 of this practical two-part webinar series, you'll learn about the most powerful feature in Excel by far: the Visual Basic for Applications (VBA) macro. You'll learn how to use Excel's Record Macro feature to automate repetitive tasks, clean up reports exported from an accounting package, scrub data, and create your own keyboard shortcuts for Excel features. Upon completion of this course, you'll be able to: - Create Visual Basic for Applications (VBA) macros in Excel
- Define what an Excel macro is
- Apply the Hide and Unhide commands in an Excel Personal Macro Workbook as needed
- List actions you can take if you make a mistake while recording a macro
- Convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes
- Manage Excel's macro security prompts
- Describe how to use Excel's Personal Macro Workbook
- Explain how to use Excel's Macro Record feature to create simple macros
- Identify the risks of using merged cells in Excel worksheets
- Recognize how macros are used in Excel and the risks and benefits associated with them
- Use the Text to Columns feature to eliminate unwanted text without retyping and to separate text into columns
Excel Macro Basics: Part 2
June 10th, 2016, 1:00 PM to 2:40 PM, ET
In Part 2 of this two-part webinar series, you'll learn how to enhance the code you've created with Excel's macro recorder by adding error-handling features, decision-making capabilities, and interactive features. You'll also learn about additional techniques, features, and keyboard shortcuts that will help you eliminate repetitive tasks and become more proficient using Excel macros. Upon completion of this course, you'll be able to: - Apply the Macro Record feature to create simple macros
- Identify the steps to take if a Debug prompt appears
- Eliminate unwanted text using the Text to Columns feature
- 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
- Enable the Developer tab in Excel 2007 and later
- Describe Excel's Goal Seek feature
- Play back macros you've recorded to eliminate repetitive or tedious tasks
- Utilize Excel's Macro Record feature to create simple macros without having any knowledge of programming
- Identify the nuances of the Excel Macro-Enabled Workbook in versions 2007 and later
- Describe 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 and control the input of other users
- Use the Text to Columns feature to eliminate unwanted text without retyping or to separate text into columns
| | | | | | | | | | David H. Ringstrom, CPA, is the owner and founder of Accounting Advisors, Inc., a spreadsheet consulting firm. Mr. Ringstrom provides Microsoft Excel training and consulting services nationwide. He frequently publishes and presents on Microsoft Excel. Mr. Ringstrom is a graduate of Georgia State University. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 70 live webinars each month
● More than 600 on-demand courses | | | | | | | |
|
|
No comments:
Post a Comment