Learn Visually: Basic Excel Formulae: Take your spreadsheets and learn some of the key powerful formulae which will allow you to analyse and present your data effectively

by Diane Griffiths

Have you ever looked at an Excel file and not had any clue where to begin? Have you ever had a request to create a report from spreadsheet data and again, not had any clue where to begin?

Have you tried to search for help and but was overwhelmed by the number of Excel eBooks, courses, online articles and forums. You have access to so much information - but where do you start and what is actually useful?!

This particular book takes you right back to formula basics; exactly what a formula is, how to create one and what formulas can do. Then you'll learn about using functions in your formulas, a useful Excel feature which is designed to make your life easier. It will give you the starting blocks that you need in order to present and make sense of a spreadsheet in a quick and easy way that will give your confidence and career a boost.

Formulae include:
- Basic Arithmetic
- SUM
- IF
- AND/OR
- COUNT / COUNTA
- AVERAGE / MAX / MIN
- VLOOKUP / HLOOKUP
- Bonus - Validation

68 pages, Kindle Edition

First published December 18, 2014

Reviews

[MANISH SRIVASTAVA]

Nice short n clear

Basic understanding of formulas are known. Good for basic learner and good to start with .one can practice easily 👍