# Excel Custom Quarters

How to Create Custom Quarters in Excel – Overview Excel custom quarters article aims to demonstrate how to create custom quarters in Excel. If you are planning to calculate regular quarters in Excel, there is a straight forward method that can be found in this article. However, if you are planning to have custom quarters […]

# VLookup for Multiple Sheets with Example

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 vLookup in a different workbook in Excel

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

# How to use VLOOKUP in Excel

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

# How to use Excel Count Functions

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

# Calculate Bonus in Excel Using IF Function

Calculate Bonus in Excel Using IF Function video demonstration will help you to understand how you can use if function to calculate bonus of given set of employees. In this video demonstration, we also covered how we calculated the results using the combination of IF & AND function and IF & OR function which were […]