Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: Data Table

How to Create One and Two Variable Data Tables in Excel

One Variable  and Two Variable Data Table in Excel Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table. Assume you own a book store and have 100 books in storage. You sell a certain % for the highest price of…