Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

There are several ways to make data stand out visually in an Excel spreadsheet, but one of the simplest and most effective is to apply conditional formatting. What is conditional formatting in Excel?

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells ...

Learn how to make a flowchart in Microsoft Excel without using any external add-on - but with SmartArt Graphics or Shapes Tool.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

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.

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...