View Details/Register
View Details/Register
View Details/Register
View Details/Register
View Details/Register
CPA - small firm
CPA - medium firm
CPA - large firm
Other
Small Business Owner
Although Excel has a Macro Recorder for automating tasks and processes, there's a limit to what the Macro Recorder can do. Where the Macro Recorder's functionality ends, VBA takes over.
In this session you will learn how to create and edit macros using VBA rather than Excel's Macro Recorder. This webinar gets you started with VBA. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the Macro Recorder
Using the knowledge gained will save you, your colleagues and your customers hours of time by allowing you to automate any Excel-based task or process. If you've never used macros and VBA before and you'd like to learn about the basics of macros, VBA and automation, this webinar is for you.
Course Objectives
- Recap: Using the Macro Recorder to create a macro
- Running a macro
- Creating a button to run a macro
- Editing the macro
- Making your macros available to all your workbooks
- Writing a simple macro without the Macro Recorder
- Creating macros that run automatically
- Writing a simple macro from scratch using VBA
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, including Microsoft Office and Apple Mac.
In 2012 Mike founded theexceltrainer.co.uk, where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and, in his career, delivered hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate critical business tasks and processes.
- To receive CPE credit, you must register for the webinar before it starts.
- CPE is available to all eligible participants within 24 hours of each webinar.
- To receive CPE for multiple attendees, at least one person must sign up for the webinar. The post-webinar email contains a link to instructions for the proctor letter. Alternatively, you may log in to your account following the webinar and click on the MY ACCOUNT button to find a link to instructions. For paid courses, payment needs to be made for each attendee before credit will be issued.
NASBA Approved
CPAacademy.org (Sponsor Id#: 111889) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
CPAacademy.org 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222
About Our Presenter
In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials.
He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
- CPE Credits
- Support and FAQs
- Terms and Conditions
- Privacy Policy
- CPAwebengage, Inc.