Skip to content
← All ebooks
Excel for Office Work ebook cover
New

Excel for Office Work

The formulas, reports and shortcuts managers actually ask for

DoyinTech · 11 chapters · about 2,600 words · Career · $3.87

Most office jobs in Nigeria list 'proficiency in Microsoft Excel'. This book teaches the part that matters at work: clean data, the 25 formulas you'll use weekly, PivotTables, charts, and the payroll, sales, stock and budget reports managers request. Works for Excel and Google Sheets.

  • ✓ Set up data so formulas don't break
  • ✓ SUMIFS, XLOOKUP, IF, TEXT and date formulas with office examples
  • ✓ PivotTables in five minutes
  • ✓ Ready-made layouts for sales, stock, payroll and budget reports
  • ✓ Charts managers can read at a glance
  • ✓ Shortcuts that save an hour a week

What's inside

  1. 1. Set up data the right way
  2. 2. The everyday formulas
  3. 3. Conditional totals: SUMIFS and COUNTIFS
  4. 4. Lookups: XLOOKUP and VLOOKUP
  5. 5. Dates and text that behave
  6. 6. PivotTables: reports in minutes
  7. 7. Charts and reports managers read
  8. 8. Cleaning messy data
  9. 9. Worked build: a debtors tracker
  10. 10. Fixing errors and checking your work
  11. 11. Office templates and speed

Read a sample

1. Set up data the right way

Most spreadsheet problems start with bad layout. Before any formula, organise your data as a table: one header row, one record per row, one type of information per column, no blank rows in the middle and no merged cells inside the data. Good: columns Date, Invoice No., Customer, Item, Qty, Unit Price, Amount, Paid. Each sale is one row. Bad: a separate sheet per month with totals typed in, customer names spelt three ways, and amounts stored as text with '₦' typed in. Three habits fix most of this. First, convert your range into an Excel Table (Ctrl+T). Tables expand automatically, keep formatting consistent and let you use readable formulas like =SUM(Sales[Amount]). Second, use Data Validation drop-downs for repeated values such as branch, product or staff name, so spelling stays consistent. Third, format numbers with number formats, not by typing symbols: select the column and apply the currency or accounting format with ₦. Practice: take any list you have (sales, stock, contacts) and restructure it into a single table with clear headers. Every chapter after this assumes your data looks like this.

+ 10 more chapters locked

Buy to unlock the full guide on this page.

$3.87

One-time · Instant access after payment

After payment: full chapters unlock on this site and a PDF is emailed to you.

Get it in a bundle and save

One payment unlocks every book in the pack to read online and download as PDF. Pay by card from any country.

Career and Freelance Pack

Get hired, win clients, price your work and get more done with AI.

₦24,000 ₦62,700

What's inside
  • · Excel for Office Work
  • · Land a Remote Job from Nigeria
  • · Your First Paying Web Clients
  • · AI for Small Business
  • · Founder Daily Systems
  • · Virtual Assistant Starter
  • · How to Price Freelance Web Work in Nigeria
  • · Prompt Engineering Playbook
Best value

The Complete DoyinTech Library

Every ebook we publish, now and as new ones are added to the store.

₦49,000 ₦234,700

What's inside
  • · Start and Register a Business in Nigeria
  • · Excel for Office Work
  • · Final Year Project: From Topic to Defence
  • · Land a Remote Job from Nigeria
  • · Bookkeeping for Small Businesses
  • · Grants and Funding for Nigerian SMEs
  • · WhatsApp Business Playbook
  • · Your First Paying Web Clients
  • · Small Business Cyber Basics
  • · Founder Website Launch
  • · AI for Small Business
  • · One-Page Marketing Plan
  • · Cash-First Small Business
  • · Founder Daily Systems
  • · Negotiate & Close
  • · Digital Marketing for SMEs
  • · Affiliate Marketing Starter
  • · Social Media Management Playbook
  • · Virtual Assistant Starter
  • · Instagram & TikTok for Local Services
  • · How to Price Freelance Web Work in Nigeria
  • · Google Business Profile for SMEs
  • · Personal Finance Playbook (Nigeria)
  • · Student Productivity System
  • · Fitness for Busy People
  • · Home Food on a Budget
  • · Culture and Community Advantage
  • · Wealth Habits
  • · Lifelong Learning System
  • · Prompt Engineering Playbook
  • · The Law of Money and Wealth