Date and Time Formulas
Many professions- sales, retail, medicine, law, business-are date driven. Here is a Table that shows some of the Date Formulas. Four Useful Date and Time…
Category: Excel
Statistical Functions in Microsoft Excel
Statistical functions work well if you select and Name a Range of data. Read more
Dazzle Them with Data!
A sunburst chart is a dazzling display. However, the data has to be organized in a particular way Read more
Useful TEXT Formulas
Another group of formulas you may find useful are ones that work with TEXT. Three come to mind. The UPPER function formats all of the... Read more
The Dynamic Duo: vLookUp and IF
Here is a YouTube video that demonstrates all of these steps that you can watch if you wish: Intermediate Excel: Using Lookup Tables The Lookup... Read more
