Stop rebuilding reports by hand. Build spreadsheets that answer for you.
Spreadsheet Superpowers is a practical kit for office staff, graduates and managers who use Excel or Google Sheets every week and want to be faster, more accurate and more confident. Read a chapter, practise on realistic data, and use the same tools at work the same day.
- A plain-English e-book covering structure, cleaning, formulas, lookups, pivots, charts, dashboards, collaboration and AI helpers
- A Practice Workbook with 200 rows of realistic sales data and 20 exercises that mark themselves
- A Ready-made Dashboard Template you can fill with your own data in an afternoon
- A fillable Formula Finder, four cheat sheets, an AI prompt library and a 20-session calendar plan
Spreadsheet Superpowers · Bodhih Pro Kits · 13 by Bodhih Training, trainers to 2,000+ companies since 2008.
What is the fastest way to learn Excel and Google Sheets for work?
Learn the fifteen or so functions that cover most office tasks (SUMIFS, COUNTIFS, IF, XLOOKUP, TEXT and date functions), lay data out as a tidy table, and practise on realistic data in short sessions. Spreadsheet Superpowers by Bodhih Training packages this into an e-book, self-marking practice workbook and ready-to-use templates.
Want the full free guide first? Read Which Excel and Google Sheets Formulas Do You Need for Work?.
You already feel the problem. Here is what it is costing you.
The Friday report that eats your afternoon
You filter, copy, paste and retype the same summary every week. One late change from your manager and you start again. It is not hard work, it is repeat work, and a few formulas could do it for you.
Numbers you are not quite sure about
A total looks a little low, a lookup returns #N/A for customers who definitely exist, and you are never sure whether the sheet included the last few rows. That doubt follows every number you send.
Learning from scattered videos
You have watched tutorials on VLOOKUP and pivot tables, but on your own data nothing quite works. Without realistic practice and instant feedback, the skills do not stick.
Shared files that drift into chaos
Five versions of the same tracker, a Status column full of creative spellings, formulas typed over with numbers. The spreadsheet is fine; the habits around it are not.
Picture the next few weeks with the kit open beside you.
Imagine Monday morning. You open the export from your system, paste it into the Data sheet of a workbook you built last month, and glance at a single check cell that tells you the row count matches. The dashboard has already updated. You read it, write two sentences about what changed, and send it before your coffee is cold.
Now imagine your manager asks a follow-up question in the meeting: what about just the West region, only for Furniture, since June? Instead of promising to get back to them, you change two drop-downs and read out the answer. As you start to work this way, people begin to notice that your numbers are fast and, more importantly, right.
That is what this kit is designed to build. As you read each chapter, you open the Practice Workbook and try the matching exercises, and the Check column turns green when you get them right. When you are stuck, the Formula Finder takes you from a plain-English question to the right function, and the cheat sheets sit beside your keyboard.
Whether you start with the Practice Workbook tonight or the Dashboard Template tomorrow, you will notice the difference within a week: fewer manual steps, fewer doubts, and more time for the question behind the numbers.
12 files that do the work for you
The e-book shows you how. The tools make it happen. Here is exactly what you download.
Spreadsheet Superpowers (e-book, PDF)
The guide: methods, worked examples, scripts and exercises
Spreadsheet Practice Workbook
200 rows of realistic sales data with 20 graded exercises, live answers, lookup, clean-up and pivot-check practice sheets.
Ready-made Dashboard Template
Paste your own rows into the Data sheet and three dashboard tabs update: headline KPIs, revenue by region, monthly trend and pipeline mix.
Formula Finder (fillable decision guide)
Turn a plain-English question into the right formula in five minutes: tick your route, write your criteria, test the answer.
Top 60 formulas (Excel and Google Sheets)
The 60 functions that cover almost all everyday work, each with a one-line purpose and a ready example, plus version notes.
Keyboard shortcuts (Windows and Mac)
The Excel and Google Sheets shortcuts worth learning first, side by side for Windows and Mac.
Pivot table in 6 steps
Build, tidy and check a pivot table in Excel or Google Sheets, with five power moves and fixes for common problems.
Formula error fixer
Every error code decoded with causes and fixes, plus the silent problems (text-numbers, missing $ signs) that do more damage.
Spreadsheet Handover and Documentation Template
Document any important workbook in 30 minutes so a colleague can run it when you are on leave: purpose, sheet map, sources, key formulas, refresh steps and change log.
AI Spreadsheet Prompt Library
17 copy-and-adapt prompts for ChatGPT, Gemini, Claude, Copilot or your company's approved assistant: write, explain, fix and convert formulas, clean data, choose charts, plus a five-point verification routine.
20-session practice plan (calendar)
Twenty 25-minute weekday practice sessions over four weeks, each linked to a chapter and a sheet in your kit. Import into Google Calendar, Outlook or Apple Calendar.
Messy orders CSV (clean-up practice)
75 deliberately messy web orders: extra spaces, mixed case, three date formats, text amounts, blanks and five duplicates. Practise Chapter 2 on it.
Chapter by chapter
Each chapter opens with a real situation, gives you a method and ends with something to do today, using the tools in your kit.
- Format
- PDF e-book + XLSX + fillable PDF + PDF cheat sheets + DOCX + ICS + CSV
- Files
- 12 files plus a one-click ZIP
- E-book
- 46 pages
- Works with
- Excel (Microsoft 365, 2021, 2019, 2016 with noted alternatives), Google Sheets, Word, Google Docs, Acrobat, any calendar app
- Best for
- Office staff, graduates, managers and coordinators who use spreadsheets every week
- Level
- Beginner to confident intermediate
The Spreadsheet That Ate Friday
Why the same request takes one person a whole afternoon and another eleven minutes, and how to use this kit.
Build It Right From Row One
Six rules for tidy tables, the three-zone workbook and why Tables beat plain ranges.
Clean Data Before You Trust It
Spot and fix spaces, capitals, text-numbers, text-dates and duplicates with formulas and menus.
The Formula Foundations
SUM to MAX, the $ sign and F4, IF, IFS, AND, OR and when to use IFERROR.
Counting and Adding With Conditions
COUNTIFS, SUMIFS, AVERAGEIFS and MAXIFS, with every criteria pattern you need.
Taming Text and Dates
LEFT, MID, FIND, TEXTJOIN, TEXT, EOMONTH, NETWORKDAYS and DATEDIF in practical examples.
Lookups That Don't Break
XLOOKUP, VLOOKUP and INDEX MATCH compared, and the four reasons lookups return #N/A.
Pivot Tables: Answers in Minutes
Six steps to a pivot table in Excel or Sheets, five power moves and the refresh trap.
Charts That Tell a Story
Choosing the right chart, a five-minute clean-up, and conditional formatting as an in-cell chart.
Guard Rails and Simple Dashboards
Data validation, conditional formatting rules, protection and a one-screen dashboard method.
Sharing, AI Helpers and Fixing Errors
Collaboration without version chaos, using AI assistants safely, and a calm debugging routine.
Your Spreadsheet Habits From Monday
The eight habits that separate a fast, trusted spreadsheet user from a busy one.
Excel vs Google Sheets at a Glance
The differences that matter: versions, functions, separators, pivots and limits.
Not just reading. Tools you will actually open again.
E-book
- Spreadsheet Superpowers e-book (PDF): 10 chapters, worked examples, callouts, AI prompts and an Excel vs Google Sheets appendix
Spreadsheets
- Spreadsheet Practice Workbook: 200 sales orders, product list, 20 self-marking exercises, live answers sheet, lookup, clean-up and pivot-check practice, and a dashboard
- Ready-made Dashboard Template: data sheet with drop-downs, monthly targets, KPI tiles, region, trend and pipeline charts
- Messy orders CSV: 75 deliberately messy records for clean-up practice
Fillable PDF
- Formula Finder: a four-page decision guide from plain-English question to tested formula
Cheat sheets
- Top 60 formulas (Excel and Google Sheets) with examples and version notes
- Keyboard shortcuts for Excel and Google Sheets, Windows and Mac
- Pivot table in 6 steps for Excel and Google Sheets
- Formula error fixer: every error code plus the silent problems
Word templates
- Spreadsheet Handover and Documentation Template
- AI Spreadsheet Prompt Library: 17 prompts plus a five-point verification routine
Calendar
- 20-session practice plan: 25-minute weekday sessions over four weeks, for Google Calendar, Outlook or Apple Calendar
When you have worked through it, you will be able to…
Every outcome is practised with a worked example and a tool, not just described.
- You will be able to turn a messy export into a clean, tidy table in minutes
- You will be able to answer 'how many' and 'how much' questions with COUNTIFS and SUMIFS instead of filtering by hand
- You will be able to fetch data between tables with XLOOKUP, VLOOKUP or INDEX MATCH and fix #N/A errors
- You will be able to summarise thousands of rows with a pivot table and check the result
- You will be able to build a chart whose title states the message and whose design supports it
- You will be able to protect shared sheets with drop-downs, rules and locked formulas
- You will be able to assemble a simple dashboard that updates when new data arrives
- You will be able to use AI assistants to write and explain formulas, and verify what they produce
Know your starting point. Prove your progress.
People who measure before and after improve faster and can show it. AssessAll, our sister assessment platform, has AI-graded assessments that pair with this kit. Take one now, work through the kit, then re-take it.
Spreadsheet & Data Literacy
Take the assessment →AssessAll assessmentData Interpretation — Tables & Charts
Take the assessment →AssessAll assessmentData Dashboard Reads — Interactive
Take the assessment →JobularyAdd data skills to your development plan (Jobulary)
Make it a growth plan →A taste of Chapter 6
Chloe in Melbourne has two files: this month's orders, with product codes, and a price list maintained by the finance team. She needs the current price next to every order. Her predecessor did it by copying and pasting, which went fine until finance changed fourteen prices and nobody noticed for a month. A lookup formula would have picked up the change automatically. A lookup takes a value you have (a product code, an employee ID, an email address), finds it in another table, and brings back something from the same row. It is the spreadsheet version of looking someone up in a phone book. Every lookup needs three things, and it helps to say them out loud before you type: what am I looking for, where do I look for it, and what do I want back?
The honest comparison
| Free templates and typical advice | This kit | |
|---|---|---|
| Practice data | Tiny made-up tables or none at all | 200 realistic orders with 20 exercises that mark themselves and live answers |
| Excel and Google Sheets | Usually one or the other | Both, with differences and version requirements spelled out |
| Ready to use at work | Theory, then you build from scratch | Dashboard template, handover template and formula finder you can use the same day |
| Errors and checking | Rarely covered | A calm debugging routine, an error fixer sheet and 'check one number by hand' built into every chapter |
| AI helpers | Either ignored or oversold | 17 practical prompts plus a verification checklist and data-privacy reminders |
| Making it stick | Read once and forget | A 20-session calendar plan with each session linked to a sheet in the kit |
Made for you if…
- Office and operations staff who live in spreadsheets but learned them by trial and error
- Graduates and early-career professionals who want job-ready Excel and Google Sheets skills
- Team leaders and managers who build trackers, budgets and weekly reports
- HR, finance, sales and training coordinators who answer 'how many' and 'how much' questions every month
- Anyone moving between Excel and Google Sheets who wants one guide for both
- Trainers and L&D teams looking for ready practice material (with a team licence)
Probably not for you if…
- Data analysts who already use Power Query, SQL or Python daily
- People looking for VBA, macros or advanced financial modelling
- Anyone who wants a video course rather than a book and hands-on files
Built by trainers, tested in real rooms.
Bodhih Training has designed and delivered corporate programmes since 2008. Bodhih Pro Kits package what works in those workshops into a guide plus the exact tools we use, so you can apply it the same day without a facilitator in the room.
From here to using it in three steps
- STEP 1
Tap Get the kit
Name, email and country. UPI, card or netbanking in India; international cards everywhere else. No account to create.
- STEP 2
Download instantly
Your download page opens at once, with every file and a one-click ZIP. A permanent link lands in your inbox too.
- STEP 3
Open the first tool
Start with the quick-start chapter, then the main spreadsheet or planner. Most buyers use something from the kit the same day.
Your next report could take eleven minutes
Download the kit, open the Practice Workbook and try the first three exercises: each takes about two minutes. Whether you start with the e-book tonight or drop your own data into the Dashboard Template tomorrow, you will feel the difference by the end of the week.
Personal licence for the buyer's own use (and use with your own team or clients where the kit says so). Please don't share or resell the files. Team and company licences: solutions@bodhih.com.
Practise it in a simulation
Reading builds the idea. Deciding under pressure, and seeing what happens, makes it stick.
What buyers say
No ratings yet. Only people who have bought this kit can rate it - every buyer gets a one-click rating link a couple of days after their purchase.
The Bodhih family, when you are ready for more
AI at Work, Done Right (e-book)
Prompts, workflows and guardrails for every professional.
Applied AI pathways
Role-based Applied AI certifications.
AssessAll
250+ AI-graded assessments to measure skills and earn verified credentials.
Jobulary
Individual development plans that start from evidence and stay yours.
Bodhih Training
Run this topic as a live workshop for your team, in person or online.
Pewple
Book a vetted coach for career, leadership or communication. Pay per session.
Bodhih.org pathways
Certification pathways in Applied AI, Workplace English and management.
Does this kit work for both Excel and Google Sheets?
Yes. Every formula is shown for both, and the book flags where they differ. The workbooks open in Excel and in Google Sheets. A few modern functions such as XLOOKUP need Microsoft 365, Excel 2021 or Google Sheets, and the kit always gives an alternative for Excel 2016 and 2019.
I am a complete beginner. Is this too advanced?
If you can open a spreadsheet and type into a cell, you can start. Chapter 3 begins with what a formula is, and the exercises build up gradually. Confident users usually skim the early chapters and go straight to lookups, pivots and dashboards.
Which Excel formulas should I know for a job?
For most office roles: SUM, AVERAGE, COUNTA, IF, IFS, COUNTIFS, SUMIFS, XLOOKUP or VLOOKUP, INDEX with MATCH, TRIM, TEXT and a few date functions such as EOMONTH and NETWORKDAYS, plus the ability to build a pivot table. The Top 60 formulas cheat sheet lists them all with examples.
How do I fix #N/A in VLOOKUP or XLOOKUP?
Usually the key does not match exactly: extra spaces, a number stored as text, or a value genuinely missing from the lookup table. Clean both sides with TRIM and VALUE, and use XLOOKUP's 'not found' argument so missing values are visible. Chapter 6 and the Formula error fixer walk you through it.
How long does it take to see results?
Most people use something from the kit at work within the first week, often the SUMIFS chapter or the dashboard template. The 20-session plan takes about 25 minutes a weekday over four weeks. How fast you progress depends on how often you practise.
Can I use AI to write my formulas instead?
AI assistants are genuinely useful for writing and explaining formulas, and the kit includes 17 prompts for exactly that. They can also be confidently wrong, so the book teaches you enough to check their output and includes a five-point verification routine. Always follow your company's policy on sharing data with AI tools.
How can I measure my starting point?
Bodhih's sister platform AssessAll offers the Spreadsheet & Data Literacy, Data Interpretation (Tables & Charts) and Data Dashboard Reads (Interactive) assessments. Taking one before and after the kit gives you a clear picture of your progress.
How do I turn this into a development plan?
Use the 20-session plan as your short-term goal, then add your data skills to an individual development plan on Jobulary so they sit alongside your other career goals and you can discuss them with your manager.
Can I use the kit with my team or in training sessions?
The standard licence is for your personal use. If you want to use the workbooks with a team or in your own training sessions, contact solutions@bodhih.com for a team or company licence.
What if a file does not open?
Digital kits are non-refundable once downloaded, but if a file is corrupted and we cannot fix it within 3 working days, or if you are charged twice or the download fails, contact us and we will put it right.
How much does Spreadsheet Superpowers cost?
₹499 including 18% GST for buyers in India, or $15 for buyers outside India. One-time payment, no subscription, with an automatic invoice.
How do I get the files after paying?
Instantly. Your download page opens the moment payment succeeds, and a permanent download link is emailed to you. Download each file separately or everything in one ZIP.
What software do I need?
Any of the usual tools: Excel or Google Sheets for spreadsheets, Word or Google Docs for templates, Adobe Acrobat Reader, Preview, Xodo or GoodNotes for the fillable PDFs, and Google, Outlook or Apple Calendar for the calendar plan.
Can I get a refund?
Because it is a digital download, kits are not refundable once downloaded. We always refund a duplicate charge or a failed delivery, and if a file is corrupted and we cannot fix it within 3 working days. Full terms: bodhih.org/refunds.
Can my company buy this for a team?
Yes. Team and company licences, and workshops on this topic run by Bodhih Training, are available. Write to solutions@bodhih.com or call +91 99000 11601.






