Recording Macros

14.00 €
Excel course/files short description

Everything you need to know about recording macros. This content is part of the Projects 2 course.

Excel course/files description

If you want to add professional functionality and a great look & feel to your Excel Pivot Table reports, this short but extremely effective course is for you

In only 10 minutes you will learn everything you need to know about recording macros in a workbook.

The course comes with a Task/Project Management Excel file that you can use immediately in your daily work.

In this course you will learn: 

  • Set up Developer tab on Excel ribbon,
  • Record macros such as for refreshing reports and excluding selected filters on reports – PivotTables,
  • Check the correctness of the macros,
  • Create a button and connect it to macro,
  • Basics about Visual Basic Editor and how to replace macros.
  • A library of macros is also included.

With the knowledge you will acquire, you will be able to record a simple set of actions that will make your work with data in Excel easier and faster.

No programming, easy to learn, fast and efficient for your daily work.

Recommended:  for users who want to make their work with Microsoft Excel easier and better 
Learning time:  10 minutes to  1 hour, depending on your prior knowledge and available time
For: Microsoft Excel 2016, 2019, 2021, and  Microsoft Office 365

Watch the video to see how simple the learning process is ›


Interactive PowerPoint presentations*
Excel files Macro library
3.1 Refreshing Reports and Filters using Macro
1. Projects

2. Projects macro Module2.bas

*with videos included