Using Names in Formulas in Excel + Break-even chart Template in Microsoft 365
This video shows how to define and use names in Microsoft Excel while setting up table for, and constructing, a Break-even chart.
00:00 Naming values in Excel
00:43 Calculating Breakeven Point in Units
01:09 Setting up Table for Breakeven chart
03:28 Using the @ sign for current row
03:52 Constructing the Breakeven chart
04:55 Adding axis tiles and changing input values