Introducing the Excel Functions Workshop

Learn life-changing skills and jaw-dropping magic tricks in Excel that will save hours in your day and significantly reduce frustration when working with data. Every Excel user will need these functions to eliminate unessential work and instantly clean up data for reports.

Module 1: Excel Functions 101

60 minutes + 30m Q&A

  • Order of Operations

  • References (Relative and Absolute)

  • Basic Functions: Sum(), Count(), Min(), Max(), Average()

  • Dynamic vs. Static Results

  • Plus Tips & Tricks, Troubleshooting

Module 2: Clean Up and Nested Functions

60 minutes + 30m Q&A

  • Concat(), TextJoin(), Flash Fill

  • Left(), Right(), Proper(), Lower(), Upper(), Trim(), Mid()

  • IfError() Functions

  • Nested Functions

  • Plus Tips & Tricks, Troubleshooting

Module 3: Date Functions

60 minutes + 30m Q&A

  • Date()

  • Datevalue()

  • Weekday()

  • And many other calculations for dates

  • Plus Tips & Tricks, Troubleshooting

Module 4: Logical Functions

60 minutes + 30m Q&A

  • If()

  • Or(), And()

  • Countif(), Countifs()

  • Sumif(), Sumifs()

  • Plus Tips & Tricks, Troubleshooting

Module 5: Look Up Functions

60 minutes + 30m Q&A

  • Vlookup(), hlookup(), xlookup()

  • Plus Tips & Tricks, Troubleshooting


Join the RedCape Academy for this Excel Functions Workshop

Meet Your Instructor

Vickie Sokol Evans

Microsoft Certified Trainer

Vickie Sokol Evans is a globally recognized digital productivity instructor and comedic speaker who trains the world's smartest people how to use their technology to get better results in less time. Her clients include: Microsoft, The Gates Foundation, Stanford University, The New York Times, Starbucks, Amazon, UK's Parliament, and most notably Bill Gates' team, among many others. A Microsoft Certified Trainer with 25+ certifications and over 20 years' training experience on PC and Mac platforms, Vickie is founder of The Red Cape Company headquartered in Austin, Texas.

Frequently Asked Questions

  • Does this apply to Mac?

    Yes! Vickie will be using a Windows PC to deliver the workshop, but these foundational Excel functions work on both Mac and PC. Vickie has been teaching Microsoft technologies on both Mac and PC since 1997, and she uses many of the same best practices on her Mac, which she uses daily.

  • What if I can’t make the live course?

    All RedCape Academy classes are recorded, and students will get access to the replays in the course library within 24 hours of the live event.

  • Do I need a certain competence level to do this program?

    If you are new to the Excel, you will pick up the most important tips for your level and then you'll be able to return to the replays to learn more.

Hear From Previous Attendees

“Vickie is the David Blaine of Excel - WOW!!!!”

Leesa Sikveland

“I'm still reeling with the information Vickie shared. I got back to the office and immediately started reformatting all my Excel documents.”

Bernice Lorenz, Executive Assistant to President, Edelman

“Just finished with the webinar on Power Pivots for Excel with Vickie. Vickie is gold! The presentation and her enthusiasm is absolutely amazing. I look forward to the next webinar.”

Seth Dunayer, Associate Director, Apollo Management