1 / 4

Mastering Excel Pivot Tables for Effective Data Analysis in Real Estate

Discover the power of Excel pivot tables with HG Technology Limited, your expert in real estate technology. Learn how to efficiently summarize and analyze data using pivot tables, a feature available since Excel 2000 and enhanced in 2013. Through practical examples, find insights on customer trends, product performance, and optimize sales strategies for your business. Whether you're assessing busy days or identifying top customers, pivot tables streamline your decision-making process. Contact us today to unlock the potential of your data!

lenka
Télécharger la présentation

Mastering Excel Pivot Tables for Effective Data Analysis in Real Estate

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