Search Contextures Sites

Excel Weight Loss Tracker

Weight Loss Goals
BMI Calculations
Weekly Weight Tracking
Weight Loss Tracker Dashboard
Weight Loss Tracker - Stone
Download the Weight Loss Tracker
Related Tutorials

With this Weight Loss Tracker, you can enter your target weight, and weekly weight loss goals, then record your weight each week. On the dashboard, a chart shows your progress, and you can see the remaining weight loss required to reach your target.

Warning: Please consult your doctor for recommended target weight and weekly weight loss goals. This workbook does not contain any qualified medical advice -- it is a recording tool only.

Weight Loss Goals

On the WeightGoals worksheet in the Excel Weight Loss Tracker file, there are cells where you can enter your personal data and goals.

Note: The worksheets are protected, with no password.

First, select the measurement system that you want to use -- either pounds or kilograms.

Excel weight loss tracker

Next, fill in your personal data and targets.

Excel weight loss goals

BMI Calculations

The Excel Weight Loss Tracker also has information on Body Mass Index (BMI) from the Center for Disease Control and Prevention.

After you enter your personal data, the WeightGoals sheet calculates your current BMI, and target BMI, and shows the ideal weight range for your height. This is general information, so speak to your doctor about this measurement, and how it might apply to you.

The BMI table is used as a lookup table for the ratings for the current BMI and Target BMI. The Minimum and Maximum ideal weight range is calculated from your height, and the Normal range in the BMI table.

Excel BMI Calculations

Weekly Weight Tracking

After your personal data and targets are entered, you can start recording your weekly results.

Go to the WeightTracker sheet, where weekly weights are entered. It also calculates the weekly weight change.

Click in the Date column, in the first blank row.

Excel weight tracking

Enter the date, and your current weight, and the change is automatically calculated.

Excel weight tracker calculations

After you enter the data, click the Refresh All button, on the Ribbon's Data tab. This will update the pivot table, where your data is summarized.

weight tracker refresh

Weight Loss Tracker Dashboard

Your weight loss results are summarized in the Dashboard, with a simple line chart to show the recorded weights, and your target weight.

You can also see your current and target weights, the total weight change, and shows how much weight remains to lose.

Excel weight loss chart

Weight Loss Tracker - Stone

If you prefer to measure your weight loss in stone and pounds, there is also a version for that measurement system. The Weight Goals sheet looks slightly different, and your dashboard shows stone and pounds.

excel weight tracker stone

Download the Weight Loss Tracker

You can download a zipped copy of the Weight Loss Tracker, and try it for yourself. The files are in Excel 2007/Excel 2010 format.

The sheets are protected, with the green cells unlocked, and there's no password on the worksheets.

If you're using an older version of Excel, you can download the Excel 2003 version of the weight loss tracker. These files have most of the same features as the newer versions, but they contain a set data entry range, instead of a formatted Excel table.

 

 

Contextures
Excel news
by email

 

 

 

 

Learn how to create Excel dashboards.

 

Related Tutorials

Data Validation Basics
Pivot Tables - Create

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.

 

Last updated: April 22, 2014