Microsoft Excel is a powerful database management tool with all sorts of in-depth problem-solving functions and dynamic formatting. To make the most of it, though, you need to know the basics. Using ...

Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column. Excel's myriad formatting tools let you add colors, formulas and borders almost anywhere in a worksheet. You can ...

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting. Excel offers numerous ways to ...