PDF eBook102 pagesAbout 5 hours, plus practice

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.

Quick answer

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.

Sound familiar?

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.

Now imagine this

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.

Inside the book

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
  1. Why Spreadsheets Still Matter

    Where spreadsheets shine, where they don't, career value and why small error rates add up.

  2. Finding Your Way Around

    Cells, sheets and workbooks, moving and selecting fast, settings and help.

  3. Entering and Formatting Data Well

    Golden rules of structure, data types, dates, number formats and cleaning.

  4. Your First Formulas

    Operators, order of calculation, essential functions, percentages and rounding.

  5. Relative and Absolute References

    $ signs, mixed references, named ranges and references across sheets.

  6. Sorting, Filtering and Tables

    Safe sorting, filters, tables, slicers and removing duplicates.

  7. Logical Functions

    IF, AND, OR, IFS, SWITCH and handling errors, built from plain sentences.

  8. Lookups

    XLOOKUP, VLOOKUP, INDEX/MATCH, bands and two-condition lookups.

  9. Text and Date Functions

    Cleaning text, Flash Fill, how dates work, working days and times.

  10. Counting and Summing with Conditions

    COUNTIFS, SUMIFS, AVERAGEIFS, criteria tips and summary grids.

  11. Pivot Tables

    Build, group, show percentages and refresh pivot tables with a routine.

  12. Charts That Tell the Truth

    Message titles, choosing chart types, avoiding misleading charts, dashboards.

  13. Conditional Formatting and Data Validation

    Highlight what matters and stop bad data at the door with dropdowns and rules.

  14. Building Reliable Spreadsheets

    Inputs, calculations and outputs, checks, testing, review and versions.

  15. Collaboration, Sharing and Protection

    One shared file, permissions, protected ranges and sensitive data.

  16. AI and Automation in Spreadsheets

    Copilot and Gemini, prompting for formulas, dynamic arrays, LET, LAMBDA and automation.

What you get

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
Outcomes

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
Read a page

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.

From Spreadsheets From Zero to Confident, Bodhih Training
Why this book

The honest comparison

Typical adviceThis book
ProgramsOne program onlyExcel and Google Sheets side by side
PracticeScattered examplesOne realistic dataset, 20 exercises
ReliabilityNot coveredChecks, testing and review checklists
AIIgnored or hypedCopilot, Gemini and a safe testing routine
FunctionsOlder methodsXLOOKUP, FILTER, UNIQUE, LET for 2026
Who it’s for

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
Being honest

Probably not for you if…

  • Experienced financial modellers
  • Readers wanting VBA or programming tutorials
  • Anyone needing accounting or tax advice
Why Bodhih

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.

2008Training organisations since
2,000+Companies served
200,000+Professionals trained
18,000+Programmes delivered
How it works

Reading in two minutes from now

  1. STEP 1

    Tap Buy now

    Name, email and country. Pay by UPI, card or netbanking (India) or international card. No account to create.

  2. STEP 2

    Download instantly

    Your download page opens at once, and a permanent link lands in your inbox.

  3. 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.

Ready when you are

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.

$19.99one-time payment

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.

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.

Questions readers ask

Spreadsheets From Zero to Confident: FAQs

Already bought? Resend my link

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.

$19.99