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

Price: $
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.

    Credits

    NASBA logo
    Credit Hours:
    Field of Study:
    Program Level:
    Basic Knowledge
    Prerequisites:
    None
    Advance Prep:
    Delivery Method:
    Group Internet Based
    Progressive Business Conferences 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

    Purchase This On-Demand Webinar

    Excel Automation: Automating Tasks with Macros

    Format: On-Demand Webinar
    Price: $199 + applicable taxes Buy Now

    Purchase This On-Demand Webinar

    Excel Automation: Automating Tasks with Macros

    Format: On-Demand Webinar
    Price: $199 + applicable taxes
    Buy Now

    Credits

    NASBA logo
    Credit Hours:
    Field of Study:
    Program Level:
    Basic Knowledge
    Prerequisites:
    None
    Advance Prep:
    Delivery Method:
    Group Internet Based
    Progressive Business Conferences 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

    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