Anatomy of Excel formatting: Make better spreadsheet presentations - part 4

Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within a vast range of skill level and knowledge. This series of Excel tutorials can make that training much simpler. This installment of the series shows you how to handle conditional cell formatting.

Microsoft Excel spreadsheets are an excellent way to communicate numerical and statistical information, but sometimes pure numbers can be overwhelming, especially for more general audiences. This is where formatting can help, because it can emphasize the particular bit of information you want the audience to see and focus on. This download, Part 5 of the Anatomy of Excel series, explains how to perform several basic formatting tasks in Excel, including:

• Automatically format cells based on their contents
• Change the margins for your printed page
• Add a header and footer to your printer spreadsheet

This download tutorial deals with the one aspect of Excel formatting, but there is so much more to learn. What aspects, functions, commands, and/or features would you like to see covered in future installments of the series?

You can get access to the entire Excel series using this link to the excel anatomy tag.

This download is also available as a TechRepublic article.