Another question from Columbus, Indiana. How can you choose a default style (from the PivotTable Design tab) for all future pivot tables? Yes, there is a Set as Default choice, but it only applies to future pivot tables in this Continue reading “Default Pivot Table Style in Excel – 2405”
Category: Excel
Sort Variances By Absolute Value in Excel – 2404
A question from my Columbus Indiana virtual seminar: How can we sort a data set by Absolute Value? They have columns with Forecast, Actual, and Variance. A large variance is bad, whether it is positive or negative. My solution Continue reading “Sort Variances By Absolute Value in Excel – 2404”
Bob Umlas AutoSum Oddity – 2403a (Updated)
Another cool discovery by Bob Umlas. Say that you need to add a Total, Average, Max, and Min to the right of a data set. The AutoSum drop-down menu in Excel offers all four features. But how can you use Continue reading “Bob Umlas AutoSum Oddity – 2403a (Updated)”
Looking For Design Inspiration For Power BI – Advance Visualization Techniques Course Sample
In this video, I’ll talk about how you can look for design inspirations for your Power BI reports. Making reports on a regular basis can be draining creatively. It’s normal to run out of ideas so I want to share Continue reading “Looking For Design Inspiration For Power BI – Advance Visualization Techniques Course Sample”
How To Create Custom Dimensions And Groups To Your Filtering Tables Fast In Power BI
For today’s video, I want to show a simple but highly effective technique to create additional filtering, and dimensions to filter by in your Power BI report. There are a number of places where you can add different dimensions Continue reading “How To Create Custom Dimensions And Groups To Your Filtering Tables Fast In Power BI”
How To Use Standard Theming In Power BI Reports
For this tutorial, I’d like to continue my examination of theming in Power BI reports. In my experience, the majority of examples you can find online demonstrates the use of the built-in colour themes or the creation of custom colour Continue reading “How To Use Standard Theming In Power BI Reports”
Financial Reporting Techniques For Power BI – Complete Table Customization Tips
For today’s video, I’d like to go over a little bit of financial reporting. I’ve already created a few videos for this back in a couple of years now, so I think it’s time for an update. I want to Continue reading “Financial Reporting Techniques For Power BI – Complete Table Customization Tips”
PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720
Download Excel File: https://excelisfun.net/files/EMT1720.xlsx
Learn how to count numbers between upper and lower limits with a PivotTable and the FREQUENCY Array Function. Learn how the counts can be different with the two methods and why this happens. See Continue reading “PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720”
Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719
Download Excel File: https://excelisfun.net/files/EMT1719.xlsx
Learn all about joint probability tables, including how to use an Excel PivotTable to create them in 20 seconds.
Topics:
1. (00:00) Introduction.
2. (00:36) What is a Joint Probability Table?
3. (00:59) What is a Joint Probability?
4. Continue reading “Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719”
INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718
Download Excel File: https://excelisfun.net/files/EMT1718.xlsx
Learn how spill a constant value down a column
Topics:
1. (00:00) excelisfun Zap Intro
2. (00:04) INDEX and SEQUENCE to spill a constant value down a column. Microsoft 365 Formula.
3. (01:05) How to copy a Spilled Continue reading “INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718”
Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to add the text numbers at the end of a description to get a Sales Total using Excel worksheet formulas or Power Query Formulas. Extract Numbers from end of Description Trick.
Topics:
1. (00:00) Continue reading “Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721”
Show Changes In Excel – WOW! – 2412
A new feature debuting in Microsoft 365 Excel. If you save your file to OneDrive Excel will record every change anyone types in the workbook. You can then see those changes using Review, Show Changes, in Excel Online. It is Continue reading “Show Changes In Excel – WOW! – 2412”