Calculating the age of a person or object in Excel is a very useful feature. This can be applied to any need to calculate the time elapsed between 2 dates. There are several ways of doing this depending on your needs. In this video I demonstrate the most useful formulas for calculating age in Excel. ...
In this tutorial I am going to discuss Microsoft Excel time and date functions To see all Excel’s functions related to time and date : Formulas tab (on top ribbon)-Date & Time drop down- select. If you know the syntax just select a cell and start typing then double click the option you want from ...
In this Excel drop down lists tutorial for beginner’s video I demonstrate this extremely useful feature of Excel that everyone should know about. The drop down feature in MS Excel is most useful when multiple users are entering data into a shared Excel spread sheet. The drop down list ensures that all users must enter ...
In this video tutorial on 2 methods to use Excel transpose columns and rows I run through the basics for beginners on how to transpose an Excel data set from columns to rows and rows to columns. The first method uses the paste and paste special tools and is called the static method because the ...
