EXCEL PRO TIP: Advanced Optimization with Solver

Рет қаралды 16,372

5 жыл бұрын

For access to all pro tips, along with Excel project files, PDF slides, quizzes and 1-on-1 support, upgrade to the full course (75% OFF):
courses.excelmaven.com/p/micr...
FULL COURSE DESCRIPTION:
This course is NOT an introduction to Excel.
It's not about 101-style deep dives, or about showing off cheesy, impractical "hacks".
It's about featuring some of Excel's most powerful and effective tools, and sharing them through crystal clear demos and unique, real-world case studies.
We'll cover 75+ tools & techniques, organized into six categories:
-Productivity
-Formatting
-Formulas
-Visualization
-PivotTables
-Analytics
Demos are self-contained and ranked by difficulty, so you can explore the content freely and master these tools and techniques in quick, bite-sized lessons.
Full course includes LIFETIME access to:
-10+ hours of high-quality video content
-Downloadable PDF eBook
-Excel project files (including data sets & solutions)
-1-on-1 expert support
-100% satisfaction guarantee (no questions asked!)
Happy analyzing!
-Chris (Founder, Excel Maven)

Пікірлер: 3

@wayneedmondson1065 5 жыл бұрын

Hi Chris.. great video on Solver. I use Goal Seek often and also Data Tables to test different input variables. Have not used Solver much, but looks very interesting. I'll definitely give it a try. Thanks and Thumbs up!!

@theapexpredator157 3 жыл бұрын

I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?

@johncallahan2447 Жыл бұрын

I just completed a Business Analytics Class and found the most difficult part was setting up the model pulling info from a paragraph containing the constraints. In your class, how much time is spent on organizing provided information and structuring it into the model?