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.
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.
Course Highlights:
- 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)
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!