Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Analytical tool for Excel to make better decisions for solving problems.
Hi, Welcome to the Excel Solver course. Solver is an excellent tool for solving complex problems which involves analytics and lot of iterations.
In this course you will gain a deep understanding of Solver, learn how Solver works under the hood. We will also see how VBA can be used within Solver. The Main motive here is not just learn Solver, we will have to understand Solver.
Not only you will be learning Solver, we will be working on goal seek, Lot of excel tips and tricks.
Throughout the course we will be learning lot of tools including:
- Excel Basics
- Goal Seek
- Solver
- VBA for Solver and Goal Seek
- Excel Tips and Tricks
- and more....
This is a course designed for the complete beginner, yet it covers some of the most exciting and relevant topics in the industry.
This course is also unique in the way that it is structured and presented. Many online courses are just a long series of "watch as I code" videos. This course is different. I've incorporated everything I learned in my years of teaching to make this course not only more effective but more engaging.
If you have any questions, please don't hesitate to contact me. I got into this industry because I love working with people and helping students learn. Sign up today and see how fun, exciting, and rewarding Solver can be!
Course Content
- 14 section(s)
- 52 lecture(s)
- Section 1 Introduction to this Course
- Section 2 Understanding Excel
- Section 3 Goal Seek
- Section 4 Understanding Solver
- Section 5 Solver - Let us solve the first Problem
- Section 6 Solver - Second Problem - Vehicle Trading
- Section 7 Solver - Third Problem - Machine Cost
- Section 8 Solver - Fourth Problem - Fun With Solver
- Section 9 VBA - Visual Basic for Application - Basic Intro
- Section 10 Solver - Fifth Problem - Shipping Cost
- Section 11 Solver - Sixth Problem - Use Evolutionary Method
- Section 12 NEW UPDATE - Solver - Seventh Problem - Shipment Problem
- Section 13 Excel Tips and Tricks
- Section 14 Conclusion
What You’ll Learn
- Understand Excel Solver in depth.
- Create many scenarios and solve problems quickly.
- Use different approach in solving complex problems.
- Not only understand Solver, also work on goal seek, gain more knowledge on Excel techniques, use Macros to run solver and goal seek.
Skills covered in this course
Reviews
-
NNidhi Chaudhari
Very bad teaching.. Just dragged
-
MMonica Garcia Duggal
The instructor is very clear and makes the examples useful for the student immediately.
-
DDavide Pandini
Useful intro to Excel Solver. A section on how to write a VBA macro (and not just record) would have been even more useful.
-
AAndrea Tabanelli
Great course, simple and effective to discover Excel's Solver power!