Extreme Excel Efficiency - 8 CPE Credits

10 Days

·

Cohort-based Course

Elevate Your Excel Skills & become your company's Guru: Master Shortcuts, Formulas, Macros, Dynamic Arrays, Power Query, and so much more!

Course overview

Excel does so much, it's easy to get lost. We'll target the game-changers!

Do you or your team:


❓ Spend excessive time maintaining and updating key spreadsheets?


❓ Lack the capacity for valuable analysis?


❓ Feel like your shared files could use more polish?


❓ Know just a handful of formula functions?


❓ Lack of confidence when you start building a new Excel template?


If you answered "No" to all of these questions, you rock! You can close this page.


But if you shrugged yes to at least one and want to do your best work with next-level Excel efficiency...

Then read on!

Who Stands to Excel with This Course?

01

Finance, accounting, and operations professionals who want to use the best features to maximize productivity

02

Recent college graduates looking to make their mark and leave a legacy

03

Daily Excel users that struggle to keep up with building and reviewing workbooks

How you will excel from this course

Work much more efficiently in Excel (see the potential ROI below)

Leverage the must-know shortcuts, formatting, formulas, and features to make Excel work for you

Use best practice approaches and habits like the experts

Design and structure your files to minimize errors and manual steps to update each period

Take advantage of powerful new features

Let the new Dynamic Array functions and Power Query make you the envy of your peers

Automate your work like never before

Learn how macros and add-ins can help you automate your boring work well beyond just Excel

Guarantee a Spot and Join the Waitlist

A pattern of wavy dots

Working efficiently with Excel is no longer a nice-to-have, it's a must-have, so you don't lose the will to live...

Free resource

The Top 50 Most Useful Excel Features

Get familiar with the most important Excel features, along with valuable tips to apply and gotchas to avoid. Test your expertise and reference this guide when working on new and exciting projects.

Get this free resource

Quick payback and massive ROI (calculate your own below)

Quick payback and massive ROI (calculate your own below)

Training saves time for yourself and others

The more you share, the more you elevate everyone around you.

People often save 5+ hours a a week

  • That's a payback period of less than 3 weeks (grid on the left)! What wouldn't you invest in with that kind of a return?
  • Even if you just save an hour a week, your payback period is less than 3 months.

Use our ROI calculator to fine-tune your individual scenario

What people are saying (more below)...

        Derek has the heart of a teacher. He successfully taught my team practical and realistic ways to work more efficiently. He's a very creative thinker and understands how even the smallest efficiency gains add up to huge improvements. I highly recommend leveraging Derek for learning how to work more efficiently and get the best out of your team!
Maggie S.

Maggie S.

Controller
        Chris is one of the best Excel experts in existence! I'm thrilled to partner with him in teaching this course. I took my Excel game to a whole new level after reading his many articles, including how to build add-ins. To this day, I still often find his website at the top of the search hits when looking up a quick Excel or VBA reference.
Derek H.

Derek H.

Excel Developer and Instructor

Meet your instructors

Derek Henry, CPA, CFE

Derek Henry, CPA, CFE

Owner - Excelevate Consulting, LLC

All throughout my career I've challenged myself and others to work more efficiently and with more purpose. As an accountant, software developer, and sales engineer, I've helped hundreds of people save a lot of time with a variety of solutions, especially Excel. I've built thousands of macros throughout my career and taught hundreds of people how to get the most out of Excel with practical approaches. Through this course, you can too!


My mission is to help a lot of people save a lot of time by educating, enlightening, entertaining, and empowering, and that's exactly how we've designed this course.


My core values are Hospitality, Efficiency, Accountability, Resourcefulness, and Tenacity, and these shine through in my approach to help people in a fun, caring, and impactful way!

[Special Guest] Chris Newman (2023 Microsoft Excel MVP & TheSpreadsheetGuru.com)

[Special Guest] Chris Newman (2023 Microsoft Excel MVP & TheSpreadsheetGuru.com)

Founder TheSpreadsheetGuru.com | Global Finance Director - Vertiv Holdings Co (NYSE : VRT)

After graduating college, I quickly realized how important an advanced understanding of Excel is to any business, and how valuable it is to be a resident guru! I learned everything I could about Excel and earned the nickname "Chris Macro" for the positive impact I had in improving and automating key processes!


I started TheSpreadsheetGuru.com in 2015 to help pass along my knowledge to the world with all kinds of articles and examples from basic to advanced. My tutorials have been acknowledged for combining simplicity, creativity, and artistic design into the solution. I've also built several popular Excel add-ins that are utilized by companies around the world.


Millions of people learn from my educational resources every year to save time, reduce risk, and add value to their companies with Excel. For these efforts, Microsoft has recognized me with the Excel MVP award from 2016 through 2023.

A pattern of wavy dots
Be the first to know about upcoming cohorts

Extreme Excel Efficiency - 8 CPE Credits

