Although Microsoft Excel is a powerful spreadsheet out of the box, macros make it even more useful. You can create and record macros within the app.

You can run a Macro in Excel by clicking the macros command on the Developer tab, using a combination shortcut key, by clicking on a graphic object, etc.

If you are new to macros, check out my dedicated guide below, where I go over the benefits and step-by-step instructions for creating macros in Excel.

How to Create Macros Downloading Real Time Data to Excel. Many companies depend on up-to-date data to make informed decisions regarding their businesses. Millions of small businesses around the ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

A check box in Excel can use either Excel's form controls or ActiveX controls for formatting. Form controls offer simple formatting, as well as the ability to add a check box to a chart sheet or ...

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.