business analysis

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

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

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

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

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