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

Computer and office skills15 books

MS Excel Study Book

The complete study notes, practice questions and glossary for MS Excel

  • Study book
  • Beginner to intermediate
  • 29 pages
  • 129 KB
  • PDF, English
Download free PDFRead online

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

About this ebook

What you will learn

Work with cells, ranges and formulas in Microsoft Excel, use functions such as SUM, IF, VLOOKUP and XLOOKUP, and sort, filter, chart and print your data.

Who it is for

Students, shopkeepers and office staff who keep records and lists.

Contents

  1. Getting Started with Excel
  2. Formatting Cells and Worksheets
  3. Formulas and Basic Functions
  4. Relative, Absolute and Mixed References
  5. Decisions and Lookups: IF, VLOOKUP and XLOOKUP
  6. Sorting and Filtering Data
  7. Charts and Printing

At the end of the book

  • Practice questionsTo check what you have learnt.
  • 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