Categories
Technology Training

Use Date and Time Functions in Microsoft Excel 2016

In today’s video, we are going to show you how to work with dates and times in Microsoft Excel 2016. First, we will show you the logic that Excel uses to calculate dates, and then we will show you how you can work with this logic.

It is useful to understand that Excel sees dates as numbers, adding one number for every day after the first of January 1900. The hours, minutes and seconds are stored as decimal values. Knowing this will help you be able to work with the date and time functions more easily.

The next step in working with dates and times is to know the “Today” function, which will bring up the current date in any cell, and the “Now” function, which will bring up the current date and time. If you need to reference a date in your spreadsheet, it is easier to type in the equal sign followed by “Today” and Excel will automatically populate the date for you.

Another common function is knowing how to calculate someone’s age using their date of birth in a formula. To do this you will need to know how to use either the “INT” or Integer function or the “YEARFRAC” function. Both will calculate the difference between a recorded date and the current date simply by using them in an equation.

Working with dates and times in Excel is very straight forward once you know how they are being processed. Knowing how to use functions to manipulate dates and times will help make you more accurate and efficient when working in Excel.

Categories
Technology Training

How To Use Microsoft Excel 2016 “IF” Formula

One of the most powerful functions of Microsoft Excel 2016 is the logical formula. Especially the “IF” formula. The IF formula is a way for you to apply logic to your spreadsheet cells to make customized calculations just by entering data. It takes a little practice but once you get used to this function you will be able to build complex calculators simply by using the IF formula.
IF formulas look to see if a statement is True or False. If the statement is true the logical formula produces one calculation. If the statement if False then it produces another calculation.
In this video, we will review a few of the operators that allow you to use the IF logic effectively. These operators include equal to, greater than, less than, greater than or equal to, less than or equal to and the not equal to. Using these operators, you will be able to manipulate the IF formula for most any calculation.
This may seem complex but once you understand the format used to build this formula it is really quite simple. It will help to start by understanding what you want the calculation to do. The best way to do that is to write out what you want to calculate. An example of this would be “IF the number is greater than or equal to 100, print yes. Otherwise, print no.” Setting this formula for any cell will allow Excel to apply logic and make a quick calculation.

CW Portal