How to Set a Rule in Excel. You can use Microsoft Office Excel to set conditional formatting rules to handle complex scenarios without having to code all of the formulas yourself.

Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

Learn how to create a Heatmap in Microsoft Excel. Use Color Scales and custom rules to show heatmap in an Excel spreadsheet.

An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...