Excel Solver, Goal Seek and lots of Excel Tips - 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