Excel & Google Sheets Mastery

Formulas, pivot tables, dashboards

🎓 Beginner to intermediate⏱ 10 hours of content📄 PDF workbook🎥 Video lessons📱 Phone / laptop

Become the person at work who 'just knows Excel'. This course covers 60+ essential formulas (VLOOKUP, INDEX-MATCH, XLOOKUP, SUMIFS, dynamic arrays), pivot tables from raw data to executive dashboards, and macros for automating repetitive work. Works identically in Excel and Google Sheets.

What's inside this pack

✓100-page PDF reference guide
✓8 hours of video lessons
✓60+ formula cheat-sheet
✓20 practice workbooks
✓3 dashboard templates
✓Bonus: Excel keyboard shortcut poster

Sample lessons — read before you buy

3 previews

1Lesson 1 — VLOOKUP vs XLOOKUP

VLOOKUP looks up a value in the LEFTMOST column of a table and returns a value from a column to the right: =VLOOKUP(A2, Table, 3, FALSE). Two big limits: it can't look to the left, and adding a column breaks it. XLOOKUP (Excel 365 / Sheets) fixes both: =XLOOKUP(A2, Table[Name], Table[Salary], 'Not found'). If you have XLOOKUP, use it — VLOOKUP is now legacy.

2Lesson 2 — Pivot Tables in 3 Minutes

Select your data → Insert → Pivot Table. Drag fields: (1) Rows = the category you want to break down (e.g. Region), (2) Values = the number you want to summarise (e.g. Sales) — Excel defaults to SUM, right-click to change to AVERAGE, COUNT, etc. That is 90% of every management dashboard ever built. Pivot tables refresh with one click when new data arrives — never re-build them by hand.

3Lesson 3 — IF, IFS and Nested Conditions

=IF(B2>=80, 'Distinction', IF(B2>=50, 'Pass', 'Fail')) works but is hard to read. Modern equivalent: =IFS(B2>=80, 'Distinction', B2>=50, 'Pass', TRUE, 'Fail') IFS evaluates conditions in order and returns the first match. The final TRUE acts as the 'else' branch. Use IFS whenever you have 3 or more categories.

⚡

Instant delivery

Email arrives in under 2 minutes after Paystack confirms your payment.

🔒

Secure checkout

Card details never touch our servers — processed by Paystack under PCI-DSS.

💰

7-day guarantee

Not happy? Full refund within 7 days on unopened material.

What buyers of this pack say

✓ Verified purchases

Frequently asked

›How do I get the study pack after paying?

Instantly by email. The moment Paystack confirms your payment we send a secure link to every file in the pack. Delivery is usually under 2 minutes.

›Can I open it on my phone?

Yes. All PDFs, past papers, memos and video lessons work on phone, tablet or laptop. No app needed.

›What if I don't like it?

You have a 7-day money-back guarantee. See our Refund Policy for details.

›Is this the current CAPS syllabus?

Yes — every pack is aligned with the latest DBE / IEB CAPS curriculum and updated each academic year.

›Can I share it with a friend?

The pack is licensed for your own personal study only. Sharing violates the Terms and can revoke your access.

Before you buy — our policies

Every purchase on StudyHub SA is covered by clear, South African consumer-law compliant policies. Please read them before completing checkout.

📜

Your rights, our rights, acceptable use of the study material.

💰

Refund Policy

7-day money-back guarantee on unopened material.

🔒

How we handle your data under POPIA.

📩

Delivery Policy

Digital delivery timelines and re-send process.

By completing checkout you confirm you've read and accept the Terms of Service and Refund Policy.