Udemy

Excel Solver, Goal Seek and lots of Excel Tips

Enroll Now
  • 296 Students
  • Updated 4/2018
  • Certificate Available
4.2
(65 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 28 Minute(s)
Language
English
Taught by
Pannaga Kasbe
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.2
(65 Ratings)

Course Overview

Excel Solver, Goal Seek and lots of Excel Tips

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.


Reviews

  • N
    Nidhi Chaudhari
    1.0

    Very bad teaching.. Just dragged

  • M
    Monica Garcia Duggal
    5.0

    The instructor is very clear and makes the examples useful for the student immediately.

  • D
    Davide Pandini
    3.0

    Useful intro to Excel Solver. A section on how to write a VBA macro (and not just record) would have been even more useful.

  • A
    Andrea Tabanelli
    5.0

    Great course, simple and effective to discover Excel's Solver power!

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed