Cleaning up data using the Data Autofilter - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

Let's say you are making an Excel table where you shall input how many hours did you work for everyday. And you would like to make designation with colors. Red number for less than 8, blue for 8 and green color for more than 8. You can make that process automatic in MS Excel and here's how.

Data Analysis With Charts

The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified. Excel has several protectionrelated features.

How to create simple pivot tables and reports using excel.

The Auditing Toolbar is one if Excel's best kept secrets. It allows you to visualize the cells used in any formula. In particular is allows you to view what cells are being used by a particular formula, what other cells are relying on the cell you have specified, follow links to other spreadsheets and more recent versions of Excel include some error checking capabilities.