

Learn Analytics - MS Excel Macro
100% time save on repetitive excercises on Excel through creating short keys and much more in Macro
Self paced
tutorial
An Excel macro is an action or a set of actions that you can record, give a name, save and
run as many times as you want and whenever you want.
Macros help you to save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently.
Audience
This guide targets novice developers and those new to Excel Macros. After completing this tutorial, your firm foundation in creating macros will allow you to use macros efficiently.
Prerequisites
When you record a macro, Excel stores it as a VBA code. You can view this code in the VBA editor. You can understand the code and modify it if you have substantial knowledge of Excel VBA. However, if you do not have sufficient knowledge, then we will suggest you to go through our short tutorials on VBA.
An Excel macro is an action or a set of actions that you can record, give a name, save and
run as many times as you want and whenever you want. When you create a macro, you are recording your mouse clicks and keystrokes. When you run a saved macro, the recorded mouse clicks and keystrokes will be executed in the same sequence as they are recorded.
Macros help you to save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently
Live Classes
Students can also avail facility of Live classes at higher cost as then our experts will be interacting and providing you online teaching. Please let us know in advance so as to get the registration process done timely.
Below is the Modules covering in the Course
Learning Analtyics - Excel Macro Part1
Excel Macros - Overview
Excel Macros - Creation
Macros in a Single Workbook
Excel Macros - Security
Excel Macros - Absolute References
Excel Macros - Relative References
Learning Analtyics - Excel Macro Part2
Excel Macros - VBA
Excel Macros - Understanding Codes
Assigning Macros to Objects
Excel Macros - Running a Macro
Creating a Macro Using VBA Editor
Excel Macros - Editing
Learning Analtyics - Excel Macro Part3
Excel Macros - UserForms
Excel Macros - Debugging a Code
Excel Macros - Configuring a Macro
Language of instruction: English
- Content is created & delivered by experts with years of industry exp.
- Certificates provided on successful completion of graded assignments
- @Amazing Supports, we reslove query on one-one 1 hour session
- Live Classes can also be provided in case required
JayPee Business Academy is an DSE alumni venture set up with specific goals in mind:
•1. Provide the best career oriented education possible: Large parts of the global education system is not able to keep pace with the changing demands in industry and technology. It produces graduates but without the skills necessary to contribute in the workplace without being trained further. We aims to make an intervention in the education system and evolve a new paradigm of learning which is focused on the needs of the industry and the aspirants. We will do this by providing practical, hands-on, short-term certificate courses which will be created and delivered by industry experts and will fill the gap between industry needs and university output.
Schedule & Syllabus
