Microsoft Excel
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. Array functions keep your Excel file smaller in size. In general, array formulas use standard formula syntax. They
Microsoft Excel
The **Countif** function in Microsoft Excel is one of the most popular functions in Excel you can easily master. I use Countif to figure out how many employees are in a certain state or how many customers placed an order for $100 or over. You can even use wildcards in
Microsoft Excel
Let’s say that you want to find out how long it takes for an employee to complete an assembly line operation or a nurse to give insulin after a blood glucose test, or a fast food order to be processed at peak hours. There are several ways to calculate
Microsoft Excel
Entering Military Time into Excel without having to enter the colon for each entry If you want to enter military time in Excel, such as 1300 for 1:00 pm or 1730 for 5:30 pm, Excel won’t do by default, but there are several ways to do make
Microsoft Excel
To find the difference in years, months, and days between two dates in Excel use the Datedif function. This function will allow you put in the start date, end date, and decide the difference in years, months, or days. It is very handy for HR people. YouTube video on Dated
Microsoft Excel
If you deal with sensitive information or Protected Health Information, you need to be very cautious with your data. Microsoft Office has a solution for those dealing with sensitive data. If you have an Excel file, PowerPoint presentation, or Word Document with sensitive information, you should encrypt the file with