how to use lookup in excel

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

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

Excel Count Functions

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

SumIF and SumIFS

Excel Learning – SumIF and SumIFS

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

Free Excel Database Download

Free Excel Database for Practice 1.01

Zaha 1.01 – Overview With this article, I aim to provide you with a sample database for excel. You may use this database as per your needs and practice to enhance your Excel skills. About Free Excel Database Download The database contains a list of 100,000 records with fictitious names. We have put together some […]

Calculate Bonus in Excel Using IF Function

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

Excel Logical Functions IF, AND, OR

Excel Logical Functions IF, AND, OR

Excel Logical Functions IF, AND, OR video demonstration will help you with the learning of Microsoft Excel logical functions. In the Excel Logical Functions video demonstration, we will cover how to use IF FUNCTION, how to use OR FUNCTION, and how to use AND FUNCTION. Video Demonstration By the end of this video, you should […]

Excel Pay Rate and Downtime Cost Calculation

Excel Pay Rate and Downtime Cost Calculation

Excel Pay Rate and Downtime Cost Calculation video demonstration will help you to calculate the payment by hour In Excel. In this video demonstration, we have also covered how to calculate the cost of downtime during system outages when you are aware of the cost incurred per minute. We are also briefly covered how to […]

Excel DATEVALUE AND TIMEVALUE

Excel DATEVALUE AND TIMEVALUE

Datevalue and timevalue functions are designed to convert a date that is stored in a text string to a serial number recognized by Excel as a date. The date value is a handy function used in moments where you have data containing dates in a text format. With the help of this function, you would […]

weeknum and isoweeknum funtions

Excel WeekNum and ISOWeekNum Functions

Excel WeekNum and ISOWeekNum Functions. In this video, we will learn about how to use WeekNum and ISOWeekNUm Excel Functions. These functions are designed to help you extract the number of a week from a given date. Using this week numbers you can organize your data more efficiently. These numbers would help you manage your […]

Excel Weekday Function

Excel Weekday Function

Excel 2016 Weekday Function. In this video, you will learn how to make use of weekday function. Weekday function is used to find the day of a particular date. This function can be used in a variety of ways when tracking the day for the date. While dealing with sales data, analytics data, research data […]

Generate Random Dates in Excel 2016

RandBetween – Generate Random Dates in Excel 2016

Did you ever struggle with Excel on how to generate Random numbers in Excel, or how to generate random dates in Excel? well, you have a treat here. In this video tutorial, you will learn how to make use of the randomBetween function to produce Random numbers. You will also see the usage of a […]