Do you Need Help with Automating your Spreadsheets?

Are you constantly performing manual repetitive Excel tasks that are time consuming and tedious? Are you performing the same actions over and over again everyday? Are you thinking there must be an easier and quicker way to do my spreadsheet work? I know your pain. I was in the same position as you. I was consistently performing manual repetitive tasks in my Excel worksheets every day in my job and it was painful!
Frustrated bearded man asking for help on his laptop

I Feel you Pain.....

Manually performing repetitive Excel tasks leads to lost time, boredom and lost revenue. This was exactly how I was feeling and was suffering for it! Without automating your spreadsheets you are putting yourself under pressure to complete your work for the deadline. You are doing things the long way round when really there is a quicker solution. You are more likely to make mistakes in your spreadsheets when you are manually working on them. As a result you are making your life more complicated when it really doesn't have to be.
Person holding a board which says Empathy

There is a Solution!

Excel will allow you to record your actions in a worksheet so you only have to perform the action once. You can then repeat these actions automatically as many times as you want! This FREE 'How to Record Macros in Excel' course will teach you how to record your actions in Excel and store it in VBA code as a Macro and then show you various ways to execute the Macro. No more repetition, no more lost time and no more lost revenue.
Business man eliminates a problem with a solution

Enroll in the FREE How to Record Macros in Excel Course

Why you Should Take this Course

In this comprehensive step by step training you will learn:

  • How to record your very own Macros for any situation

  • How to execute your Macro using the Macro Dialog box

  • Three ways to execute your Macro using the Visual Basic Editor

  • How to execute a Macro by pressing a button in your worksheet

  • How to execute a Macro by pressing a shape in your worksheet

Course curriculum

  • 1

    Welcome to the course!

    • A Message from your Instructor
    • Course Agenda
    • Before we begin...
  • 2

    The Course Leader

    • A Little About the Course Leader
  • 3

    How to Record a Macro

    • How to Record a Macro Introduction
    • Recording a Macro (1)
    • Recording a Macro (2)
    • Recording a Macro (3)
    • Recording a Macro Demonstration
    • Test your Learning
  • 4

    How to Run Macros

    • How to Run Macros Introduction
    • How to Run a Macro
    • Using the Macro Dialog Box
    • How to Run a Macro Using the Macro Dialog Box Demonstration
    • Using the Visual Basic Editor (1)
    • Using the Visual Basic Editor (2)
    • Using the Visual Basic Editor Demonstration
    • Assign a Macro to a Button
    • Assign a Macro to a Button Demonstration
    • Assigning a Macro to a Shape
    • Assigning a Macro to a Shape Demonstration
    • Test your learning
    • Thank You
    • More Resources for You
    • Before you go...

What you will Learn in this Course

There are four modules and within each module there are a number engaging step by step video tutorials which includes everything you need to know on how to record and execute your very own Macros to automate your spreadsheets, and ultimately to save you time. There are also tests to take which will help solidify your learning.

  • Module 1 - You will learn what the course is about and what will be covered in the course

  • Module 2 - You will learn a little about me, the course leader, and why I am qualified to teach this course

  • Module 3 - In this section you will learn how to record your very own Macro using the Record Macro Dialog box. I will give a demonstration of how to do this which you can follow along to

  • Module 4 - You will learn all the different ways you can execute the Macro once you have recorded it

Testimonials

Barry Couchman - Business Solutions Manager

This course was taught on the premises of a large global organisation in the UK. Staff from multiple departments at Daventry gather in the meeting room for the VBA training session run by Harjit Suman. The session was a useful introduction to automating MS Office operations that will help to reduce repetitive tasks and save time processing regular reports. The delivery from Harjit was well paced and the content pitched at just the right level for the assembled newcomers to the application. Thanks Harjit, great job!

Jade Nooney - Supply Chain Co-Ordinator

It was a brilliant session, thanks Harjit!!!

Instructor

The Course Teacher

Harjit Suman

Excel & VBA Instructor

Harjit Suman

Hi I'm Harjit. I am an Excel and VBA instructor and an Excel Consultant with over 10 years experience using Excel and VBA. I have helped organisations with their spreadsheet work which includes manipulating data sets, dashboard creation, creating advanced Excel formulas and creating powerful Excel applications in VBA to streamline their work processes. I started to learn Excel in my first analytical role. I wasn't very good at Excel in the beginning and I found that it was taking me ages to do simple Excel tasks. I knew there must be simpler ways to perform these tasks but didn't know how! I started to buy Excel books and read them in the evenings and weekends. I started to realise the true potential of Excel and learning it became a passion to me and not a job. Once I became an advanced Excel user and started to streamline my work processes I wanted to take my skills to the next level and learn VBA. I bought my first beginners VBA book and practiced writing my own Macros. I then bought more advanced books and started to build more powerful Excel applications, not just for myself, but for other work colleagues in different departments of the organisation. I became the go to person in Excel! I now want to pass on the knowledge I have built up over the years to you to make your life easier like it has for me. I have trained many individuals in Excel and VBA to help take their Excel skills to the next level. I have taught my course, 'Introduction to VBA Macros' to a large global organisation to people from different business units so they can improve their efficiency and save time in their work. I have also written Excel tutorials in my blogs which are catered for the beginners, intermediate and advanced users of Excel in my website Excel Master Consultant (www.excelmasterconsultant.com). Please do check it out. I believe the secret to teaching a technical subject such as Excel and VBA is to use simple language and to break down each topic into step by step instructions so that beginners can understand it. I also like to provide plenty of examples and video demonstrations so that learners can follow along easily. I look forward to teaching you in my classes.

FAQ

  • How much is this course?

    This course is free!

  • Do I need any prior knowledge of Macros to take this course?

    This course is aimed for beginners so no prior knowledge of Macros and VBA is needed to take this course

  • I am an Excel novice. Can I still take this course?

    It is recommended that you have used Excel before and you know a little way around Excel but you don't need to have intermediate or advanced Excel skills to take this course

  • Which Excel version should I have to take this course?

    It is recommended that you have Excel 2010 onwards to get the best out of this course

  • Do you provide demonstrations?

    There are video demonstrations on how to record a Macro and the various ways to execute the Macro so you can follow along

How Much is the Course?

This course is completely FREE!!!

Who this Course is For?

This course is aimed for the following people:

  • You want to automate your spreadsheets

  • You want to save time

  • You are a regular Excel user

  • You want to take your Excel skills to the next level

Do you want to Create Advanced Excel Applications?

Learn how to Write VBA Code

Recording Macros is a great introductory way to start automating your spreadsheets but you can create advanced Excel applications by writing VBA code. The 'Introduction to VBA Macros' course is aimed for beginners so you don't need prior VBA knowledge to take this course. In this course you will learn how to automate your spreadsheets for any worksheet and scenario by writing VBA code. For further information please press the button below.
Introduction to VBA Macros Course
VBA (Visual Basic for Applications) logo