New Calendar View!
Content Provider
Theexceltrainer

Middle doxey mineraltree
Self-Study CPE
RESULTSCRM: LEVERAGING THE CONTACT "STANDARD SEARCH"
View Details/Register
OFFICETOOLS: DMS METHODS
View Details/Register
RESULTSCRM: CREATING AND USING "ADVANCED/NAMED SEARCHES"
View Details/Register
OFFICETOOLS: ASK US ANYTHING
View Details/Register
OFFICETOOLS: PROJECTS TIPS AND TRICKS
View Details/Register
RESULTSCRM: USING WORKFLOW FOR ACCOUNTING JOBS
View Details/Register
WINNING STRATEGIES FOR WORKING WITH THE GIG ECONOMY
View Details/Register
USING QB ONLINE ACCOUNTANT PRACTICE MANAGEMENT TOOLS TO ORGANIZE WORKFLOW
View Details/Register
5 "ZAPS" YOU CAN USE TO AUTOMATE YOUR PROCESSES
View Details/Register
EVOLVING COMMUNICATION THROUGH GROUP CHAT SOFTWARE
View Details/Register
AUTOMATE TIME-TRACKING TO SIMPLIFY PAYROLL
View Details/Register
Automatingexcel exceltrainer selfstudy

AUTOMATING EXCEL: AN INTRODUCTION TO VBA

CPE Processing Fee$15.00
Webinar TranscriptionN/A
Presentation Length Hour(s)1.5 hours
CPE1.5
Course LevelAdvanced
Instructional MethodQAS Self-Study
PrerequisitesNone
Advance PreparationNone
Recorded DateOct 08, 2018
Date OfferedOct 08, 2018
Series: Excel
Course Description

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

Not logged
Handout Materials
Presentation Slides
Additional Materials
VBA fundamentals
Excel samples
Review Questions
Review Questions
QUESTION 1: 1/1/0001 1 minutes
QUESTION 2: 1/1/0001 1 minutes
QUESTION 3: 1/1/0001 1 minutes
QUESTION 4: 1/1/0001 1 minutes
QUESTION 5: 1/1/0001 1 minutes
Frequently Asked Questions
  • CPAacademy self-study courses are online.
  • The self-study format allows you to a) access the material online 24/7 and b) study at your own pace.
  • Per NASBA guidelines, you have one year from date of purchase to complete each program.
  • Complete your final exam at any time and get graded instantly. You can retake the exam at no additional charge (unlimited attempts).
  • Print your own certificate of completion on the spot upon passing the exam.
  • Grading policies: a) courses have a minimum passing score 70% b) test takers will not be provided feedback on failed exams.
  • Upon achieving a passing score, test takers will be notified of the correct answers to the questions missed.

Loading ...

Loading ...
Linkedin
Theexceltrainer

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 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.
 

Nasba
Logo qas

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

Theexceltrainer
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 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.