Head office, Rana Pratap Bagh, Delhi011 2721 1512+91 97116 99511

Computer and office skills15 books

Excel Formulas Workbook

Sixty formulas and functions, each with a worked example from school, shop or office

  • Free ebook
  • Beginner to intermediate
  • 27 pages
  • 128 KB
  • PDF, English
Download free PDFRead online

Free to download, read, print and share. Not for sale.

About this ebook

What you will learn

Sixty Excel formulas and functions explained one at a time, each with a small data table and its result, from simple sums to IF, SUMIFS, text and date functions, VLOOKUP and XLOOKUP. Three complete projects (a marksheet, a shop bill and a salary sheet) and a chapter on fixing common errors help you use them in real work.

Who it is for

Students, shop owners and office staff who use Excel.

Contents

  1. Formula basics and operators
  2. Cell references: relative, absolute and mixed
  3. Totals, averages and counts
  4. Counting and adding with conditions
  5. Making decisions with IF
  6. Rounding and whole numbers
  7. Working with text
  8. Working with dates
  9. Looking up values
  10. Three projects: marksheet, shop bill and salary sheet
  11. Fixing common errors

At the end of the book

  • Practice questionsTo check what you have learnt, with the answers after them.
  • GlossaryThe key words of the book, each explained in one sentence.
  • Easy EnglishShort sentences and everyday words, with each new word explained the first time.

Reading, printing and sharing

  1. On a phone or computerTap Read online to open the book in your browser, or Download to keep it and read it without the internet.
  2. To printThe pages are A5, half the size of A4. Choose two pages per sheet in the print settings to fit two pages on each A4 sheet.
  3. To shareSend the link to this page, or the PDF itself, to friends, classmates or students. The book is free for everyone.

Courses

Courses this book supports

Students of these courses also find the book in the student portal, with the other ebooks for their course.

More from this family

All 15 books in Computer and office skills

The library

100 free ebooks in 8 families

Browse the whole library
WhatsApp us