We have already dealt with some of the basic functions of Microsoft Excel, an application of the MS Office suite. In this part, we look at the various kinds of formatting capabilities Excel provides.

1] Use the Clear Formats option to remove formatting in Excel The first and easiest method to clear formatting in your Excel workbook is to use the Clear Formats option. It is available on your ribbon ...

If you are unaware of Microsoft Excel's "Format Cells" option, then you will discover it offers a wealth of formatting possibilities. Aside from the many built-in number formats, Excel allows you to ...

Working with large spreadsheets means constantly tracking rows and columns, and it's easy to lose your place when you're staring at hundreds of cells. I've tried different workarounds over the years — ...

When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in-depth examination of specific sales results, ...

The Today() function represents the current date in Microsoft Excel. If you type the =Today() function in any cell and press Enter, Excel will show you the current date. Therefore, this method is used ...