Spend Analysis, Excel Vlookups and Pivot tables

In this short video I will show you how to take raw spend data and create Procurement categories to enable anyone to summarise the spend of any sized organisation. no steps are missed

[@eurobloke17]

This was an excellent video. I've used Excel at a basic level for years but never got to VLookup commands or pivot tables. I tried my own version and it worked beautifully until the final step (where you count down 3,2,1 and then get a breakdown of telecom spend by invoice), which mine didn't do, for some reason. But never mind. The rest was brilliant.

[@RW-td2hz]

You have no idea how helpful this video is. Thank you

[@angeleyes1436]

Brilliant thanks

[@johnodor8635]

Hey, big thanks, Have any ideas for other videos? Please let me know

[@user-sb1jf1cm5q]

Great post! Thanks for sharing.

[@johnodor8635]

My current Contract ends this month, so I am looking for a new role

[@divyanshuchauhan1245]

Thanks a lot, John. I have an interview tomorrow wherein I would need to demonstrate this capability. Love from Canada.

[@johnodor8635]

Thanks for your wonderful feedback. And of course good luck withyour interview. Please check out our website procurement matters.co.uk for more tips.

[@davidwang1229]

Thanks a bunch John! It would be great if you can unload the excel sheet so we can practice!
Happy thanksgiving!

[@ambeshkumar8931]

Very practical approach John, great video, thanks

[@johnodor8635]

Ambesh, thanks for your comment, really pleased you found it helpful, if you have any suggestions for further Spend/Category management videos, please send me a message. Regards John

[@ambeshkumar8931]

@@johnodor8635 will surely do, thanks

[@johnodor8635]

Jamshid, thanks for observing. I am planning to do one on Evaluation, but please feel free to suggest Regards John

[@ChrisSay71]

Very helpful and easy to understand. Thank you.

[@johnodor8635]

+ChrisSay71 , thanks for leaving a message, I appreciate it.

[@jamshid1393]

excellent video

[@samjkdoman]

Very useful for what I am doing, thanks!

[@K1dsCanPlay2]

God bless you.

[@arkalasaiprasad31]

Gud Video

[@judyl.7811]

5:48 value field settings
7:27 add data labels

[@a4rthi]

This is very helpful! Many thanks John :)

[@jamescooley9643]

Thanks! I appreciated the walk through.

[@johnodor8635]

James, thanks any ideas for me for my next one, what would be useful to you?

[@bigmac703]

Great...I just need to practice. How did you learn this info ??

[@888drno]

Thanks !

[@johnodor8635]

pleased you found helpful. any suggestions for further videos. thanks

[@amauta5]

Good vid.

[@benjamincochran2329]

Hi John, I love this demonstration. Where can I get data to practice these steps?

[@johnodor8635]

Benjamin, good day, Apologies, i didn't keep the template, but what I advise is to pause the video and enter the data and formulae as you go.

[@benjamincochran2329]

@@johnodor8635 no problem John, that's exactly what I decided I should do. For some reason though, following the steps using Excel 365, I am getting #NA when I do the VLOOKUP.

[@johnodor8635]

@@benjamincochran2329 Benjamin, 365 shouldn't make any difference. Suggest you look to using the Dollar signs ($) to give an absolute reference to ensure that the N/A is not coming back as a value. Hope this helps John

[@benjamincochran2329]

@@johnodor8635 Thank you John, I will certainly try this, you have been very helpful.

[@elchinshabanov7544]

How can We download the excel sheet

[@yogeshalmiya5892]

give a link for downloading the data used

[@pranamdaga8716]

v basic - waste of time if you've opened Excel ever before