- 提示:
- 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。
課程資料
- 可獲發
- (證書的發放與分配,依課程提供者的政策及安排而定。)
課程簡介
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.
此課程所涵蓋的技能
評價
-
NNidhi Chaudhari
Very bad teaching.. Just dragged
-
MMonica Garcia Duggal
The instructor is very clear and makes the examples useful for the student immediately.
-
DDavide Pandini
Useful intro to Excel Solver. A section on how to write a VBA macro (and not just record) would have been even more useful.
-
AAndrea Tabanelli
Great course, simple and effective to discover Excel's Solver power!