» » Microsoft Excel Macros Magician - Excel and VBA
Information of news
14-11-2021, 16:43

Microsoft Excel Macros Magician - Excel and VBA

Category: Tutorials

Microsoft Excel Macros Magician - Excel and VBA
Microsoft Excel Macros Magician - Excel and VBA
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 61 lectures (13h 33m) | Size: 5.26 GB

Learn from beginners level to Expert level, automate your reports, animate your charts, format your reports and charts
What you'll learn:
Students will learn how to debug recorded macros and write their own coding using VBA. A little basic understanding of Macros is what you need.
Most students struggle to understand VBA codes, this course has what you need to expand your knowledge into the VBA world.
All you need is a will to master the basic concepts, some practise and your on your way to become an expert. Watch, repeat and Practise is key here.
VBA code written in front of your eyes, not written and then narrated. Relate words with action. Follow along as we write code, debug and correct errors.
At the end of the course, you will be able to master key concepts, write your own loops and even make summary reports.

No programming background needed. All you need is to spend some time, watch, repeat and put into action.
The internet is full of videos and ideas, my advice is watch, read, learn and implement your own ideas to be creative.

Fear not if you don't know how to record a Macro and use it. In this course, I will show you how to record macros, edit them , understand the code, debug them and start writing your own applications.

VBA for Excel is still King in terms of Automation. There is so much magic that you can achieve by learning how to code. All you need is the will power to learn and practise.

Start from the Basics of recording and understanding macros. Learn to write VBA code from scratch. You don't need to be a Programmer.

Variety of codes for different situations, written right before your eyes. Debug, compile and recover from mistakes.

Over 50 completed files, videos and examples.


Animation in Charts using Named ranges and VBA

Looping over multiple files

Using the speed of Arrays

Scripting with Files and Folders

Creating Summary Reports

Formatting your reports

Embedding images onto sheets

Resizing multiple charts in a grid

Creating Charts in VBA

Embedding Pictures from a Folder

Error handling and debugging

Using Advanced Filter

Using Shapes in VBA

Understanding Tables and List Objects

Record macros in Absolute and Relative mode, understand the differences. Start building Userforms, create loops to loop over multiple files.

Understand Pivot table automation and to access Tables as List Objects.

Create multiple charts and resize them in a customized grid.

Create animation using Advanced techniques with Named ranges and VBA to animate Excel charts.

This course covers all the basics as well as advanced concepts of VBA for beginners.

Each project contains exercise files that you can download and use.

This course will help students, accountants, data analysts, working professionals, any Excel enthusiast.

Course will be updated with new videos...

Who this course is for
All students seeking coding knowledge basics, working professionals wanting to learn Excel Macros and how to automate processes.
Managers , Sales professionals, Data Analysts, anyone basically wanting to learn new skills.





Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.
free html hit counter