Excel 2013: Advanced Macro with Goal seek, Solver & More !
- 1 hour on-demand video
- 19 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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.
- Excel 2007/2010/2013(recommended)
- Basic knowledge of Excel.
- Willingness to learn advance features in Excel.
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)
- Any person working in office who use basic features of Excel.
- Students of all level.
- Self employed business man.
- Professional accountants, business man.
- Business entrepreneur.
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.