Starter kit: guide, practice dataset, Excel workbook, AI prompts
Turn procurement data into decisions
Excel, Power BI and AI for procurement, supply chain and finance professionals. Learn spend analysis, compliance, savings and safe use of AI on a realistic practice dataset where every number can be checked.
CA$15 once (about NGN 14,400). Card payment by Stripe. Instant download. All sales final.
Everything a procurement analyst needs, in one kit
Twelve chapters that take you from a raw spend file to a decision management can act on.
- Spend analysisClean and reconcile the data, then see where the money goes and who you depend on.
- Compliance and controlsMeasure PO and contract compliance properly, and find off-contract spend.
- Tail spend and cashSmall invoices, payment terms and working capital.
- Category strategySegment suppliers and decide where sourcing effort pays off.
- Savings Finance will signBaselines, price versus volume, leakage and FX.
- AI for procurementWhat to automate, what never to, and 28 prompts with built-in checks.
- Excel and Power BIPower Query, formulas, pivots and DAX, with an expected value for every step.
- Reporting to managementOne-page reports and difficult conversations with budget holders.
Two obvious answers. Both wrong.
One example of the method, from Chapter 3. The fictional sample company reports 82.03% PO compliance and 62.06% contract coverage. Both figures are correct. Most people then combine them, and get it wrong.
- 56%Wrong Add the two exception rates to get "total exposure". It double-counts the spend that has neither a PO nor a contract.
- 20 pointsWrong Subtract one rate from the other to get "the PO but off-contract gap". Two opposite failures cancel out and hide the real problem.
- 46.59%Right Cross the two flags instead. This is the share of spend outside at least one control.
Fictional sample data from the kit's dataset: 150 invoices, 20 invented Nigerian suppliers, NGN 552,660,500.
Read Chapter 3 free The full method, 7 pages, PDF, no email needed.
Approved, but off-contract
28.62% of spend, NGN 158.2m
Someone raised a PO and an approver signed it, yet the supplier has no contract. A PO compliance figure cannot see this box.
What is in the kit
One zip file, about 1 MB. Works offline once downloaded. No video: everything is written, worked and checkable.
- 54pagesThe guide 12 chapters: data you can trust, concentration, PO and contract controls, tail spend and cash, category strategy, savings, safe AI use, and reporting to management.
- fxevery formulaBuild Guide for Excel and Power BI Step-by-step builds, with the expected value for every formula, so you know your build is right.
- 29exercisesAnswer key 29 exercises and 3 case studies with worked answers.
- 28promptsAI Prompt Library 28 prompts for procurement analysis.
- 150invoicesFictional dataset 150 invoices, 20 invented Nigerian suppliers, NGN 552,660,500. Every example in the kit uses it.
- 21checksSelf-checking Excel workbook 21 checks confirm your key numbers.
- 29KPIsKPI dictionary 29 procurement KPIs with definitions.
The guide's 12 chapters
- Start with the decision, and trust the data first
- Where the money goes, and who you depend on
- Controls: PO, contract and the matrix that shows the truth
- Tail spend, payment terms and cash
- Building it in Excel and Power BI
- Category strategy and supplier segmentation
- Savings, contracts and value
- Using AI safely and usefully
- Reporting to management and running a small team
- Working in Nigeria and similar markets
- Your career: working to global standards
- What this data cannot tell you
Look inside
Real pages from the kit. Swipe, or tap a page to open it full size.
The guide opens with how to use the kit and what each file is for.
Controls: why a high PO figure can sit beside weak control.
The workbook's Checks sheet sets your numbers beside the expected ones.
Answer key: the task, the worked answer and the common mistakes.
Build Guide: the Power Query steps, each one explained.
Prompt library: prompts to copy, with tests to check the AI's answer.
Is it for you?
For you if
- You work in procurement, supply chain or finance and are asked to turn spend data into answers.
- You want to use Excel, Power BI and AI with confidence, not guesswork.
- You report to management and need numbers that hold up when Finance checks them.
- You are studying for CIPS or a similar qualification and want hands-on practice alongside the theory.
What you need
- Excel with Power Query. Power BI is optional; the Excel path is complete on its own.
- No company data. You practise on the fictional dataset.
Not for you if
You want video lessons, a certificate or a job guarantee. This kit offers none of those.
Get the Starter Kit
CA$15
CA$15 once (about NGN 14,400). Card payment by Stripe. Instant download. All sales final.
Every chapter turns a procurement question into a number you can defend in front of management. Learn it on practice data, then use it on your own.
One payment, no subscription. Free updates to the kit are included.
Get the kit, CA$15Charged in Canadian dollars. Your bank sets the naira amount and may add a fee. Visa and Mastercard are accepted. Verve cards do not work on this checkout. If your card is declined, see "My card was declined" below.
Questions
Which cards work, and how much will I actually pay?
Visa and Mastercard debit or credit cards, through Stripe's checkout. Verve cards do not work on this checkout. The price is CA$15, charged in Canadian dollars, which is about NGN 14,400. Your bank converts it at its own rate and may add a fee, so the final naira amount on your statement can differ slightly. Your bank may also send you an OTP to confirm the payment.
My card was declined. What can I do?
Many Nigerian banks limit or switch off international card payments on naira cards. Try these in order: turn on online and international transactions in your bank app; check your international spending limit; try a different Visa or Mastercard, such as a dollar card or a virtual card. If you were charged but did not reach the download page, email us with the address you paid with and we will sort it out.
How do I get the files?
Straight after payment you go to a download page. The kit is one zip file of about 1 MB. Stripe also emails you a receipt. If anything goes wrong, email support with the address you paid with.
Can I get a refund?
No. The kit is an instant digital download, so all sales are final. Read Chapter 3 free first to see exactly what you get. If a file is damaged or will not download, email us and we will send you a working copy.
Can I use it on my phone?
You can buy and download on your phone, and the PDFs read well there. The exercises need Excel with Power Query, so the building is best done on a computer. Power BI is optional. Everything works offline once downloaded.
Is this accredited or endorsed by CIPS?
No. It is independent training material, created by a procurement professional with CIPS training. It is not accredited or endorsed by CIPS or any professional body.
Start with the method in Chapter 3
Read the chapter free, or get the full kit now and work through all 29 exercises with the answers beside you.
CA$15 once (about NGN 14,400). Instant download. All sales final.