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).part2.rar
Excel_Macros_VBA___Power_Query_(2_in_1_course).part3.rar
Excel_Macros_VBA___Power_Query_(2_in_1_course).part4.rar
Excel_Macros_VBA___Power_Query_(2_in_1_course).part5.rar
Excel_Macros_VBA___Power_Query_(2_in_1_course).part6.rar
Excel_Macros_VBA___Power_Query_(2_in_1_course).part7.rar
Excel_Macros_VBA___Power_Query_(2_in_1_course).part8.rar
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.