# Category Microsoft Excel Tutorials

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.

## 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…

## Find Age or Tenure using DATEDIF in Excel 2016

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…

## Calculate Expiry Date in Excel 2016 – EDATE

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…

## Calculating Sum of Time in Excel

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…

## Excel Date Format Shortcut

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…

## Formatting Dates in Excel

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…

## Autofill Dates in Excel

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…