Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 35 Minute(s)
Language
English
Taught by
Ramzan Rajani
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn Macros Step by Step till Report Automation (End to End)
Excel Macros - VBA for Report Automation
The objective of this course is to make you expert in writing own macros code Exclusive for Report Automation.
If you see the course outline its all practical topics and only those codes has been taught which is regularly used in the report automation.
The other benefit is its a complete class room training hence i have very slow step by step to make you understand each topics.
In this course i have even covered Sheets and Files Consolidation & Segregation Project which is regular required in Report Automation in Corporates.
Overview
Advanced Excel users encounter repetitive tasks such as: reports that need to be produced, data that needs to be updated or tables that need to be formatted on a regular basis. Using “Macros” many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class they can record the steps or operations that they want to perform, and then press a button to repeat them over and over again (and again).
Prerequisite : Proficient knowledge of Microsoft Excel. This class is for non-programmers.
Target Student
This course is for individuals who use Excel 2016, 2013 or 2010 frequently and who need to automate routine tasks. Programming experience is not required.
Thanks & Regards
Ramzan Rajani
Microsoft Excel Specialist and Certified Trainer
Course Content
- 5 section(s)
- 33 lecture(s)
- Section 1 Macro Recording, Running & Starting with Codings
- Section 2 Project
- Section 3 IF Condition
- Section 4 Consolidation Macro Project
- Section 5 Extra Projects (If you wish to Learn and get more ideas)
What You’ll Learn
- 1) Macros Recording & Running and will start with Basic Codings
- 2) You will learn how to Consolidate Multiple Sheets into one
- 3) Filtering Project : Where you will learn to create Seperate Sheet for each Filtered items with Simple Coding
- 4) You will also learn how to Implement IF Condition with Macros (VBA)
- 5) Consolidation Project : You will learn how to write the Code to Consolidate Multiple Sheets of Multiple Files
Skills covered in this course
Reviews
-
LLaxmishetty
The training was so good—it felt as if I had attended a one-on-one session with the trainer. Thanks a lot!
-
AAmiya chand
The method of teaching is excellent !!
-
SSurya Chowdhury
Detailed course
-
JJohn Benedics
Very good explanation and able to understand very clearly. I really appreciate the trainer and its worth taking this training program because I am able to understand from beginner level.
