Excel MBA Day 3

The best formula for career success and the best Excel Formulas!

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

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'