Excel Solver, Goal Seek and lots of Excel Tips | Pannaga Kasbe | Skillshare

Excel Solver, Goal Seek and lots of Excel Tips

Pannaga Kasbe, Avid math lover And Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
38 Videos (1h 18m)
    • Course Into

      0:29
    • Understanding Excel

      1:45
    • Cell and Range Names

      2:09
    • Absolute and Relative Reference

      2:53
    • Understanding Precedents

      2:46
    • Sugar Proportions

      2:07
    • Final Loan Amount Problem

      2:13
    • Bonus Calculations

      2:10
    • Bonus Calculations Solution Part

      0:42
    • Profit Calculation Problem Part

      0:32
    • Profit Calculation Solution Part

      0:37
    • Solver Addin

      0:52
    • Understand Solver dialogue box

      2:10
    • Solver Methods

      2:29
    • Problem 1 - Solver - Stage 1 Understanding the Problem

      1:23
    • Problem 1 - Solver - Stage 2 and Stage 3

      0:33
    • Problem 1 - Solver - Stage 4

      6:39
    • Problem 1 - Solver - Stage 5

      6:16
    • Problem 1 - Solver - Understand Answer Report

      1:44
    • Problem 2 - Solver - Stage 1 and 2 and 3

      0:46
    • Problem 2 - Solver - Stage 4

      4:51
    • Problem 2 - Solver - Stage 5

      1:59
    • Problem 3 - Solver - Stage 1

      0:29
    • Problem 3 - Solver - Stage 2 and 3

      0:41
    • Problem 3 - Solver - Stage 4

      0:43
    • Problem 3 - Solver - Stage 5

      1:57
    • Problem 4 - Solver - Stage 1

      0:51
    • Problem 4 - Solver - Stage 2 and 3

      0:20
    • Problem 4 - Solver - Stage 4

      1:54
    • Problem 4 - Solver - Stage 5

      2:15
    • VBA INTRO

      3:36
    • Problem 5 - Solver - Stage 1

      0:33
    • Problem 5 - Solver - Stage 2 and 3

      0:24
    • Problem 5 - Solver - Stage 4

      3:40
    • Problem 5 - Solver - stage 5

      1:53
    • Problem 5 - Solver - Stage 6

      3:27
    • Problem 6 - Solver - Evolutionary method

      5:45
    • Excel Tips - Copy same values in different cell at same time

      1:13

About This Class

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 to 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!

10

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Pannaga Kasbe

Avid math lover And Entrepreneur

She has a Bachelor in Engineering in Electrical & Electronics and also Certified Professional in Electrical Cadd. Technically skilled in AutoCAD, Revit-MEP, Primavera-P6.

She was always fascinated by mathematics and secured 3rd Rank in school level in "Mathematica-2002" Maths Talent Examination.She truly enjoys sharing her knowledge with others and from her early twenties she has been teaching courses in mathematics.

She has received an Award of appreciation from Emats All India...

See full profile

Report class