How to Create an Exercise Log Using Excel

Save

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.

  • 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 & 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.

Related Searches

References

  • Photo Credit Creatas Images/Creatas/Getty Images
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!