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”
Month: August 2021
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”
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”
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”
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”
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”
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”
Four Excel Features To Maybe Avoid – 2408
In an episode guaranteed to hack off many of my friends, Bill and Ann K. Emery discuss some Excel features they don’t like, such as:
The Action Pen
Shoot a Photo Of Your Data
Ctrl+T Tables
Conditional Formatting Data Bars with a Gradient.
Check out Continue reading “Four Excel Features To Maybe Avoid – 2408”
XLMiner Is A Better Replacement For Excel Analysis ToolPak – 2409
Are you trying to use the Analysis ToolPak dialog box?
There is a better version, for free, from Frontline Systems.
Running into a bug? Microsoft knows about the problem.
George Mount’s book: https://amzn.to/3ygyK5z
Dan Fylstra’s XLMiner info: rel=”nofollow”>https://appsource.microsoft.com/en-us/product/office/WA104379190
New Accessibility Tab In Excel Ribbon – 2410
May 20th, 2021 is Global Accessibility Awareness Day. It is a great day to take a look at the new Check Accessibility tab in the Excel ribbon.
Excel Indent Levels As Data – 2411
Today, Bill has data where the amount of indent is telling him some data. He shows how to use VBA and IndentLevel to add a column of data showing the indent level. Then, a second technique, using the Group button Continue reading “Excel Indent Levels As Data – 2411”
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”