business analysis

  1. L

    Creating a line graph that shows the relationship between my business's takings and the weather

    Hi, I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner. I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship...
  2. G

    Pivot Table Calculated Item Includes all accounts from Profit and Loss Statement

    GM Excel Crew, I am having trouble and I need some expert advice. I am recreating a PnL statement using a Pivot table. It gives me lots of flexibility for my needs for analysis. However, there is one problem that is driving me nuts. In this PnL there are lets say 50 accounts. Of course its...
  3. R

    Calculating trends and averages on skewed data. Any help would be greatly appreciated!

    I'm running analysis on an Audit that has been distributed over the course of a year. There are currently about 40 or so different audits. Each audit contains 90 questions. When the audit was first published, the results we were getting were skewed. For instance, many of the answers came back at...
  4. M

    Age of Queue each day based on 1 assumption

    I am trying to figure out how to automate or simplify a manual report. I was to track the age of queue of items from one day to the next based on an assumption of how many items we can get through. So for example I have 100 items currently at 58, and then 350 at day 57 and so forth. The...
  5. S

    Excel file/Data Analysis

    Guys URGENT test on Excel data/data analysis PLS help! I will put a link to the excel file below, all I know it contains phone tariff cost info and accounts that say a phone company may use. That's all I know and not supposed to know anything else. I need to say 1. What conclusions can I draw...

Some videos you may like

This Week's Hot Topics