1 / 4

Real Estate Technology

Real Estate Technology. Excel data And pivot tables. HG Technology Limited T: 0845 366 5830 E: ret@hgtechnology.co.uk.

lenka
Télécharger la présentation

Real Estate Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Real Estate Technology Excel data And pivot tables HG Technology Limited T: 0845 366 5830 E: ret@hgtechnology.co.uk

  2. Excel has had the pivot table function for many years, and I still prefer the excel 2000 version! However 2013 has added some nice automated features and is certainly better for the first time user. • A Pivot table is a means of taking data from a spreadsheet and summarising it quickly and very easily. You can also create pivot charts in the same way. • Here is an example : - • We have a record of sales at a Market fruit stall and have recorded the customer, product purchased, date, quantity, price and value. From this we can try and find out: • What days aren’t very busy? • Who is the best customer? • Which stock sells least, by price and by quantity and value? HG Technology Limited T: 0845 366 5830 E: ret@hgtechnology.co.uk

  3. Here is a brief cut of the data The records are all ordered in rows and there is a proper title at the top of each row, this is important as the pivot table won’t work properly otherwise There is also a bit of a clever formula to work out the Weekday in the end column, but we will ignore that HG Technology Limited T: 0845 366 5830 E: ret@hgtechnology.co.uk

  4. Here is the result Maybe now is the time to stop selling Apricots and lets close the stall on Wednesdays and Sundays HG Technology Limited T: 0845 366 5830 E: ret@hgtechnology.co.uk

More Related