Tag Archives: Training

Excel: How to show number in custom format

You are able to format Excel’s cell items as you like. You can e.g. add custom texts to be shown with numbers. Typical case is to show numbers with units:

  1. Select the cell/cells you want to format:
    Context menu: Select Format Cells
    Shortcut: Windows ctrl + 1, Mac cmd + 1
  2. Select Number and Custom from the Category list.
  3. If you want to one decimal and unit, type following format code
    0.0″ kg” or
    0.0″ lb”
Following video demonstrates this in action:

How do I use Excel, part #1: Training diary

I’m active sports enthusiast. I have been using Excel based training diary since year 2001. My every single sport activity is marked in Excel. Today I have 2806 activities recorded.

A single activity includes e.g. following information:

  • Date
  • Sport (e.g. running, volleyball, gym, walking, skiing, …)
  • Duration
  • Type (aerobic, strength training, ball games, …)
  • Distance
  • Heart rate
  • Calorie consumption

Using this data I can analyse what ever information I ever need. It is interesting for example to check how my weekly sporting hours have changed during years. Or how my running pace is now much slower than ten years ago 🙂