Here is a tutorial for performing VLOOKUPs. The unique field in this example could be customer name or customer number. A VLOOKUP would allow you to match by customer the total revenue and address so you can see all this data in one place. For example, imagine you have a list of customers where one list includes details of the total revenue and the customer address but the customers are ordered randomly. You do need one unique field that is included in both datasets to match these up. If you are unaware of this function, to put it simply, the VLOOKUP allows you to match data from different sources.

I of course did not remember much by time I actually needed to use it in a work scenario but it definitely would have helped! I remember first coming across the VLOOKUP function during my ICT GCSE.

This is arguably one of the most important functions to be aware of. Always remember the grand total is given at the bottom as well as “(blank)” data.Copying and pasting values of the pivot data can be especially useful where you want to sort the data and play around with it further.To correct this simply click on the dropdown option where it states “count of…”, select “value field settings…”, select “sum” and “OK”. You may find when you drag and drop fields into the pivot areas that the value is sometimes automatically set to “count” instead of giving the total value it tells you the total number of entries.I would highly recommend playing around with a pivot table to improve and get quicker at creating these how you need.You can refresh pivot tables if the raw data changes.

Make sure there are no blank fields/columns when creating the pivot table.

Advanced excel tips and tricks 2021