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