Udemy – Excel 2013: Advanced Macro with Goal seek, Solver & More !
MP4 | Video: 1278×720 | 88 kbps | 44 KHz | Duration: 2 Hours | 276 MB
Genre: eLearning | Language: English
Learn macro to automate process in excel. Use goal seek, solver, functions & features for better productivity in office.
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.
Start Macro recording to automate the process and calculations.
Use VBA editor to make changes in macro code.
Learn loops to repeat the process till you want.
Many practical problems solved with macro.
Learn using solver Add in to solve optimization problems.
Learn Goal seek with macro to automate the pricing process of products.
Ask any problems you face in your day to day work in Excel I am always available for help
What are the requirements?
Basic knowledge of Excel.
Willingness to learn advance features in Excel.
What am I going to get from this course?
Over 28 lectures and 1 hour of content!
Record macro to automate the task.
Use Visual Basic Editor VBE to edit your macro code.
Use loops in macro code to repeat the process again and again.
Use Goal Seek to prepare product costing and pricing.
Use macro with goal seek to automate the process of pricing of products.
Use solver add in to solve complex problems.
Use advanced functions and techniques in excel for better productivity.
Solution to your any question ask any time in discussion part or my personal email address.
What is the target audience?
Any person working in office who use basic features of Excel.
Students of all level.
Self employed business man.
Professional accountants, business man.