Using excel to track utility usage

Asked By Hailey Malles 0 points N/A Posted on - 05/06/2013

Hi Guys,

I'm trying to get a summary of the utility usage in my computer. Can we do it using excel to track utility usage? How can we possibly do it? Please help.

Thanks,

Hailey

• Status: Open
• Question Views: 1036
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Burton Studebaker 0 points N/A #176427

Using excel to track utility usage

Good day Hailey!

 

Yes, we can do it using excel. The utility usage can be tracked in an Excel sheet by taking a few utility bills, perhaps going back as far as a year. 

 

Create a spreadsheet with the values on the bill.

 

Values such as kilowatt hours (KWH), amount of the bill can be put in columns and the months in rows. This is just data entry.

 

Then we can apply formulas like average, min & max to see whether the average is rising or declining. This will then form a trend and can be compared with your neighbors.

 

Also, we can create a quick bar chart or line graph to see your trends at a glance. This is done by selecting the data and then Insert tab, then Charts, then Line.

 

I hope this information helps you.

 

About Burton Studebaker

Questions
4

Answers
76

Best Answers
49

• Vote Up 0 Vote Down

• Posted on - 05/15/2013
• Question Category: MS Excel