Udemy

Excel Solver, Goal Seek and lots of Excel Tips

立即報名
  • 296 名學生
  • 更新於 4/2018
  • 可獲發證書
4.2
(65 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
1 小時 28 分鐘
教學語言
英語
授課導師
Pannaga Kasbe
證書
  • 可獲發
  • (證書的發放與分配,依課程提供者的政策及安排而定。)
評分
4.2
(65 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

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!

課程章節

  • 14 個章節
  • 52 堂課
  • 第 1 章 Introduction to this Course
  • 第 2 章 Understanding Excel
  • 第 3 章 Goal Seek
  • 第 4 章 Understanding Solver
  • 第 5 章 Solver - Let us solve the first Problem
  • 第 6 章 Solver - Second Problem - Vehicle Trading
  • 第 7 章 Solver - Third Problem - Machine Cost
  • 第 8 章 Solver - Fourth Problem - Fun With Solver
  • 第 9 章 VBA - Visual Basic for Application - Basic Intro
  • 第 10 章 Solver - Fifth Problem - Shipping Cost
  • 第 11 章 Solver - Sixth Problem - Use Evolutionary Method
  • 第 12 章 NEW UPDATE - Solver - Seventh Problem - Shipment Problem
  • 第 13 章 Excel Tips and Tricks
  • 第 14 章 Conclusion

課程內容

  • 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.


評價

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

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策與使用條款才繼續瀏覽。

我已閱讀及同意