If you spend your few hours with this course, you will definitely see increase in your day to day work productivity with in a week. Using excel programming features like Macro, goal seek and Solver are the best way to decrease your repetitive manual working time and impress your boss, colleagues and friends.
In this video, student will see the overall contents of this course. Recording Macro in Excel, manipulation of macro code in VBA editor in excel, applying loops in VBA code, solving optimization problems using goal seek, solver are the key contents of this course. The main objective of this course is to teach advanced macro in Microsoft Excel to automate the process of any repetitive task.
Student will learn how to enable developer tab in Microsoft excel.
Student will learn various methods of recording macro like using developer tab, view tab and status bar.
Student will learn how to record first macro in Microsoft Excel.
Learn how to assign macro to button or shape in Microsoft Excel.
Learn difference between absolute and relative reference in macro code in Excel VBA programming.
Learn how to use for next loop in macro code in Excel.
Learn how to use Do Until loop in Excel macro code.
Learn how to use Do While Loop in Excel macro code.
Learn how to use vba code to design live clock in excel single cell.
Learn how to use goal seek to find out any specific value from a excel model.
How to use macro code with goal seek features in Excel.
Learn how to enable solver add in in Microsoft Excel.
Learn how to formulate excel solver model to solve any optimization problems.
Watch how solver model works to solve optimization problems like optimum product quantity, etc.
Learn how to solve Sudoku using excel solver add in.
Hi, I am Rit Shrestha, a qualified chartered accountant. Teaching and motivating my students in using smart way of working in Microsoft Excel is my passion. I have been continuously using Excel functions, features and macro with VBA code since past 7 years in my accounting, finance and taxation career. I have expert level knowledge in Microsoft Excel, Access and many accounting software. I am providing various services as an instructor, tax consultant and financial manager in various group of companies and individuals.