Master Excel's 11 Logical Formulae
Master Excel's 11 Logical Formulae
Yes, knowing more formulae doesn’t make you better at Excel. The fact is that Excel is a skill, so more knowledge (eg, ‘I know 100 Excel formulae!’) does not make you better, at least not immediately. So why build your Excel formula vocabulary?
FREE DOWNLOAD: EXCEL FORMULA TRAINING TOOL
CLICK HERE TO WATCH THE VIDEO
00:00 Introduction
00:39 Excel Formula Trainer Tool
01:45 F Function
03:00 OR Function
04:20 AND Function
05:13 TRUE Function
06:30 NOT Function
08:10 XOR Function
09:42 SWITCH Function
12:12 IFNA / IFERROR Functions
13:40 IFS Function
15:54 SUMMARY: What to take forward, be wary of and ignore
I think of Excel as a language: as with human languages, the more words you know, the better and more precisely you can express yourself. This applies in Excel at least to some extent. Yes, we know at Tiger you should be a value creator, not a technique collector, but knowing more Excel formulae can help, as part of a balanced learning approach. And, Excel now has more than 500 formulae to learn! With that said, let’s get into Excels’ 11 logical formulae …
Microsoft categorises formulae into 14 themes including ‘Database’, ‘Statistical’ and ‘Lookup and Reference’ (which is where favourites such as VLOOKUP live). The groupings can help your learning: you probably don’t need to know the specialist Engineering formulae, for example, but a command of the main formulae in the main categories is essential.
Excel’s logical formulae allow us to express ‘logical’ relationships and are key to Excel modelling. In this video, I’ll show which of Excel’s logical formulae to take forward, which to be wary of and which you can safely ignore.
First, the IF formula allows you to access a critical programming idea: conditionality. ‘If something is happening, do this; if it isn’t happening, do that’. The first part (‘is this happening?’) is known as a logical test, or a ‘condition’. The video comprises 9 ‘small challenges’ that we tackle using the