Excel Solver, Goal Seek and lots of Excel Tips

Name: Excel Solver, Goal Seek and lots of Excel Tips
Rating: 4.3 (67 reviews)

Analytical tool for Excel to make better decisions for solving problems.

Created byPannaga Kasbe

Last updated 4/2018

English

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.

Course content

14 sections • 52 lectures • 1h 28m total length

Welcome to the solver Course1:14
Read Before you proceed1:39
Exercise Files0:18

Understanding Excel - Introduction to Excel1:45
In this video, you will learn the basic of Excel and its interface
Cell and Range Names2:09
In this lecture, you will understand how to name a cell or Range.
Absolute and Relative reference2:53
One of the key part in excel is the absolute and relative reference, which you will understand in this video.
Understanding Precedents and Dependents2:46
If you get a excel workbook with lot of formulas and steps, chances of you getting confused is more. This is wherePrecedents and Dependents play a great role. It helps you understand from where to start and how to proceed and how all connects.
Excel Basics Quiz

Sugar Proportions2:07
This is the first problem of using Goal Seek. Here we will see how goal seek can be useful for us.
Loan Amount2:13
In this video, we will improve the knowledge of goal seek.
Bonus Calculation2:10
A small challenge on goal seek. Test your knowledge. Do not worry if you get stuck, the next video is the solution video.
Bonus Calculation Solution0:42
Profit Calculations0:32
Profit Calculations Solution0:37
Goal Seek Section Quiz

Add Solver Addin0:52
Before we start using solver, we must add the solver Add-in. This video will help you load the solver Add-in.
Add Solver Add-in for Mac0:10
If you are using Macbook, then follow the instructions to load Excel Solver Add-in. If you have any issues, please feel free to use the discussion board.
Understanding Solver Dialog Box2:10
In this video, we will understand the solver dialog box.
Understanding Different Methods of Solving problem2:29
The most important three methods of solver. This video will introduce you to all the three methods. Do not worry, we will go into more depth while solving problems.

Before Starting the problem0:36
Stage 1 - Understanding the Problem1:23
This is our first solver problem and the first Step. In this first step, we will understand the problem.
Stage 2 and Stage 3 - Identify the objective and decision variables0:33
Identifying the objective and decision variables are the key aspect of Solver.
Stage 4 - Building Equations6:39
The most important part is building Equations. Let us see how to build equations in this video.
Stage 5 - Using Solver6:16
After we build equations, we will see how to use Solver to solve the problem in this video.
Understanding Answer Report1:44
The final Step is to understand the Answer Report. Reading the answer report is important to know what are the changes that took place and can we improvise it more or not and much more. This video will help you understand the answer Report.

Requirements

Have a computer with Excel installed.
Be ready to learn an insane amount of awesome stuff
You can use Either Windows or Mac
I am using Excel 2016, But it is also compatible for Excel 2003, 2007, 2010 and Later

Description

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!

Who this course is for:

This course is for those who wants to take their Excel Skills to next Level
This course is for those who wants to learn and understand Excel Solver.
This course is for those who work on Optimization of resources.
This course is for those who are in Finance, Manufacturing, Distribution, resource handling.,

Excel Solver, Goal Seek and lots of Excel Tips

What you'll learn

Explore related topics

Course content

Introduction to this Course3 lectures • 3min

Understanding Excel4 lectures • 10min

Goal Seek6 lectures • 8min

Understanding Solver4 lectures • 6min

Solver - Let us solve the first Problem6 lectures • 17min

Solver - Second Problem - Vehicle Trading3 lectures • 8min

Solver - Third Problem - Machine Cost4 lectures • 4min

Solver - Fourth Problem - Fun With Solver4 lectures • 5min

VBA - Visual Basic for Application - Basic Intro1 lecture • 4min

Solver - Fifth Problem - Shipping Cost5 lectures • 10min

Requirements

Description

Who this course is for: