English | MP4 | 1280x720 | 60 kbps | 44 KHz | 2 hours | 71 Mb
EMbrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
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.
What are the requirements?
All you need is Microsoft Excel!
Should be fairly familiar with working on data spreadsheets at the basic level.
What am I going to get from this course?
Over 9 lectures and 34 mins of content!
Offload your work by automation using VBA Macros!
Eliminate repetitive activities for a smarter work approach
What is the target audience?
This course is meant for anybody who wants to offload their work. Get introduced to automation using VBA Macros. You do not need any programming background, we will teach you how to write and record macros right from the scratch. Get ready to make your computer do your work for you!
This course does not cater to the student seeking to learn the VBA comprehensively. Its main focus is Automation. More advanced VBA topics are available in the Advanced VBA course.
(Buy premium account for maximum speed and resumming ability)