|

Bulk purchases

Course syllabus

01

Excel 101: Crucial features and functions

  • Learn the most common and helpful keyboard shortcuts
  • Learn several approaches to formatting like a pro
  • Learn key formula functions to tackle and streamline all kinds of scenarios
  • Learn several valuable, underused Excel features

02

Excel 102: Best practices for design and structure

  • Learn eight habits of Excel pros
  • Learn how to structure workbooks for minimal update effort
  • Learn how to optimize formatting for a great look and minimize risks
  • Learn how to build workbooks that you can hand off with confidence

03

Excel 103: Let your data work for you

  • Learn how to minimize formula updates with Excel's new dynamic array functions
  • Learn why Excel Table Objects are so powerful
  • Learn how to automate importing and cleaning your data without coding through Power Query
  • Learn how to import data from a variety of sources (like images!)

04

Excel 104: Maximize automation with macros and add-ins

  • Learn how powerful and important macros are
  • Learn eight habits of macro developers
  • Learn the building blocks of macros to understand and build them
  • Learn how to leverage macros in pre-built add-ins

Get reimbursed from your employer!

Get reimbursed from your employer!

Use your company's training and development budget

Most companies have a training and development budget and it often goes unused! Because you'll learn valuables to apply to your job, it's extremely common for students to receive employer reimbursement.

Leverage our reimbursement template

We did the heavy lifting and drafted an email for you listing the course benefits to make it easy to ask your manager for reimbursement approval.

Your investment is risk-free

Your investment is risk-free

Guaranteed quality content

If you attend the sessions, actively participate, and still don’t find the course valuable, we’ll happily refund your full payment until 7 days after the course ends.

Course schedule

4-6 hours per week
  • Mondays & Wednesdays

    4:00pm - 6:00pm EST

    4 x 2-hour-long workshops and two optional Q&A sessions.

  • Minimal homework

    5-15 minutes per session

    Apply content right away to reinforce what you've learned.

  • Have to miss a session?

    They're all recorded

    Catch up with recordings - or watch them later as a refresher. All materials and resources will be available in the student course portal.

Learning is exponentially better with cohorts

Learning is exponentially better with cohorts

Active hands-on learning

This course has dynamic, practical content and builds on live, interactive discussion.

Interactive and project-based

You’ll be interacting with other learners through breakout room activities.

Learn with a cohort of peers

Join a community of like-minded people who want to learn and grow alongside you. Make connections that often last a lifetime!

Tools, cheatsheets, and checklists

You'll walk away not just with knowledge, but the resources you need to support and reinforce your learning.

More testimonials

        PASSION! That is the best way to describe Derek. He goes above and beyond every day, constantly challenging the norm and striving to work more efficiently. He's a great teacher and mentor. He's always willing to share his knowledge to help and inspire others to get better. I'm so excited for Derek to help everyone with this course!
Cyndi R.

Cyndi R.

Principal Solutions Consultant
        I can always count on Derek to help me figure out the easiest way to solve complex problems. He's creative, engaging, and dedicated, and has so many great insights to share. Looking forward to having my team attend your courses to set them up for success!
Jeff B.

Jeff B.

VP and Controller
        Derek has been so great to work with. He's taught me so things about working smarter, especially with Excel. He's the perfect one to lead a course like this teaching his endless insights on such impactful topics. You'll be entertained as much as you'll be educated. Bring on the dad jokes!
Molly C.

Molly C.

Senior Solutions Consultant
        Derek provides passion and unmatched credibility in everything he does, even as he takes on new challenges amid shifting priorities. Once when he was new to a role, he jumped in at the last minute to host a 200-attendee training session with no warning. Sharing success stories, humor, and real-world insights kept them captivated and wanting more!
Terry R.

Terry R.

Owner - Reddington Solutions
        Derek is a continuous learner. He serves from the heart and wants himself and those around him to succeed in whatever their passion is. Derek is relentless in the pursuit of efficiency in all aspects of life. You're guaranteed to learn something new from Derek and be able to apply it to your daily life.
Brian M.

Brian M.

Pre-Sales Manager
        Derek has been one of the most impactful people I've worked with in my career. His ability to communicate and connect with people - sharing valuable insights and simplifying complex topics - is a major contributor to his success...and mine. He's a walking time hack (that's a big compliment) and it's well worth checking out anything he has to share.
PJ M.

PJ M.

Account Executive

Frequently Asked Questions

Can I get reimbursed by my company?
What happens if I can’t make a live session?
I work full-time, what is the expected time commitment?
What’s the refund policy?
Are group discounts available?
Will there be a community attached to this course?
How long can I access the content?
Does this course qualify for CPE and will I receive a certificate?
What is the cancellation policy?
What if I have more questions?
A pattern of wavy dots
Be the first to know about upcoming cohorts

Extreme Excel Efficiency - 8 CPE Credits

|

Bulk purchases