Subhash wants to make changes in either the source or copied data and have it reflected in the other place. A little bit of VBA makes this possible.
The code from the video:
Private Sub Worksheet_Change(ByVal Target As Range)
Continue reading “Excel Mirror Changes Made Here or There – 2422”
This is a very exciting video for me and Enterprise DNA. I’m going to showcase a variety of the best Power BI reports that you’ll see out there, and these reports are all created within the Enterprise DNA community through Continue reading “Compilation Of The Best Power BI Reporting Applications We’ve Seen”
Download Excel File: https://excelisfun.net/files/EMT1748.xlsx
Learn how to create a single cell advanced array formula to create a sales report from two tables.
Topics:
1. Intoduction
2. SUMPRODUCT & VLOOKUP formula
3. FILTER & XLOOKUP formula
4. Sumamry and closing
Having a documentation system in Power BI is something that I think is often overlooked. Power BI is heavily positioned as a business analytics tool; so for some of us coming from a more technical IT or Programming background, we Continue reading “Power BI Challenge 13 – Acing Your Documentation In Power BI”
In this tutorial, I’d like to continue our Power BI Best Practices series with Volume 4 where I’ll be talking about my best practices for reports and visualizations. I’ll be splitting this particular volume into 2 parts. These are some Continue reading “Reports & Visualizations Pt. 1 – Power BI Best Practices Vol. 4”
You have a column of cells with a year range, such as 2016-2020. How can you break those years out to new rows, so you have 2016, 2017, 2018, 2019, 2020. This Dueling Excel video uses VBA, Power Query, and Continue reading “Expand Year Range To Individual Rows – Duel 195”
You’ve seen the preview on Leila’s channel and Mynda’s channel, but now the Visio Data Visualizer has reached general availability. Create Org Charts, Flow Charts, Swim Lane Charts, Cross Function Process Charts from Excel data. This add-in is designed Continue reading “Excel Visio Data Visualizer Reaches General Availability – 2375”
In this video, I’ll continue discussing my best practices for reports and visualizations. This is Volume 4 of the mini series we’ve made about Power BI Best Practices. This particular volume is split into 2 parts. These are some of Continue reading “Reports & Visualizations Pt. 2 – Power BI Best Practices Vol. 4”
Today, we do a deep dive into a question about how to dynamically subset table visuals in Power BI based on slicer values. We’ll tap on a bunch of interesting elements including disconnected tables, slicer harvesting, slicer visualization tricks, virtual Continue reading “Dynamically Subsetting Table Visuals In Power BI”
In this video, I want to showcase how collaboration can produce one of the most incredible reports I’ve seen in Power BI. This particular work was created by a group of Enterprise DNA experts better known as “JMAP”, as their Continue reading “How Collaboration Can Produce Amazing Reporting Applications In Power BI”
In this video, I’ll demonstrate how you can create a dynamic filters menu to increase the user experience in your Power BI reports. There are a lot of options in Power BI, you can have filters shown on the page, Continue reading “The Ultimate Dynamic Menu In Power BI”
It is like the Christmas where you got almost every thing you asked for. The Excel team has given us almost everything I asked for with the new data types. You can now create your own data types in Excel, Continue reading “Yes!!! Define Your Own Linked Data Types in Excel! Episode 2378”