When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in-depth examination of specific sales results, ...

Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to. In this article, I'll explain what each number format is, ...

Unless you were a math whiz in college, you probably have no great love for Excel. Manipulating Excel formulas can be challenging, but the payoff (like elegantly formatted tables that identify ...

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

The list of ‘anythings’ Excel can do keeps growing, as new versions with more templates and better features are released. Many prefer the simplicity of Excel over Word because it offers a huge, very ...

Recently Microsoft has introduced a game-changing set of functions in it’s Excel spreadsheet software that harness the power of Regular Expressions (REGEX) to streamline data extraction, cleaning, and ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...