Charts can be an effective way to convey data, as opposed to just tables. By visualizing numbers, readers can easily see the highs and lows, and just how much of a variance exists between them. In this example, I'm going to show you how to turn a ta ...
Creating a pivot table is not difficult to do. If you just go to the Insert menu in Excel, there is an option to select a Pivot Table. As long as you have your data selected, Excel goes to work and creates the table. But making a good pivot table is ...
When it comes to working with Excel, mastering the various built-in functions can save you time, increase your efficiency, and unlock new ways to analyze your data. One such function, often underutilized but incredibly powerful, is the CHOOSE functi ...
If you've ever worked with dynamic arrays in Excel, you've probably come across the #SPILL! error. This error message may seem confusing at first, but it’s actually Excel's way of telling you that there’s a problem with how it’s trying to display an ...
The default pivot table layout can oftentimes be suboptimal. The compact view doesn't make it easy for analyzing data, especially when you have many fields. If you're like me, one of the first things you probably do after creating a pivot table is t ...
PIVOTBY is a relatively new function that Excel introduced in 2021. It is a dynamic, formula-based alternative to pivot tables. It’s part of Excel’s push toward more dynamic, flexible data analysis, especially for users who prefer formulas over the ...
Creating a Pivot Table is one of the fastest ways to summarize large amounts of data in Excel. But if your data is spread across multiple sheets, it can seem a little overwhelming. The good news is: you don't have to manually copy everything into on ...
What is the TRIMMEAN function? The TRIMMEAN function has been available on Excel since the 2016 version. What it does is return the mean (average) of your data set, but it excludes a portion of your data. This can be useful if you want to exclude ...
Map charts can help display a lot of data, showing you not only the largest values relative to other values. Below, I'm going to walk you through the steps of creating a map chart using real-world data, which looks similar to the one below: T ...
Do you want to create a list of random numbers in Excel, but avoid repeating values? Below, I'll cover how you can set that up to ensure that no number is shown more than once -- all through just a single formula. Start with the SEQUENCE function ...
