filmov
tv
Excel Data Tables - Two variable data table (maximize product profit)

Показать описание
Excel Data Tables - Two-variable data analysis to maximise net profit.
As a continuance to my previous video where I had showed you guys how to create one variable data table (indemnity forecast monthly and up to next two years). this time I have brought you two-variable data tables.
We will be also using Named ranges, Indirect Function to make table measure dynamic (either net profit or total sales), scroll bars (form controls) to quickly analyse net profits or total sales values at various prices and quality levels.
As a continuance to my previous video where I had showed you guys how to create one variable data table (indemnity forecast monthly and up to next two years). this time I have brought you two-variable data tables.
We will be also using Named ranges, Indirect Function to make table measure dynamic (either net profit or total sales), scroll bars (form controls) to quickly analyse net profits or total sales values at various prices and quality levels.