Offistart - Virtual Offices, Office Space, Business Support Services
*Home>>>Service Offices

Need Help With an MS Excel Project?


I want to create an Excel spreadsheet to track the costs/usage of energy consumption for my company from 2007 to current. We currently have 5 main offices with 9 regional offices. I want to track the water, electric, and gas usage. However, there are TWO problems that arise: (1) a lot of the bills have varying time periods such as (10/31-12/4/2007) or 1/3/2007-3/1/2007; (2) Each location has a minimum of 2-3 services (electric, gas, water) offered.

I am searching for ideas on how to create a spreadsheet that covers all areas in a fairly concise manner.

just an idea...

i would go the pivot table route for this.

- you would enter all the data into one table
- dates of service arent an issue...have 1 column for start date, and 2nd column for ending date.
- have 1 column for type (gas/electric...)...the pivot table will sort it out for you.
- entering vendors should be easy...once you type Edison in the 1st time, then the next time you use it, it will try to autocomplete the longer names for you.
-account numbers may not autocomplete, but autofilter should make it easy to sort and copy&paste.
- this is important...make sure you set your table up with a "dynamic named range" (google it or see source-i use dynamic ranges daily)) that way you can add to the bottom, and your range will automatically expand.
- you can create several pivot tables off of the 1 original table.
-you can go to youtube and watch some good video demos on pivot tables if you are not familiar with them.

good luck

Tags
  Meeting Room   Meeting Space   Conference Room   Offices to Lease   Rent Offices   Business Centers   Service Offices   Branch Offices   Temporary Offices   Shared Offices   Commercial Space   Office Space
Related information
  • Phlebotomist job question??

    wow..good luck...medicare and state medicaid have SO many rules and regulations that doing anything like that is going to be a real pain.

    ...
  • Accountant Wants to use GOTOMYPC.com...to access my files from his home..ANY ADVICE, I am weiry about it.?

    If you are unsure of this then I would just not let him... You are under no terms to submit your entire pc agreement or not... I would recomend one of two things. First, ask him what he needs and ...

  • Sonny's office at the Coffeehouse on GH...?

    Yes I've noticed these things too but it doesn't annoy me cuz its tv land. What about the Metrocourt lobby explosion; wouldn't that in real life cause the entire hotel to collapse?...

  • What do I do after I receive my financial aid award letter?

    1. Accept before you register. At most institutions, the aid can be applied at the time of registration so that you are not required to make a payment to hold your classes. 2. It depends on what...

  • What is a good website to search for jobs that require a bilingual person (English/Spanish)?

    look for ethnic market research jobs. They need people that can speak spanish, good luck: ...

  • Regarding credit card outstanding settlement?

    Go to daveramsey.com. His program and advice will tell you what to do. You should NEVER give access to your bank account to anyone involved with a credit card company...you can even e-mail him your...

  • How can i pay off my credit card bill without haven't the statement?

    Why wouldn't they? who would decline money? Worst case scenario, say something along the lines of, "i don't need to know the exact amount, but would $X be enough to cover the stat...

  • How is McCain a good president if....?

    i hate McCain hes gonna screw america up like GEORGE EWWW BUSH we NEED Barack OBAMA

    ...
  •  

    Categories--Copyright/IP Policy--Contact Webmaster