Mastering Excel: Data Tables

Mastering Excel: Data Tables
/ / PDF, EPUB, AZW3


Read Online 2.9 MB Download


This lesson covers data tables. Data tables are a way to analyze different scenarios in Excel. However, you can change many variables simultaneously and see the effect instantly. Data tables let you answer questions like: 'what's the effect of increasing price by $1 increments' and 'how can I create a gird that shows the interaction between a price changes and raw goods changes?'

I'll cover all that and a bit more in a step-by-step fashion with tons of images. My lessons are written with regular users in mind. No technical jargon. As always, when you buy my lessons, I am here to answer any question you may have.

There is a link in the eBook where you can download follow-along workbooks so you can read and practice to learn the tasks.

views: 677