Go from spreadsheet zero to confident
Learn Excel or Google Sheets the reliable way: clean tables, formulas you understand, summaries that update and charts that tell the truth.
- Build clean tables that pivot tables, formulas and charts handle easily
- Master the functions that matter: XLOOKUP, IF, SUMIFS, COUNTIFS, FILTER
- Make spreadsheets you can trust, with checks that catch mistakes
- 20 exercises with model answers on one realistic practice dataset
Spreadsheets From Zero to Confident · Bodhih Digital Skills · 02 by Bodhih Training, trainers to 2,000+ companies since 2008.
How do I learn spreadsheets from scratch?
Start with well-structured tables (one row per record, clear headers), then learn formulas with references, absolute references, IF, XLOOKUP and SUMIFS, then pivot tables and charts. Practise on one realistic dataset and add check cells so you can trust your results. Spreadsheets from Zero to Confident follows exactly this path, in Excel or Google Sheets.
You already know the problem. Here is what it costs you.
Copying and pasting every month
Reports take hours because nothing updates by itself.
Formulas you're afraid to touch
You inherited a sheet and don't know what will break.
Errors you can't see
Totals look right until someone spots a mistake in a meeting.
Lost in features
Tutorials jump around and never join up into real work.
Picture yourself a few weeks from now.
Imagine opening next month's report and simply pressing Refresh.
As your tables get cleaner, notice how each formula becomes shorter and easier to read.
You'll find yourself reading other people's spreadsheets and seeing exactly how they work.
Picture sharing a dashboard with your manager, knowing every number has a check behind it.
Chapter by chapter
Every chapter starts with a real situation, gives you a method, and ends with something to do today.
- Format
- Licensed PDF e-book, stamped with your name
- Length
- 16 chapters and 5 appendices
- Reading time
- About 5 hours, plus practice
- Includes
- 100+ function reference, 17 shortcuts, 8 templates, 11 charts, 20 exercises
- Level
- Beginner to confident intermediate
- Edition
- First edition, reviewed November 2026
Why Spreadsheets Still Matter
Where spreadsheets shine, where they don't, career value and why small error rates add up.
Finding Your Way Around
Cells, sheets and workbooks, moving and selecting fast, settings and help.
Entering and Formatting Data Well
Golden rules of structure, data types, dates, number formats and cleaning.
Your First Formulas
Operators, order of calculation, essential functions, percentages and rounding.
Relative and Absolute References
$ signs, mixed references, named ranges and references across sheets.
Sorting, Filtering and Tables
Safe sorting, filters, tables, slicers and removing duplicates.
Logical Functions
IF, AND, OR, IFS, SWITCH and handling errors, built from plain sentences.
Lookups
XLOOKUP, VLOOKUP, INDEX/MATCH, bands and two-condition lookups.
Text and Date Functions
Cleaning text, Flash Fill, how dates work, working days and times.
Counting and Summing with Conditions
COUNTIFS, SUMIFS, AVERAGEIFS, criteria tips and summary grids.
Pivot Tables
Build, group, show percentages and refresh pivot tables with a routine.
Charts That Tell the Truth
Message titles, choosing chart types, avoiding misleading charts, dashboards.
Conditional Formatting and Data Validation
Highlight what matters and stop bad data at the door with dropdowns and rules.
Building Reliable Spreadsheets
Inputs, calculations and outputs, checks, testing, review and versions.
Collaboration, Sharing and Protection
One shared file, permissions, protected ranges and sensitive data.
AI and Automation in Spreadsheets
Copilot and Gemini, prompting for formulas, dynamic arrays, LET, LAMBDA and automation.
Not just reading. Tools you will actually use.
Foundations
- Golden rules of data structure
- Formulas and references
- Tables and structured references
- Percentages and rounding
Analysis
- IF, IFS and error handling
- XLOOKUP and INDEX/MATCH
- SUMIFS and COUNTIFS
- Pivot tables and charts
Work smarter
- Validation and conditional formatting
- Checks and review checklist
- Sharing and protection
- AI assistants and dynamic arrays
When you finish, you will be able to…
Every outcome is practised in the book through worked examples and a short exercise.
- Structure data so it is easy to analyse
- Write formulas that copy correctly every time
- Look up values from other tables reliably
- Summarise data with SUMIFS and pivot tables
- Create clear, honest charts with message titles
- Prevent errors with validation and check cells
- Share and protect files for team use
- Use AI help safely and test what it suggests
A taste of Chapter 7
Before writing a complex IF, write the rule as a sentence. Then translate it piece by piece: each condition becomes a comparison, and joins such as "and" and "or" become AND and OR. Built from the sentence, each part is simple. Test it with one row for every case.
The honest comparison
| Typical advice | This book | |
|---|---|---|
| Programs | One program only | Excel and Google Sheets side by side |
| Practice | Scattered examples | One realistic dataset, 20 exercises |
| Reliability | Not covered | Checks, testing and review checklists |
| AI | Ignored or hyped | Copilot, Gemini and a safe testing routine |
| Functions | Older methods | XLOOKUP, FILTER, UNIQUE, LET for 2026 |
Made for you if…
- Complete beginners
- Self-taught users with gaps
- Office, HR and admin staff
- Small business owners
- Teachers and charity workers
- Job seekers adding a key skill
Probably not for you if…
- Experienced financial modellers
- Readers wanting VBA or programming tutorials
- Anyone needing accounting or tax advice
Written by trainers, tested in real rooms.
Bodhih Training has designed and delivered corporate programmes since 2008 for leadership teams, new managers, sales and service teams, and whole organisations. The Bodhih Professional Playbooks distil what works in those workshops into books you can use on a Tuesday morning, without a facilitator in the room.
Reading in two minutes from now
- STEP 1
Tap Buy now
Name, email and country. Pay by UPI, card or netbanking (India) or international card. No account to create.
- STEP 2
Download instantly
Your download page opens at once, and a permanent link lands in your inbox.
- STEP 3
Start with Chapter 1
Read on your phone tonight, or on your commute tomorrow. Do the first "Do this today" exercise and notice the difference.
Build a sheet you can trust
Download the book, convert one of your own ranges into a table today and add a single check cell. You'll feel the difference by the end of the week.
Licensed PDF: single-user licence stamped with the buyer's name. Team and organisation licences with volume discounts at checkout, or write to solutions@bodhih.com.
Keep growing with the Bodhih family
Applied AI certification pathways
Certification pathways in applied AI, workplace English and management, with SCORM courses and assessed capstones.
More Bodhih e-books
Practical, research-backed e-books for work and life, updated every six months.
Bodhih.org
Certification pathways in Applied AI, Workplace English and management.
AssessAll
Measure your skills with AI-graded assessments and verified credentials.
Jobulary
Turn what you learn into an individual development plan that stays yours.
Pewple
Book a vetted coach for career, leadership or communication. Pay per session.
Bodhih Training
Run this book as a workshop for your team, in person or live online.
What buyers say
No ratings yet. Only people who have bought this e-book can rate it - every buyer gets a one-click rating link a couple of days after their purchase.
How do I learn spreadsheets from scratch?
Begin with clean table structure, then formulas and references, then IF, XLOOKUP and SUMIFS, then pivot tables and charts, practising on one realistic dataset. This book follows that path chapter by chapter, with exercises and model answers.
Does the book cover Excel or Google Sheets?
Both. The ideas are the same, and the book shows where menus, shortcuts or functions differ between current Excel and Google Sheets.
I have never used a spreadsheet. Is this for me?
Yes. Chapter 2 starts with cells, rows and columns, and every later skill builds on the one before.
I already use spreadsheets. Will I learn anything?
Most self-taught users find gaps in references, tables, lookups, SUMIFS, pivot tables and reliability checks. The self-check in Appendix E shows which chapters to focus on.
What is XLOOKUP and should I learn it instead of VLOOKUP?
XLOOKUP finds a value in one column and returns the matching value from another, in any direction, with a clear not-found option. Learn it for new work, and learn to read VLOOKUP because many existing files use it.
Does it cover pivot tables?
Yes. Chapter 11 covers creating, grouping, showing values as percentages, refreshing and checking pivot tables, with a monthly routine.
Does it cover AI tools like Copilot and Gemini?
Yes. Chapter 16 covers prompting for formulas, explaining formulas, a safe testing workflow and what to automate first. Check your organisation's policy before using AI with work data.
Is there practice material?
Yes. Appendix E gives a practice dataset to build, 20 exercises with model answers, a self-check and a 30-day practice plan.
Will this book get me a job?
No book can promise that. Spreadsheet skills are widely requested in job postings, and the book helps you build and explain small examples of your work.
Is there VBA or programming?
No. The book focuses on formulas, tables, pivot tables, charts and built-in automation. It mentions macros and scripts so you know when they help.
Can I buy it for my team?
Yes. Team and organisation licences with volume discounts are available at checkout, or write to solutions@bodhih.com.
How much does Spreadsheets From Zero to Confident cost?
₹799 including 18% GST for buyers in India, or $19.99 for buyers outside India. One-time payment, no subscription, with an automatic invoice.
How do I get the e-book after paying?
Instantly. Your download page opens the moment payment succeeds, and a permanent download link is emailed to you. The PDF works on phones, tablets, Kindle (via Send to Kindle), laptops and in print.
Can I get a refund?
Because it is a digital download, e-books 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 copies for a team?
Yes. Team and company licences, and workshops based on the book run by Bodhih Training, are available. Write to solutions@bodhih.com or call +91 99000 11601.





