Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick # 254: Data Table Creates 100 Formulas


See how to create a Contribution Margin Income Statement Analysis across various units using a 1 Variable Data Table (What if analysis). See how to create 5 columns of different formulas quickly using the Data Table feature in Excel.
See how to create a break even analysis X Y Scatter diagram Chart in Excel based on Contribution Margin Analysis with Sales, Variable Costs and Fixed Costs.
See how to create Conditional Formatting For A Row.
See how to set up a spreadsheet efficiently with an assumption table for input values.

Other What If Analysis videos:

Excel Magic Trick 253: Data Table 1 Variable What If Analysis
Excel Magic Trick # 254: Data Table Creates 100 Formulas
Excel Magic Trick 255: Data Table 2 Variable What If Analysis
YTLE#103: Excel Goal Seek
Highline Excel Class 22: Scenarios & Scenarios Report

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.