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?

 

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