Deepti

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

ENROLL NOW

Overview
Schedule

About this Course

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

Highlights

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

About the instructor

Deepti

India

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.

•2. Provide anytime, anywhere learning: We strongly believe that when people want to learn they should get access to the learning when they want, where they want and not wait for academic years or batches to start or have to uproot themselves and travel. Hence we have leveraged the power of technology to provide access to our courses online, 24x7x365, wherever the learners are and on any device.

•3. Provide a high ROI for the student: We do not believe in making our students learn everything under the sun in their domain if they are unlikely to implement those skills in their career for a long time. For example freshers starting a career in analytics will not need to know or use advanced techniques in the initial years of their career. Spending a year and thousands of dollars on a comprehensive course would be a waste of time and money for them and will also not improve their salaries significantly. We believe that providing the students course options specific to the needs of their immediate career goals will go a long way in keeping their costs and time commitments low, enabling a much higher return on investment(ROI) for them. In future as their career advances they can take up higher level courses thus ensuring that returns keep pace with investment.

•4. Create a knowledge hub for each domain: In the domains that we operate in, we will provide a range of courses to meet every need and requirement of the industry and the person’s career stage. In this way, we aim to create a knowledge hub for that particular domain/industry.

1 FOLLOWER 1 FOLLOWEE

Schedule & Syllabus

Please wait while we are fetching data...