Excel Solver and Goal Seek

preview_player
Показать описание
In this video I exlain and demonstrate Goal Seek and Solver for Excel.
Рекомендации по теме
Комментарии
Автор

This video helped me with my excel homework, cost accounting and quantitative methods homework... 

You did this in just under five minutes, the combined efforts of the profs about 8 hours.

Unreal. 

oOBlindyOo
Автор

Love your vid! It has everything our IT teacher didnt teach us yet he demands it...

sprejerVK
Автор

Something that is not explicit in the video is the sumproduct formula for materials used. Just mentioning in case someone is trying to recreate this spreadsheet to get the same results. Those values are not just manually typed in. It is a mixed reference sumproduct formula and is not as apparent as some of the other calculations in the sheet. At no time in the video are those cells selected in such a way that you can see that formula in the formula bar.

GarfieldStinvil
Автор

Thank you! You teach ammaazing! Like that was so helpful!

vionach
Автор

thank you so much it was really helpful.

proce
Автор

Where is the Excel to practice? Thank you.

Annasalt