As you create Excel spreadsheets for your small business, time and date functions frequently add both convenience and programming capability to your workbooks. There's good news with date functions.

Microsoft Excel's Auto Fill features help you quickly enter the same value in more than one cell or fill a series of cells with related or sequential values. You can type "Acme Corporation" in one ...

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results. When concatenating—using a formula ...

Now, Microsoft finally has a fix. In an announcement last week, the Microsoft 365 team released a setting that enables Excels users to change the overly helpful default behavior. To turn off this ...

Excel responds to certain letter and number entries with automatic formatting. This makes sense in most cases, but sometimes it can be very annoying, as the user then has to switch back to the desired ...