How to Use MS Excel to Make Trackers
- 1). Open Excel, click on the "File" menu, and then select "New." A blank spreadsheet appears in your workspace. Click on "File" again, and choose "Save As." Name the file, such as "Cruise 2010," "MarathonMiles" or "CaloriesConsumed," and click on the "Save" button.
- 2). Click your cursor on column B, and then type the word "Monday." Repeat for the next six columns to add the other days of the week. Click your cursor on the number "1," the first cell in the row you've been typing in, to highlight it. Right-click on the cell, and select "Format Cells." Click on the "Patterns" tab, and click a colored box; this colors in the cells in that top row to distinguish them from the rest of your tracker.
- 3). Click on the "Font" tab, and then choose a font. Choose "Bold" from the "Font style" menu and a "Size" of "14." Click on the "OK" button. This makes the entire row stand out.
- 4). Right-click on the "A" column header, so the column is highlighted, and then repeat the changes you just performed with the same pattern and font styles and sizes.
- 5). Click on row 3 of column A (leave a blank row between the header row and the information rows for visibility), and type the first topic to track, such as "Hardware Store." Click on row 4 of column A, and then type a similar topic, such as "Grocery Store." Add more rows, with as many headers as required.
- 6). Fill in your tracker information for each of the cells (a cell is the individual box on the spreadsheet).
- 7). Click on the "Chart Wizard," which looks like a small bar chart, at the top of the toolbar (this step is optional). Click through the options to create a visual representation of your tracker, such as a pie chart or line graph.
- 8). Resave your file to update the information.