Sample 3: Collating of Data Using a Pivot Table and Macro

For My Driving Instructor Download: https://drive.google.com/file/d/0B1pEq2dN7H9AWi1qNHdBY2J1QVk/view?usp=sharing I came across an interesting situation with my driving instructor.  He was collating a list of all the lessons the instructors in his team had taught for the day and the result of the lesson, being a pass or fail. He was collating this data by hand and I asked if I could help him.  I don’t think he took me seriously, but here is the solution – dear instructor, this is for you if you happen across this site. The spreadsheet uses a macro that automates the creation of a pivot table – with some basic VBA thrown in. Remember to ‘Enable Macros’ when you open the file and press the button ‘Process Data’.

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!