Magic to make the boss’ jaw drop with Pivot Tables!

Data Processing 2: Pivot Tables Time to learn: 20 minutes Have tonnes of data that you can’t make sense of?  Need a fast way to organise and view your 10,000 cell spreadsheet?  Then, pull that rabbit out of your hat with pivot tables! A pivot table compiles and summarises all the information in a spreadsheet into a table that you can manipulate easily.  Saves you time and makes you look incredible! The pivot table is an awesome function and helps you do many things at once! Step 1: Let’s start with some data. Here we have 19 colleagues and the number of sales they have completed from January to March. Now, what if we want to count the total sales for all of them per month? Step 2: Now, click on any cell that has our data in it (meaning anywhere from cells A1 to D20) and then click on the ‘Insert’ tab and select ‘Pivot Table’. Step 3: An option

read more Magic to make the boss’ jaw drop with Pivot Tables!