Reviews
"I finally understand the purpose of PivotTable and how it works in analysis. Never knew dynamic table and PivotTable are supposed to work together. I used to copy and paste which I always made mistakes in my records since I forgot at times to update the data. Now it is automated." - Hazel Yeo
"What intrigued me to learn was the AI prompt which I want to know how to use it in my vendor management without learning much about analysis as a non-numeric inclined person. I was interested in analysis but never knew how to do it. This course is less technical and I was able to grasp simple concepts on how to see pricing differences and who overcharge me now." - Anonymous
"Though I worked more than 10 years in F&B, I never know this concept of working capital optimisation and how vendors can impact on the finances. Now, I finally learned how to negotiate with vendors on prices or credit terms." - Mei
Why learn this?
By the end, you'll be able to:
- Turn a messy supplier or transaction export into a clean, structured table in minutes, not hours
- Build pivot tables that surface the outliers — not just the totals
- Use AI prompts alongside your own review to flag pricing anomalies you'd otherwise scroll past
- Walk into a meeting with a specific, defensible number — "this supplier's pricing crept up 12% over 6 months" — instead of a vague hunch
WHO THIS IS FOR?
You're the person who opens the supplier invoice spreadsheet every month and has a nagging feeling something doesn't add up — a duplicate payment, a supplier who quietly raised prices, a "promo" that never made money. You don't have a data team. You have Excel, and not quite enough time to dig as deep as you'd like.
This course is built for procurement, finance, and operations staff in F&B, logistics, manufacturing, and retail businesses — people who are expected to "just check the numbers" but were never trained to do it fast or systematically.
THE PROBLEM?
Most Excel courses teach you formulas in isolation. Most AI courses teach you prompting in isolation. Neither shows you how to combine them to actually catch the specific thing costing your business money: pricing anomalies, duplicate charges, and suppliers or transactions that don't behave like the rest.
Course outline
Course structure:
100% video-led, self-paced, lifetime access. Every unit follows the same rhythm: watch a short demonstration, work through a scenario-based exercise using a realistic business dataset, then check your own answer against the model solution. No graded pressure — the goal is that you can actually do this on your own data afterward.
Highlights of the course:
- Getting Your Data Analysis-Ready — cleaning messy exports, Format as Table, and why structure matters before you analyse anything
- Pivot Tables for Real Decisions — building pivot tables that answer "where's the anomaly," not just "what's the total"
- Combining Functions to Spot What's Hiding — layering lookup, conditional, and aggregation functions to surface what a single formula would miss
- Finding Supplier Pricing Anomalies — a full walkthrough on a supplier-spend dataset: detecting price creep and inconsistent charges
- Reading the Story in the Numbers — turning your findings into a short, decision-ready summary a manager can act on
- Working AI Into Your Analysis — practical AI prompts that complement (not replace) your own review, and where to stay skeptical of AI output
What's included:
- 100% video-led demonstrations across 5 sections
- 15 scenario-based exercises using realistic business datasets
- 10-question assessment with answer key
- Bonus module: AI prompts for analysis
- 24/7 access to course materials
- Certificate of completion
Modules:
-
1Course introduction
-
2Format as Table
-
3Slicer
-
4PivotTable
-
5Combining functions
-
6Course Summary
-
7Assessment
-
8Bonus - Excel analysis with AI
Choose your plan
Built by a CFP, not a generic Excel trainer who spent 15 years as a Certified Financial Planner reading financial numbers for a living, then 10 years teaching non-analysts to do the same in Excel.
Blak Rice, Singapore: winner of Regional Business Training Provider of the Year (2024).
Single License
$99.00
Department (15 seats)
$1,099.00
Not sure if you are ready?
Check out this preview and see how simple it is to learn analysis with our step-by-step guide!
ABOUT YOUR COURSE DEVELOPER
Hsu was a university lecturer specialised in Excel and AI data strategies, and a financial advisor for 15 years’ of experience, before becoming a consultant managing data analytics and digital transformation projects across 10 countries in Asia and the Middle East. Hsu has international certifications in CFP (Certified Financial Planner), Microsoft Excel Specialist, IBM Data Science, ScrumMaster and adult training license which make her a professional and expert in data analysis.
The course is well designed according to the market demand and business landscape that suits executive, managers and business owners who faced challenges in tracking costing and pricing. Easy to learn and understand. It is not a generic Excel tutorial, not a technical AI programming course, it is an integration of analysis using Excel as a tool.
FAQs
-
This Agreement is entered into by and between Blak Rice Pte Ltd (the "Company") and the purchaser (the "Buyer"), which may be either an individual consumer or a corporate entity. The specific title of the online course purchased (the "Course") and the final mutually agreed-upon course fee (the "Course Fee") are explicitly specified and reflected in the autogenerated electronic receipt issued to the Buyer immediately upon a successful transaction. The Buyer acknowledges that this autogenerated receipt serves as the official confirmation of purchase and contains all necessary transactional data. It is the sole responsibility of the Buyer to retain and file this receipt for their own taxation, corporate accounting, or financial record-keeping purposes.
-
All buyers acknowledge that the training programs provided by Blak Rice Pte Ltd are delivered exclusively as online, asynchronous, self-paced learning courses. There are no live lecturers, instructors, or mentors designated to facilitate, guide, or provide real-time support during the training modules. Throughout the curriculum, learners will navigate a non-graded assessment designed solely to test their personal knowledge, track progress, and reinforce comprehension of the material. A premier benefit of this learning model is that it features no fixed completion time limits, offering buyers unlimited, lifetime viewing of all instructional videos and interactive exercises. Learners are encouraged to review the content as many times as necessary to build ultimate confidence before completing the course.
-
To ensure our training meets your specific learning objectives, Blak Rice Pte Ltd provides prospective buyers with two distinct ways to evaluate the material prior to enrollment. First, you may access a complimentary course preview ("Modifying layout of PivotTables"), which allows you to watch one complete, live instructional lesson selected directly from one of our main modules. Second, you can click from the last plan option ("Excel - Burger outlet") to download a free, comprehensive worksheet to independently test and experience our hands-on practical exercises. We strongly encourage all individual and corporate buyers to utilize these free resources to thoroughly assess and evaluate whether the course curriculum, delivery style, and structural depth are suitable for your educational needs before making a final commitment.
-
By purchasing or enrolling in this course, you agree that all payments made by individuals or corporate entities are strictly non-refundable. Once access to the Course materials, platform, or proprietary content is granted, or upon receipt of corporate booking confirmation, no refunds, cancellations, or credits will be issued under any circumstances, including but not limited to non-usage, scheduling conflicts, or employee turnover. For corporate clients, the total fee is fixed upon signing, and no partial refunds will be provided if fewer individual users complete the training than originally contracted.
-
To enroll as a single user, click on the Single License plan option on our platform. Proceed to the checkout page, where you will be required to register for a personal customer account to secure your access. Immediately upon successful payment, an official transaction receipt with a license key will be automatically sent to the email address you provided. To begin your training, simply log in to your newly created account, access your dashboard, and start learning at your own pace. Once you have successfully completed all modules of the Course, an official course certificate will be automatically generated and made available through your account portal.
-
To enroll a team, select the corporate course tier that matches your required headcount: Small team (for up to 5 license), Department (for up to 15 license), or Organisation (for up to 25 license). During the checkout process, the purchaser (usually program administrator or training team lead) must register for a customer account using a valid corporate email address; this account holder will serve as the designated Course Administrator. Upon successful payment, an automated transaction receipt with a Master Corporate License Key will be sent to the provided corporate email. Course Administrator will need to download the instruction guide and forward to enrolled employees for them to register their respective individual accounts using the unique license key given. All enrolled employees will receive their individual course certificate upon successful completion.
-
Multi-user licenses provided by Blak Rice Pte Ltd are sold in structured capacity tiers based on your total team size. A 5-user license is designed for small teams and accommodates anywhere from 2 to 5 individual users. A 15-user license scales up your access, allowing entry for up to 15 individual users. A 25-user license serves larger departments, providing training seats for up to 25 individual users. For organizations requiring a custom volume or anything exceeding 25 users, we provide a Customised license tier. Companies under the Customised tier will need to contact directly at onlinecourse@blakrice.com.sg for customisation on the training timeline, seat capacity and certification design.
-
If you are keen to be our affiliate, look here. 30% commission on all tiers, up to 30-day tracking.
Simply sign up here: https://payhip.com/auth/register/af6a7804e86591c
Upon receiving the contract, read the terms and reply to our email. We will review your application and reply you within 3 working days. For the agreement, you can read here: https://onlinecourse.blakrice.com.sg/affiliate-programme
About us
Leading AI Automation & Digital Government Advisory | Training & consulting in 10 countries, 86 courses, 5,760+ certified in Excel | Company of Good 2 Hearts 2026 | Regional Business Training Provider of the Year 2024
Our online courses are modular and easy to learn within hours. All courses are designed by professionals who are certified in analysis and technical aspects. We not only developed courses on data analysis, finances and leadership but also communication and strategies deployment - both corporate and individual level.
