This weekend, Fantasy Football teams will be doing their draft. If you are using the ESPN website to manage your draft, the Draft Recap Report could use some formatting.
Download our free Excel template from: http://www.mrexcel.com/download-center/2021/08/BetterESPNDraftRecap.xlsx
Watch the video Continue reading “Better ESPN Fantasy Draft Recap In Excel Free Download – 2426”
Long ago, Excel offered a full screen mode. The Ribbon would completely disappear and you could get the maximum number of rows in the grid visible. The feature was removed in Excel 2013. Today, it is back! At least in Continue reading “Excel Full Screen Mode Returns – Episode 2425”
I have a problem in Excel. About a week ago, the vertical scroll bar on an Excel worksheet stopped working. I lost the scrolling ability from top to bottom. So when I try to drag the right scroll bar from Continue reading “Excel Vertical Scroll Bar Stops Working – 2423”
Download Excel File: https://excelisfun.net/files/EMT1750.xlsx
Learn how to compare to lists and extract items in both lists, or exact the items that are not in both lists. Formula #1: Extract items in List 1 that are in List 2. Continue reading “Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750”
Download Excel File: https://excelisfun.net/files/EMT1749.xlsx
Learn how to use the 7 helper functions for the LAMBDA function. Learn how to use LAMBDA to create a re-usable function, and then how to use LAMBDA as a function value in the Continue reading “7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749”
Kartikey has 6800 rows of data. For each product in column A, he needs every combination of Column B with Column C. In this episode, Bill uses Power Query and a Full Outer Join to solve the problem.
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”
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
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”
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”
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”
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”