#75 No Frills Working Formulae Examples
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 gives you 75 examples of Excel formulae in action. There are no frills in this ebook – I just want to give you 75 examples; the formula, how it works and an example of it in action. While I explain how the functions work I don’t go into a huge amount of depth of the Excel workings behind the functions, which is why I’ve provided a workbook so you can take a closer look within Excel.
This ebook will power through some 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.
Quick start - This is a section for short sharp but useful functions. All formulae in this section are straight-forward. Look out for the bonus 'Running Total' and '3D formulae' which allow you to use a basic function in a smart way.
Data Manipulation - If you have data that you need to organise, then these functions are for you. They allow you to join cells together or pull them apart depending on various criteria. This may not seem like the most exciting section, but these functions provide a fundamental grounding for the data analysis formulae coming up.
IF - The IF function is a really useful one. When used in conjunction with other functions and calculations you can really do a lot. I'll give you a few examples of how in this section.
Counting and summing - This sounds very mathematical, but using functions around counting and summing give you very powerful ways to summarise and present your data around different criteria.
Lookups - It's bread and butter time. One of my favourite and most used functions within Excel is the VLOOKUP. We'll go through how that works and how you can use it with other functions and calculations. I'll also show you other functions you can use in order to do similar things.
Dates - Dates are an important part of most Excel spreadsheets. It's often very important to know when something happened and to be able to use that date to calculate other things. I'll show you the most useful date functions in this section.
I have provided a workbook with this ebook to allow you to test out each of the examples as you work through. I highly recommend that you download the empty workbook without formulae first. Give them a try, and only reference the completed workbook if you get stuck.