Ravi Sir's Cards › Excel
Weight Loss and Fitness Tracker in Excel (card 2 of 2)
Revision card 2 for Weight Loss and Fitness Tracker in Excel: Goal value for the chart: =$H$5 gives 60.0; Latest weight: =INDEX(B5:B200,COUNT(B5:B200)) gives 64.7; Lost so far: =B5-H7 gives 3.7. Includes an example data table.
Read card text
What this card says
2 for Weight Loss and Fitness Tracker in Excel: Goal value for the chart: =$H$5 gives 60.0
Latest weight: =INDEX(B5:B200,COUNT(B5:B200)) gives 64.7
Lost so far: =B5-H7 gives 3.7. Includes an
Example
data table
Learn this in the lesson: Weight Loss and Fitness Tracker in Excel: BMI Formula, Progress % and a Line Chart with a Goal Line