How to Use MS Excel to Make Trackers

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Image Credit: Polka Dot Images/Polka Dot/Getty Images

Whether you're trying to watch your savings for an upcoming cruise grow, take notes on the calories consumed each day or record the miles you've run per week, you can use Microsoft Excel, a spreadsheet program included with your Microsoft Office installation. Excel is a simple, basic tracking program that you can configure to help you quickly and easily view notes and numbers, letting you make plans and keep track of your progress. With a few simple clicks, you can make trackers in Excel for a variety of daily items.

Advertisement

Step 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.

Advertisement

Video of the Day

Step 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.

Advertisement

Step 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.

Step 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.

Advertisement

Step 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.

Advertisement

Step 6

Fill in your tracker information for each of the cells (a cell is the individual box on the spreadsheet).

Step 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.

Step 8

Resave your file to update the information.

Video of the Day

Advertisement

Advertisement

references