Here's what I'll be covering in this Lesson!

- VIDEO LESSON: How to manage your career in the 21st century

- The 11 Most Important Excel Formulas you'll need. These will get 80% of your work done.

The 11 Most Important Excel Formulas there are (these will get 80% of your work done)

Now, you may or may not have read my book 'The only 27 Formulas a professional needs to know' (if you haven't you can download from below) but what I have done to make things even more focused for you is to list the 11 most important ones from this list, so make a note and focus on these one's more.

Now you might be working through this list and thinking, "thanks for a list, what am I supposed to do with it?" Well, on Day 5 I am going to cover most of these formulas in a lot of depth within the context of your work, so I strongly encourage you to wait till then.

Building Logic

IF: Get an outcome based on a logic test

CHOOSE: Select a specific value from a list of values

IFERROR: Returns a specified value if error otherwise returns value of formula that has been input

Finding Information

VLOOKUP: Looks in the first column of an array and moves across the row to return the value of a cell

INDEX: Uses an index to choose a value from a reference or array

MATCH: Looks up values in a reference or array

Deal with Text

LEFT: Returns the leftmost characters from a text value

RIGHT: Returns the rightmost characters from a text value

LEN: Returns the number of characters in a text string

Summarise

COUNITFS: Counts the number of nonblank cells within a range that meet the given criteria

SUMIFS: Sums a bunch of cells specified by a given criteria

### See you tomorrow for Day 4 - 'Why real Excel experts earn less than fake Excel experts'