Are Dynamic Array Functions with Conditional Formatting Better Than Pivot Tables in Excel?
I don't use Pivot tables in Excel... and it has helped my career growth dramatically. In this video I explain how I created a presentation layer table using a combination of dynamic array functions and conditional formatting that will stand up to data changes over time!
📢 NEW! Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://tmbanalytics.com/resources
🫵 Ready to take on the 7 Days to Excel Challenge?
👉 Click here if you dare: https://tmbanalytics.com/courses/7-da...
👉 Connect with me on social!
Linkedin: / mattbrattin
Tiktok: / mattbrattin
In a recent viral video, I created a custom summary table in Microsoft Excel—and the comments flooded in: "Why not just use a pivot table?"
After providing an answer in this video, I got even more questions about how I did what I showed in the video:
I don't use Pivot tables in Excel... and it has helped my career growth
• I don't use Pivot tables in Excel... and i...
So, in this video I explain my approach and walk you through how to use a few key functions and conditional formatting to make a great looking table without relying on pivot tables and all the baggage that come with them.
VIDEO TOPICS:
0:00 - Intro
0:40 - Jumping into the data
1:40 - Overview of what we'll cover
3:55 - SORT and UNIQUE Functions in Excel
4:30 - TRANSPOSE and UNIQUE Functions in Excel
5:15 - VSTACK and SUMIFS Functions in Excel
7:34 - Conditional Formatting in Excel
11:40 - BONUS - DROP Function in Excel
LEARN MORE ABOUT USING EXCEL FOR ANALYSIS:
Excel for Analytics - Portfolio Project Series Video 1 - Quick Excel Tips • Excel for Analytics - Portfolio Project Se...
Excel for Analytics - Portfolio Project Series Video 2 - Data Cleaning in Excel
• Excel for Analytics - Portfolio Project Se...
Excel for Analytics - Portfolio Project Series Video 3 - Data Exploration and Analysis in Excel
• Excel for Analytics - Portfolio Project Se...
Excel for Analytics - Portfolio Project Series Video 4 - Data Presenting in Excel
• Excel for Analytics - Portfolio Project Se...
OTHER EXCEL TOPICS:
The MOST Ultimate Excel LOOKUP Guide | Can you guess which is my favorite?
• Why I Never Use VLOOKUP Anymore (And What ...
How to easily combine data into one cell in Excel (and why I stopped using CONCATENATE)
• The Best Way to Combine Text in Excel (It’...
#excel #pivottable #exceltips #spreadsheet