Our Blog2018-06-24T20:00:35+00:00

Earn and Excel Blog

Are you a Microsoft Excel user? Do you want to become more proficient in your daily use of the program? Well, Earn and Excel is here to help you do just that. We want to help Excel users get the most out of the program in their professional and personal life. Essentially, with any of our online training, courses or classes, you will learn how to use Excel so you can maximize efficiency on the job and automate some recurring processes; all with the goal of getting your work quickly so you have more time to focus on other tasks. On this blog, we will give you a few tips on how to use some basic Excel functions and other advanced functions and features.

Pivot Table

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