If you have daily data to aggregate into weekly or monthly data, you can accomplish that easily in Microsoft Excel, thanks to pivot tables. Just select any other time unit you like instead of days. NOTE: The method to create by MONTHS (or any other time period listed in the GROUPING screen) is the same.
(5) Click OK to create your aggregate table for WEEKS: In the GROUPING dialog box select DAYS and “7” in the NUMBER OF DAYS drop-down list: (4) Now, select any of the days and right-click. Your Pivot Table will be created automatically: (3) Click DATA to insert it in the VALUES quadrant of the Pivot Table and click DAYS to insert it in the ROWS quadrant. (2) In the Create Pivot Table dialog box, select Existing Worksheet and then click on a cell for insertion point: Let’s say this is what your daily data looks like: With that precautionary note, here is how you can accomplish this procedure. However, if for example your data is “average temperature per day,” then it of course does not make sense to aggregate such data since the temperature for a week is not the aggregate sum of daily temperatures but their arithmetic mean. You can apply this method to, for example, a data of “trucks arrived” or “shirts bought” per day since the total aggregate amounts would still make sense for longer time units. Knowledge is power - if you don't know what's available you can miss an opportunity or spend hours trying to jury-rig a solution by cobbling together other functions.If you have daily data that still makes sense when aggregated into weekly or monthly data, then you can accomplish that very easily in Microsoft Excel, thanks to the pivot table. You can't add these to any favourites list but you can make your own "Check these out" list Similarly, open the Function Wizard window and check out the functions available (made easier bc you can do so by category). If so, add it to your QAT and try it out.Ģ.
open the Customize Quick Access Toolbar window and just scroll through the list of commands available (Note: some are only available thru customisation as they are not on the inbuilt menu!) and see what each tool does and whether it may be useful to you. I'm from the same era: Learned 123 in 1984/85 from a 5.25" floppy tutorial, & Multiplan, then progressed thru Symphony, Supercalc, back to 123, and then Excel 4 & 5 in 1995 - and have never looked back! That's the beauty and ugliness of Excel - there are more tools & features than you can ever learn or know about!
0 kommentar(er)
