How to Format Debits and Credits in Excel. 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 ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

Excel will calculate the total of all the cells in that range. Format the cells to use accounting style. Click and drag on the spreadsheet to select all of the cells with monetary values.

If you find yourself struggling trying to efficiently format large numbers in Excel spreadsheets. Manually adjusting figures to display in thousands or millions, you will be pleased to know that ...

As an example, suppose you have an Excel workbook that contains each student’s numerical course grades, but you would like a visual way to differentiate each student’s letter grade (A, B, C, D, or F).

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

How to use OR () in Microsoft Excel Microsoft Excel’s OR () function will help us find the top-three ranking values: 1, 2 and 3. We’ll use the OR () function in our conditional format formula.