- Видео 3
- Просмотров 73 234
John O'Dor
Добавлен 30 сен 2011
Inluenceable Spend from www.ProcurementMatters.co.uk
Using Excel with Vlookup Formula and Pivot Tables, you can easily see how to define influenceable spend within a Procurement department.
Просмотров: 578
Видео
Procurement Matters. Keeping Track of the Expiry Date of Contracts
Просмотров 3,8 тыс.9 лет назад
Contracts Register, how to automatically generate a report based on the expiry date of a contract using Excel. Once this report is generated it compares the expiry date to today's date and gives a simple Traffic Light Status, Red, Amber or Green. This is useful when managing the workload of any Procurement Team
Spend Analysis, Excel Vlookups and Pivot tables
Просмотров 69 тыс.9 лет назад
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
Great...I just need to practice. How did you learn this info ??
Brilliant thanks
Hey, big thanks, Have any ideas for other videos? Please let me know
Great post! Thanks for sharing.
My current Contract ends this month, so I am looking for a new role
Very useful, thank you. More of these types of practical videos would be great to see, if you have been wondering if you should post more - please do consider.
Reinhard, thanks for your encouraging comments, i am fresh out of ideas of what videos to do next, therefore please suggest some ideas and I will see what I can do. Maybe Procurement dashboards perhaps. Many thanks John
Jamshid, thanks for observing. I am planning to do one on Evaluation, but please feel free to suggest Regards John
excellent video
5:48 value field settings 7:27 add data labels
Very practical approach John, great video, thanks
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
@@johnodor8635 will surely do, thanks
Hi John, I love this demonstration. Where can I get data to practice these steps?
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.
@@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.
@@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
@@johnodor8635 Thank you John, I will certainly try this, you have been very helpful.
Thanks a lot, John. I have an interview tomorrow wherein I would need to demonstrate this capability. Love from Canada.
Thanks for your wonderful feedback. And of course good luck withyour interview. Please check out our website procurement matters.co.uk for more tips.
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.
Hello John, you can send me this spreadsheet, I found the most, thank you very much jailton176848@gmail.com
Glad I found this. Can you make a tutorial using sap spend and doing various ways to analyse categories
give a link for downloading the data used
Thanks a bunch John! It would be great if you can unload the excel sheet so we can practice! Happy thanksgiving!
v basic - waste of time if you've opened Excel ever before
This is very helpful! Many thanks John :)
You have no idea how helpful this video is. Thank you
God bless you.
How can We download the excel sheet
Very Nice.....I will appreciate if you could upload a full tutorial on Procurement spend analysis and other procurement skills.
Muhammad, thanks for your kind feedback. Please let me know the details of what you are looking for and I will see if I can tailor something . Regards John
Gud Video
Thanks! I appreciated the walk through.
James, thanks any ideas for me for my next one, what would be useful to you?
Thanks !
pleased you found helpful. any suggestions for further videos. thanks
Good vid.
Very helpful and easy to understand. Thank you.
+ChrisSay71 , thanks for leaving a message, I appreciate it.
Thank you for the video, very easy to follow. Is there any way that you know to send an email through outlook if a condition is made in excel? Like when some has a licence and it is only for one year, and you want to send an email two weeks before it expires. Thanks so much.
+Chris Pike Chris, I believe that you will have to use the data from Excel, then email merge via Microsoft Word. Use the RAG status as a "condition" to see if email required sending. EG if you decide that "R" is the trigger then make that a condition of the mail merge. If you don't have more than 20, then just use the filter in Excel to filter on the "R", then copy and paste into the BCC in Outlook. Hope this helps. Come back if you are stuck and I will see if we can sort things out. Regards John
Very useful for what I am doing, thanks!