How to Use MS Excel to Report Progress

Written by hunter taylor
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use MS Excel to Report Progress
Use MS Excel to track progress toward a goal. (progress image by lidia_smile from Fotolia.com)

Microsoft Excel is spreadsheet software used for calculations ranging from simple arithmetic to complex statistical and engineering formulas. One of Excel's major features is the ability to create charts, graphs and other visual representations of data. A chart or graph makes it easier to draw conclusions about data and to track progress toward a goal. Teachers and business leaders use Excel to track progress toward students' grade goals or a company's sales goal.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Enter the data into the spreadsheet. For example, if the purpose is to track progress toward a grade, type the name of the student along with the goal grade for each exam. Label the columns and rows with the student's name, grades and goal grades.

  2. 2

    Click the "Insert" tab, then click "Line" then the 2-D Line Graph. Right-click with the blank square box and go to "Select Data..." The data selected in this example would be the goal, student's name and the grades.

  3. 3

    Click beside the square in the Chart Data Range box. Highlight the data to be included in the chart. Click "OK." Add new data as grades and goals are updated.

Tips and warnings

  • MS Excel can also be used to track progress toward a diet and fitness goal, or to track projects and computer issues.
  • Be careful not to include too many line items because the graph may become difficult to read.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.