Through Excel Learning series my aim is to help you learn Excel. These videos are produced using the Excel 2016 version, however, shall help you learn even if you are using Excel 2019, 2007, 2010, 2013 as they all have same basics with some differences which I will highlight in the course to enlighten you.
I will produce 1 or more than 1 video every week. If I get enough room to produce these videos, I will ensure to bring you at least 1 video every day.
How to make use of NETWORKDAYS function Overview In this video, you will learn about how to make use of NETWORKDAYS function, and you also learn how to use NETWORKDAYS.INTL excel function. By the end of this video, you will be able to use these functions with ease and should be able to calculate the […]
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 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 […]
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 […]
Find Age or Tenure using DATEDIF in Excel 2016. In this video, you will learn how to use DATEDIF function. This is a hidden gem inside Excel, for some odd reason this function does not show up when you start typing in any cell as other functions do. This function proves really handy and will […]
Calculate Expiry Date in Excel 2016 – EDATE. In today’s video, we will learn how to calculate the end date of a contract based on the start date and the length of the contract in the number of months. In this demonstration, we will be using an EDATE function in excel 2016. This function is […]
In this video, you will learn how to calculate the sum of time in Excel. We have demonstrated the different approach on how you can make sure that the calculation you do to perform the sum of time in Excel provides you with accurate numbers. With this video, you will be able to calculate and […]
Excel Date Format Shortcut. In this video, you will learn how to use a handy excel date shortcut to format dates. This shortcut is going to prove a real lifesaver for you when you are dealing with a set of long range of dates especially in the situations where you are unaware of the format. […]
Formatting Dates in Excel video will help you learn how to format dates inside Excel. In this demo, you will learn different ways of formatting dates using standard and custom formats. You will also see how to use a standard type of dates from a different location.
Autofill Dates in Excel video will help you learn how to use Autofill to fill in dates inside Excel. In this demo, you will learn how to fill working days only or weekdays only, months, quarters inside excel using a handy autofill.
Calculate Tenure in Excel using Days Function video will help you learn how to use Days Date Function in Excel. In this demo, you will learn how to calculate the tenure of an employee using days function. You can calculate the tenure either in days, months or years format.
Excel Calculate Age using Date Function Today video will help you learn how to use Today Date Function in Excel. In this demo, you will learn how to calculate the age of a person using today function. You will also learn basic operation order in excel through this video.
