The Ultimate Guide To VLOOKUP (2019 Edition)

Excel VLOOKUP Function Introduction Now, this is a long guide, which shouldn’t concern you as the VLOOKUP is a big but important subject. Now, if you are the sort of person who prefers video then you can get the concept and introduction from this video. After that, I strongly recommend you keep reading the guide as we get progressively more advanced on route to helping you master this Excel Function! [...]

Excel Formulas Ultimate Guide (2019)

The Excel Formulas Ultimate Guide 2019 Introduction to Excel Formulas In this guide, we are going to cover everything you need to know about Excel Formula. Learning how to create Excel formulas is the building block to the exciting journey to become an Excel Expert. So, let’s get started! What is an Excel Formula? Excel Formulas are often referred to as Excel Functions and it’s no [...]

SUMIF: Ultimate Guide (2019)

Excel SUMIF Function: Ultimate Guide In this guide you are going to learn all about the Excel SUMIF function which is the most important Excel formula there is for summarizing your information (and also SUMIFS which will be tackled later). Now the SUMIF is all about conditional summing, that is we only sum all numbers in a range based on one criterion. Aside from numbers, SUMIF can also add cells based [...]

Excel IF: All You Need To Know (2019 Guide)

Excel IF: The Ultimate Guide Intoduction Let me start by saying that the Excel IF Statement is my favourite Excel Function of all time! It is the purest form of Logic and in order to take our work to the next level we need to be able build logic. What is this Function so important? In brief summary, the Excel’s IF function performs a user instructed logical test, if that [...]

COUNTIF: Master This Amazing Formula (2019 Guide)

Excel Countif Function Introduction to Conditional Counting We all know that Excel has a variety of built-in functions. But did you know that the most used functions in Excel are the functions that count and sum? So today, I am happy to discuss and explain (the best I could!) these functions under the statistical category specifically those used for conditional counting – COUNTIF, COUNTIFS, COUNTBLANK. With these functions solely [...]

Excel Match: How To Master It (2019)

The Excel MATCH function What does it do? In brief summary, the Excel MATCH function looks for a given criteria in a selected range (vertically or horizontally) and returns the row or column number (within that range) where it appears.  The range can be sorted in descending, any or ascending order depending on what match type is used. Syntax explained =MATCH(lookup_value, lookup_array, [match type]) Useful for finding a row reference of an [...]