Microsoft Excel 75 Formulae Examples: #75 No Frills Working Formulae Examples

by Diane Griffiths

Your understanding of formulae and the functions available to you within Excel allow you to design better spreadsheets. You can cleanse data and analyse it in a quicker and more effective way if you know the full extent of the options available to you. Perhaps most importantly, formulae help you to get home on time! You can work faster and more efficiently – now that’s something I’m interested in!

This ebook will power through 75 examples of really useful functions and formulae which you can put to the test straightaway; this is for someone who has a fair idea of how Excel handles calculations and wants some top formulae in order to super-charge their spreadsheets.There are no frills in this ebook – I just give you 75 examples; the formula, how it works and an example of it in action. I’ve provided a FREE workbook so you can take test them out within Excel.

Formulae
- Statistical Functions
- Running Totals
- 3D Formulae
- Create Email Address with Name and Domain
- IFs and Nested IFs
- Conditional Formatting IFs
- COUNT, COUNTIF, COUNTIFS
- SUM, SUMIF, SUMIFS
- CONCATENATE formulae
- VLOOKUP formulae
- INDEX/MATCH
- Date formulae

Is this ebook right for you? Take a glimpse inside the first few pages - if you like what you see, then go ahead and buy!

134 pages, Kindle Edition

First published February 14, 2015