In this article of Google Sheets – Sum Average Minimum & Maximum, we will discuss how to find sum and average from a given set of data, and we will also show you how to find the smallest and the largest number from the same set of data. By the end of this tutorial, you […]
Google Docs Spreadsheet – Overview Getting started with Google sheets Spreadsheet video demonstration helps you to get a quick introduction about Google Spreadsheet. With the help of this video demonstration, you should get familiar with how to start a Google docs spreadsheet and the workspace of Google sheet. By the end of this google sheets […]
VLookup for Multiple Sheets with Example – Overview How To VLookup in Multiple Tables in excel is a video demonstration of performing VLookup for values in more than one data range or a table. VLookup helps you to lookup for values in a single data range or a table. However, using vLookup with the IFERROR […]
How to use vlookup How to vlookup in a different workbook in Excel is a video demonstration that will help you to understand how to use excel vlookup to look for values from a different workbook or outside the current work. By the end of this video, you should be familiar with how set we […]
In this article, we will cover VLookup. To follow along with us make sure you have a copy of this file downloaded using the button below. There are three worksheets, “See it”, “Do it”, and “Data”. “See it” is where I will demonstrate, “Do it” is where you will practice, and “Data” is where our […]
Overview of Excel Functions Excel count functions or very handy and help you in a great way to deal with their assets when it comes to Counting stuff inside Excel. In this article, we are going to talk about five different count functions of Excel. Types of Count Functions in Excel Excel COUNT Excel COUNTA […]
In this episode of the Excel Learning Series, we are going to talk about the SumIF and SumIFS function in Excel. We also have AverageIF and AverageIFS functions in excel, however, we are not going to talk about that in today’s series but we are confident that you will be able to use them easily […]
