Our Blog2019-08-23T22:33:20+00:00

I haven’t made a Excel million blogs on this site but the one’s on here are some of the most comprehensive blogs you will find on what I deem to be key Excel topics to focus on. When I say they are comprehensive, we are talking thousands of words, they could be books in their own right. This is content that needs commitment from you and your ever distracted attention span.

It will be worth it.

Pivot Table Excel (The 2019 Tutorial)

Want to organize your data set and make sense out of it? Don’t want to spend thousands of dollars on data analysis software? Want a simple yet effective way of number crunching? Pivot Table is exactly what you are looking for! What are Pivot Tables? It is one of the most powerful features of MS Excel that enables you to extract helpful conclusions out of seemingly large clutters [...]

Excel Templates (Download For Free)

Top Excel Templates Do you want to use Excel Worksheets to streamline your data and perform analysis? Do you find creating Excel Sheets from scratch to be daunting? Unless you’re a professional with Microsoft Excel, creating a spreadsheet that does exactly what you want, is not easy. We are here to assist. Here, you will find 19 Excel Templates that will save you time and help you get the job done [...]

VBA: Simply The Best Guide To Get Started (2019)

Excel Funtion: VBA Excel VBA: Learn the basics in a few minutes What is VBA? VBA stands for Visual Basic for Applications. It is an implementation of Microsoft’s event-driven programming language Visual Basic which is now used with Microsoft Office applications such as MS Excel, MS Word and MS Access. Introduction to this Excel VBA Tutorial Why do we need to learn VBA? VBA is an [...]

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 [...]

How is VLOOKUP Used to Compare Two Columns in Excel?

Compare Two Columns In Excel Using VLOOKUP Okay, let’s establish the goal. We want to see if one ‘bunch’of data exists within another bunch of data. Now unless you are prepared to spend some time using VBA to do complex scripting, you won’t get a precise result. But that’s okay. Often we just want to confirm if data exists for investigative reasons. It’s not some complex report or analysis we are building, just a [...]