Questions? Read our FAQs

Basic Excel Hacks for Business


Matt Schaar
Founder, Brush Labs

Questions? Read our FAQs

About This Class

Spend less time manipulating data in Excel and more time acting on the results.

In this class, you’ll learn how utilizing this software effectively can improve your accuracy and efficiency, by organizing data into functional tables and learning shortcuts to make your Excel sessions more productive. Matt will also introduce different methods for basic data analysis, including Autofilter and Pivot Tables, and when and why to use each.


  • Introduction 3:16
  • Case Study 6:07
  • Refine your Data 20:21
  • Identify Relationships 8:09
  • Pivot Tables 24:25


  • Learn best practices for data entry and formatting in Excel
  • Use keyboard shortcuts to optimize your efficiency
  • Build your very first Pivot Table

Prereqs & Preparation

This class is designed for beginning Excel users. Some prior experience with Excel would be helpful for the exercises.

About the Instructor(s)


Matt Schaar
Brush Labs

Matt Schaar is on the Client Services team at Promolytics, a B2B SaaS platform for the trade promotion space. As a former engineer, Matt provides deeply-engaged support for his clients through effective data analysis; these experiences have been refined over his four-plus years as a strategy consultant to Fortune 500 companies, startups, and nonprofits at the Boston Consulting Group and Brush Labs. Matt has an MBA, Master of Public Policy, and B.S. in Aerospace Engineering from the University of Michigan, and he loves a good plate of spaghetti carbonara to fuel his running addiction.

Related videos