In this video, you will learn how to create and use Macros in Excel to automate repetitive tasks. Using a real work example, ...

In Microsoft Excel, macros are recorded in Visual Basic programming language and it can be run in several ways. You can run a macro by clicking the Macros command on the Developer tab, using a ...

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel. Once you stick your toe into the VBA waters, you’ll realize how powerful and ...

Stop letting merged cells break your Excel workbooks. Discover three fast methods to apply Center Across Selection formatting ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

Need to know your organization’s YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel. You can make an Excel PivotChart to show year-over-year results like this one.