Excel Power Skills: Master Functions, Formulas, and Macros – A 3-Hour Workshop
Learn the top Excel functions, master VLOOKUP, HLOOKUP, INDEX and MATCH, and record, run and edit macros in VBA to automate repetitive tasks.
Speaker
Cathy Horwitz
Microsoft Office trainer · 30+ years in Office training
Overview
This 3-hour Excel workshop covers three intermediate to advanced features that bring automation into your spreadsheets: formulas and functions, lookup functions and macros.
You'll start with the top 10 functions every user should know, including SUM, AVERAGE, COUNT, IF and its variants, date functions and text functions for cleaning imported data. Next come lookup functions, which beat searching for data by hand: VLOOKUP and its arguments, approximate matches, lookups across workbooks, handling #N/A with IFNA and IFERROR, HLOOKUP, and why INDEX and MATCH is often the better choice.
Finally, you'll create a macro with the built-in recorder, save a macro-enabled workbook, run it and make simple edits in VBA. No prior macro or VBA experience is needed.
Why attend: A handful of functions, lookups and macros can save hours of manual work and make your spreadsheets perform better, whether you run a small business, work in an office or use Excel casually. This workshop suits business owners, executives, managers, accountants and CPAs, financial consultants, auditors, bookkeepers, IT, HR and marketing staff, and anyone who works with large amounts of data in Excel.
What’s covered
- Statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
- IF and its counterparts COUNTIF, SUMIF and AVERAGEIF
- Calculating dates with TODAY and NOW
- Text functions for imported data, including LEFT, RIGHT, LEN, TRIM and CONCATENATE
- The arguments in the VLOOKUP function
- Why absolute references matter in lookup functions
- Approximate matches with VLOOKUP
- Simplifying multiple-field lookups with concatenation
- Looking up data from another workbook
- How VLOOKUP stops at the first match in a list
- Why VLOOKUP sometimes returns #N/A
- The IFNA function (Excel 2013 and later) and IFERROR for handling missing matches
- Horizontal matches with HLOOKUP
- Why INDEX and MATCH often beats VLOOKUP or HLOOKUP
- Finding an item's position with MATCH
- Workbook macros vs. personal macros
- Making macros available to all your workbooks
- Creating a macro with the macro recorder
- Saving a file as a macro-enabled workbook
- Running a macro
- Viewing the recorded macro in VBA
- Editing the macro
Who should attend
What you get
About the speaker
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.
Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.
Known for her engaging, hands-on teaching style, Cathy incorporates real-world business scenarios to ensure students gain practical skills they can immediately apply. Whether you're looking for corporate training, individual coaching, or advanced Microsoft Office workshops, Cathy delivers results-driven instruction that enhances efficiency, problem-solving, and software proficiency.
When not teaching, Cathy enjoys gardening, shopping estate sales and refinishing mid-century furniture.
Staci Warne · 60 min
Craig Brody · 60 min
Ritu Arora · 60 min