Excel Formulas Workbook

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.

Chapters

Contents

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

Inside

At the end of the book

• Practice questions. To check what you have learnt, with the answers after them.
• Glossary. The key words of the book, each explained in one sentence.
• Easy English. Short sentences and everyday words, with each new word explained the first time.

How to use it

Reading, printing and sharing

1. On a phone or computer. Tap Read online to open the book in your browser, or Download to keep it and read it without the internet.
2. To print. The 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 share. Send 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.

• ADCA, advanced computer applicationsComputer & Office Skills · About the course
• MS OfficeComputer & Office Skills · About the course
• Tally with GSTAccounting & Business Software · About the course