Excel: Learn VBA (Macros) & Increase Your Productivity!
Udemy
Course Summary
Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
-
+
Course Description
Nobody likes doing the same things over and over. Better still, everybody would love it if their tasks get done automatically. We've designed this course to help you avoid monotonous, repetitive tasks and find ways to do better things with the data your business generates. What you will learn 1. Use advanced Excel functions to increase productivity. 2. Build comprehensive reports and real time dashboards. 3. Automate report generation Don’t end your learning at the last lecture 1. Use our Facebook page to interact with thousands of other students and professionals. Keep abreast with the market and network with like minds. 2. Win big by participating in data mining competitions at Kaggle. Who knows, if you are really good at it, you can quit your regular job and be a full time Kaggler! 4. Beef up your resume or create a well-designed profile. 5. Stay tuned, we'll be coming out with new advanced courses.
-
+
Course Syllabus
- Agenda
- Before you begin
- Snapshot of what you will learn
- Work once and enjoy thereafter
- Data cleaning with an Excel robot
- Creating Controllable Dashboards to manage reports
- Dynamic Charts
- Control + F = VLOOKUP
- Letting the Function do it all by itself
- Data Validation Drop Downs to control the charts
- Applying controls to your charts for Easy handling
- Visual Basic For Applications: Automating your Work
- Introduction to VBA Programming
- Hierarchy followed to communicate to VBA
- Using Logic to create Sentences
- Tangible Object hierarchy & Intangible Object Hierarchy
- Connecting the above dots to write a meaning full code here
- Using Properties and Methods on Objects
- Learn more with Hands on
- Sub Routines: Creating Macros
- Ways of Executing a Macro from Excel Window
- Private Sub Routines: Using the predefined Macros
- Function Routines: To create a user defined Function
- Basic Error Debugging & Recording
- Implementation on a case study
- Writing your first Macro on Data Cleaning
- Making your code dynamic
- Loops to do the repetitive task
- Recording implementation in Data Cleaning
- Trailing Macros one after Another
- Self Executable Macros
- Logic Behind a UDF
- UDF to Extract numeric from any string