Replace manual Excel tasks with conditional columns, smart merging, the unpivot tool, and more.

It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number combinations. This makes it friendlier to read and understand. For example, ...

Many people write Excel formulas for the computer, but experts write them for people. If your logic looks like a wall of text, it's a liability. These five simple habit shifts will help you tidy your ...

A spreadsheet with a customized perpetual calendar that allows team members to make bookings for their duties each month and update specific bookings as events to the Outlook Calendar. It involves ...

Your typical Excel workbook—the file you're working in—can get loaded with plenty of worksheets (each indicated by a tab at the bottom, which you can name). Hide a sheet if you want, rather than ...