A hands-on course for procurement, accounting and admin staff. Work with real-world sample files, from tidying data to summarising it with Pivot Tables and dashboards.
1 day · 09:00–16:00Onsite · Koh SamuiMax 20 per session
Best for: Procurement, accounting and admin staff
What you will learn
01
Prepare data for analysisTables, data validation, drop-downs and removing duplicates
02
Formulas you will use every dayXLOOKUP, SUMIFS, COUNTIFS, IF and nested formulas
03
Summaries with Pivot TablesTotals by supplier, item and month in a few clicks
04
Budget tracking dashboardCharts and conditional formatting for management reports
05
Workshop: compare quotationsBuild a scored comparison of three suppliers
What you will get
Faster monthly reports with reusable templates
Ready-to-use sample files for your own work
Enough understanding to adapt formulas yourself
Certificate of completion
What you can improve at work
Monthly purchase reportsFrom manual work every month to one-click refresh
Supplier selectionCompare price and terms systematically, with an audit trail
Department budget controlSee actual spend against budget at any time