Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Excel Automation: Automating Tasks with Macros

Share

Summary

Duration: 60 mins

Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? Do you have a time-consuming Excel-based process that you want to automate? Do you want to control how Excel acts when a file is opened, closed, saved or printed? If the answer to any of those questions is "Yes", it’s time to learn how to create a macro.

Macros free up much time by automating routine tasks in Excel. They allow you to store the sequence of actions it takes to complete tasks, and therefore shorten time spent on tedious commands by the click of a button! In this session, you will learn how to record & edit macros, create macros that can be re-used across multiple files, and create macros that run automatically based on an action, such as opening or closing a file.


Topics covered:

  • Use the Macro Recorder to create a macro
  • Save a file as a macro-enabled Excel workbook
  • Different ways to run a macro
  • Edit an existing macro
  • Use the Personal Macro Workbook to use specific macros across all files
  • Run macros automatically when a file is opened
  • Why you should attend

    Being able to create and edit a macro is one of the must have skills for Excel users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. No more wasting time on repetitive actions in Excel!

    Who should attend

    This webinar gets you started with macros. It's aimed at intermediate-to-advanced users of Excel and is relevant to all industries and job roles.

    The training will be delivered using the latest version of Excel for Windows although much of the functionality is available in earlier versions of the application too.

    -

    About the Speaker

    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. Mike has produced nearly 200 written and video-based Excel tutorials, and 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.

    Purchase this On-Demand Workshop

    Excel Automation: Automating Tasks with Macros

    On-Demand $199 + applicable taxes
    more info
    For the live training(s) you've selected:
    You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
    For the on-demand training(s) you've selected:
    You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
    3 Workshop
    Bundle $300 + applicable taxes
    more info
    Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
    For the live training(s) you've selected:
    You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
    For the on-demand training(s) you've selected:
    You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
    One-year subscription (All Access Membership) $699 + applicable taxes
    more info
    With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
    For the live training(s):
    You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
    For the on-demand training(s):
    You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
    Add To Cart

    Guaranteed to be Good

    All training experiences include a 7-day 100% money-back guarantee.

    Full-Team Pass

    Simply share the invite link with your team so you can learn and grow together!

    Yours Forever

    The event recording and materials are yours to rewatch and share as you choose.

    Purchase This On-Demand Webinar

    Excel Automation: Automating Tasks with Macros

    On-Demand $199 + applicable taxes
    3 Workshop Bundle $300 + applicable taxes
    One-year subscription (All Access Membership) $699 + applicable taxes
    Add To Cart

    Guaranteed to be Good

    All training experiences include a 7-day 100% money-back guarantee.

    Full-Team Pass

    Simply share the invite link with your team so you can learn and grow together!

    Yours Forever

    The event recording and materials are yours to rewatch and share as you choose.

    HRCI Credits

    HRCI logo

    This program has been approved for 1 (HR (General)) recertification credit hour toward aPHRTM, aPHRiTM, PHR®, PHRca®, SPHR®, GPHR®, PHRiTM and SPHRiTM recertification through the HR Certification Institute. Learn more at hrci.org

    Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

    • Home
    • Training
    • All-Access
    • Excel Foundations
    • Resources

    Connect with Us

    • Facebook
    • Linkedin

    Contact

    Learn Excel Now
    questions@learnexcelnow.com
    1-484-259-7664 or 1-800-964-6033
    660 American Ave
    Suite 203
    King of Prussia, PA 19406

    Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

    Copyright © 2023 ­Learn Excel Now

    Terms of Service

    Privacy Policy

    Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

    WELCOME BACK!

    Enter your username and password below to log in

    Forget Your Username or Password?

    Reset Password

    Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

    Log In

    All Access Subscription
    Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
    Excel Foundations
    Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.