->
Excel Macros VBA + Power Query (2 in 1 course)
Excel Macros VBA + Power Query (2 in 1 course)
https://www.udemy.com/course/microsoft-excel-macros-magician-excel-and-vba/
Learn Excel Macros Automation and Power Query (2 in 1 course)

 


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.

Once you're done with VBA, learn Power Query.....the best tool to Master without learning how to code

 

"It is in detail ie., step by step for the non coding background learners"

Rajesh L N - India

 

"I needed a course that takes me from basic vba to intermediate vba and so far with the course content i see myself headed towards becoming an expert vba which is awesome"

Emmanuel - Uganda

 

"Excellent course contents and thanks for uploading this savior course. It really helped and perfectly fits for the day to day work automations. I highly recommend this course for macros learners...!!"

Rizwan Safdar - Switzerland

 

"Practical examples and well explained formulas. Excellent course explained with formulas and debugging. Can't wait to learn the Excel animation and move to Power BI. Would recommend the course to Excel enthusiasts to explore."

Shagufta M - Pakistan

 

"It’s a very nice course, I recommend to everyone who wants to learn VBA. Instructor has got excellent knowledge about the teachings."

Sarfraz - India

 

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

Over 50 completed files, videos and examples.

  • Userforms

  • 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

  • Interactive Sales Dashboard

Excel Macros VBA + Power Query (2 in 1 course)


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss