An exercise log allows you to chart your workout progress with over time. Microsoft Excel is ideal for creating an exercise log, because you can create a chart of your progress and dynamically update the data in a spreadsheet. Once you've created the log, you can add exercises and other details at any time.
- Skill level:
Other People Are Reading
Start Microsoft Excel. A blank worksheet will open.
Type the different exercises you perform in column A. For example, type "Push ups" in cell A2, "Chin ups" in cell A3 and "Crunches" in cell A4. Do not type anything in cell A1.
Enter the dates for the exercise sessions in row 1. Insert one date per cell. Leave cell A1 blank. For example, type "Feb 1" in cell B1, then type "Feb 2" in cell C1, then type "Feb 3" in cell D1.
Fill in your data. For example, if you perform 10 push ups on Feb 1, type "10" into cell B2.
Create a graph of your progress for one exercise. Hold down the Ctrl key and click the "1" and "2" to the left of the rows to select them. Click the "Insert" tab, then click "Line." Click "2D Line" and a chart of your data will be inserted into a spreadsheet. Click "Switch Row/Column" after the graph has appeared.
Tips and warnings
- The American College of Sports Medicine and The American Heart Association recommend resistance training at least two days per week and intense cardiovascular exercise 30 minutes a day, five days a week.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for