Microsoft Excel 2016 Date and Time EDATE functions

In our last video, we showed how Microsoft Excel 2016 uses date and time functions. Now that you know the logic Microsoft uses to work with dates and times, you can use a variety of formulas to help make your job easier. In this video, we will focus on a few more useful formulas that […]

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

How to use Relative and Absolute Cell References in Microsoft Excel 2016

When working with a Microsoft Excel 2016 data table you may find that it is useful to define a constant outside of the data table rather than repeating it in every cell. Suppose you are trying to apply three different tax rates to a data table and you need to be able to adjust those […]

Microsoft Excel 2016 Nested ‘IF’ Formula

In our last video, we covered how to use “IF” formula in Microsoft Excel 2016. The IF formula allows you to ask a cell in a spreadsheet if a statement is true or false. This basic formula will allow you to build complex calculators in Excel which will help you be more efficient in your […]

CW Portal