Collaborate on Electricity Bill Format in Excel for Sport Organisations with Ease Using airSlate SignNow

Electricity bill format in excel for Sport organisations

so I want to go through how to create graphs and a pivot table uh specifically using monthly data and uh going through the data points over several years and the reason for that is lots of people want to see monthly Trends over years uh whether it's uh month to month to month from one year to the next um or across years so lots of times what would happen is you would get a bunch of data and it's in a year month and some type of number so uh often the case the number might represent sales or it might represent expenses or it might represent um you know even downloads or how many views a uh website has gotten so the structure of the data is sometimes kind of uh very tabular uh which is a year here and then the months here and then whatever count uh it represents so how do you turn this basically into something that looks like this with a pivot table that does the kind of uh totals across uh per month and also uh vertically uh Through The Years so and then actually being able to see the yearly view of it and also the month-to-month view of it so um I'm going to go ahead now and um this is the end result that you're going to see so I'm just going to go step by step and show you how it's done so um if I go to my Excel spreadsheet here um all I do is really highlight all of the rows and I'm using excel20 here go to the insert tab select pivot table so I'm going to do a pivot table and I'm actually going to say new worksheet uh that looks fine just click okay and I am going to put the year here and the month here this is actually the um so this is actually not the right way of doing it but I just wanted to show you this way you know where I'm actually doing it in reverse and uh here it's the sum now suppose I didn't want the sum I wanted just the count uh so I would actually highlight that last option there and change but I actually do want the sum so I'm just going to versus you know the count of how many time it occurs so again it would be this value field setting here now um the the problem with this is if if I highlight these and I want to create the graph by going to insert graph you'll see it creates something like this and and notice there wasn't much work there so it's it's hard to compare side by side and if I do the line graph if I highlight this you have to highlight the data you want first and then pick the type of graph you want so you'll notice this is by all the individual months here so um now that's not what I want so I'm I'm just going to leave this alone here and I'm going to create another one so I'm going to go back and actually I'm going to name these data and it's actually monthly dat data not yearly data and this is the pivot table by month now I'm I'm going to do it the other way now and show you the difference which is the way I really want it so again I'm going to highlight my data go to the pivot table and and I am going to name this pivot by year so if I go to my pivot table here and I drag year over there I drag month as the rows and I'm going to drag and again I sometimes I might have to change this to a different um value but I actually want some so that's kind of fine now if I highlight the data that I want to graph and I go to the column graph you'll see it's now separated by month which is exactly what I want so I I could tell if I hover over it this is uh for January and February so I could see a side by side the 2001 numbers 2012 2013 numbers and again if if I want the line graph of it I simply highlight the data and select the line graph and I could see the trends uh stacked on top of each other from year to uh year to year across months now I I do want to clean this up a little bit so um I might want to you know name these January February so that looks a little bit better and um I don't believe it'll update and it doesn't but if I did that and I did this again the year and the month is the rows that's kind of odd that it didn't um actually update for okay so what I did was I right clicked and I clicked refresh so I'm going to go ahead and do the same for these and it actually turned into the months now so that's how you do it um and if I go here you can see now the column headers are also changed so what I did was I just went to the pivot table and I went to the rows and I just clicked refresh and went from 1 through 12 to January and December so there you go if if you look at it um that's uh how my original was and that that's how you can basically look for Trends um whether it's downloads or sales or expenses across years uh drilling down into the months so um all right uh you know this is very common type of scenario and task that people look for uh so um you know the yearly slash monthly type of numbers that people want okay uh thank you for watching