AI-Assisted Excel Analysis
Spot the Money Leaking Out of Your Supplier Spend
Why learn this?
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.
WHAT YOU'LL BE ABLE TO DO BY THE END?
- Turn a messy, unsorted supplier or transaction spreadsheet into a clean, structured table in minutes, not hours
- Build pivot tables that surface the outliers instead of just summarising totals
- Use AI prompts alongside your own analysis to flag 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
- Apply the same method to any new dataset your business throws at you, without needing to relearn it
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 8 units
- 15 scenario-based exercises using realistic business datasets
- 1 self-check assessment
- Bonus module: AI prompts for analysis
- Lifetime access and lifetime certificate of completion
Modules:
-
1Course introduction
-
2Format as Table
-
3Slicer
-
4PivotTable
-
5Combining functions
-
6Course Summary
-
7Assessment
-
8Bonus - Excel analysis with AI
Choose your plan
One time payment. No hidden cost. All prices quoted in USD before promo code applies. You are advised to read the FAQs (see below) before enrollment or click here.
Single License
Small Team (5 seats)
Department (15 seats)
Organisation (25 seats)
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 Bronze 1 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: Silver 5 (for up to 5 license), Copper 15 (for up to 15 license), or Gold 25 (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.
Subscribe to our newsletter
Get notified of new products and promotions directly to your inbox.
About us
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.
