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

Add artistic effects, make corrections, add color, make images transparent, compress pictures, change pictures, reset pictures in Excel by following this tutorial.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

This guide explains how to generate barcodes in Excel without any additional installations, using both the desktop and web versions of Excel. It covers formatting cells to preserve leading zeros ...

How to Format a Sales Report in Excel. A sales report should reflect changes to its underlying data quickly and accurately. For that reason, it often makes sense to format a report in the same ...

In this guide, I'll walk you through the different ways to format your chart, with Excel's main chart-formatting actions written in bold so you can find them more easily.

How to Create Pipe Delimited Files in Excel 2010. Microsoft Excel allows you to export spreadsheet data to a number of common formats for use with other applications. If you need to export data to ...

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?

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 Subtotal feature is a great tool, but you can make the results even better by customizing the format.