Information management and technology assurance

You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.

Using 3D formulas is a easy way to manage files than summing each individual spreadsheet tab.

This article looks at a few ways to extract and present information about the day, month, and then year.

There are two ways to solve an autocorrect problem such as the one in the question above — a temporary solution and a permanent solution.

If you need to create a sum based on more than one criteria, you can use SUMIFS.

There are several ways to add color to your Excel workbooks.

If you are routinely creating formulas that accomplish the same purpose, spending a little extra time upfront to create a function that can be reused will save you time in the end.

This month’s column walks you through all the special ways you can paste text, data, and even application capabilities in Excel.