excel macros

Excel Macro Editor Basics

by
Excel macro dialog box.

This Excel tutorial is the follow up to the previous article we did on using Excel’s built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It’s also a great way to learn how the macros work.

Simplify Your Workflow: Learn How to Use Excel Macro Recorder

by
Record macro dialog box

Want to make your Excel tasks easier and faster? The Excel Macro Recorder can automate your repetitive tasks by recording your actions. Envision the efficiency of having Excel handle the heavy lifting for you. In this tutorial and video, I’ll show how to record a macro in Excel. And you don’t need to know Visual Basic for Applications (VBA code).

LEARN MORE

Use VBA Function to Show Excel Filter Criteria

by
excel with filter criteria displayed

Have you ever received an Excel file and wondered how it was filtered without checking each column’s data filter? Or, maybe you needed to send a file and show your filters. That was a problem I faced recently when I started with a list of 3200 non-profits for the county. I needed a way for Excel to show the filters and logic. (Includes Excel practice spreadsheet with VBA code.)

LEARN MORE

How to Use the IF Function in Excel: Formulas and Examples

by
Example of IF function and arguments.

Would you like to make your spreadsheets smarter? Excel’s IF function is an easy way to add logic and decision-making power. Learn how to use this versatile function to calculate discounts, allowances, or commissions based on different conditions or values in your data. This step-by-step guide includes a downloadable practice file.

LEARN MORE