Learn to Automate Repetitive or Complex Tasks. MS Excel is a dynamic tool with lots of functionality. Yet so few of us harness the full potential of this excellent tool. Impress others by improving efficiency and reducing errors at work, research or school. The course has been meticulously designed to provide candidates with a deep understanding of the most important features and functions of VBA & Macros in MS Excel. More importantly, get hands-on learning by going through case studies which show application of VBA & Macros in the real world scenarios. Get ready to stand out among your colleagues.
Who are we?
White Knight Ventures EDU is a leading global training company which has trained over 10,000+ professionals and students. We conduct training for MS Excel, R Programming, SAS, VBA, SQL, Python, Analytics, Machine Learning, Finance, Risk Management, Actuarial Science, Sales & Marketing, Operations, Soft Skills and much more.
Such a broad and deep expertise has been distilled into this meticulously designed course. So when we say we know how to apply this tool to various real world scenarios, we know what we are talking about.
Structure of Course:
The course has 3 Parts:
VBA 101: Basic
VBA 102: Advance
Real-Life Exclusive Case Studies
What do you get out of this course?
Master VBA & Macros from Beginner to Advance Level
Harness the power of automation with MS Excel in your day to day tasks through Macros and VBA
Learn functions which are essential for work like Marketing, Finance, HR, Operations, and for Research Work
Churn out impressive reports in no time
Impress others by improving efficiency and reducing errors
Sail faster by learning looping which save lot of time and effort
Access to Articles & Blogs
Hands-on learning on problem solving with Real-Life Exclusive Case Studies
So, what are you waiting for? Enroll now and take the next step in Mastering VBA & Macros. Go from BEGINNER TO EXPERT! Always remember that EVERY EXPERT WAS ONCE A BEGINNER...
VBA & Macros Course - Master Beginner to Advance
- Introduction
- Beginning with Macros
- VBA Environment
- Objects
- Message Box & Input Box
- Macro using Logical Functions
- Date & Time Functions
- Looping Part 1
- Looping Part 2
- Data FIlters
- Debugging Codes & Data FIlters
- Userforms
- Creating CHarts
- Some Important Functions
- Case Study: NPV Part 1
- Case Study: NPV Part 2
- Case Study: Operations Management
- Case Study: UDF Statistics Part 1
- Case Study: UDF Statistics Part 2
- Case Study:Sales & Data Analysis