Microsoft is releasing a new look for the Excel Quick Access Toolbar and Ribbon. The feature is rolling out slowly to beta Insiders now. Here is a first look at the QAT and Ribbon.
Category: Excel
Sort One Column Challenge In Excel – 2413
A question from Quora: Can you sort one column in an Excel table using the Filters and not sort the other columns? This would be easy if it was a range. But it you press Ctrl+T, I am not sure Continue reading “Sort One Column Challenge In Excel – 2413”
UNIQUE of Rectangular Range Using MAKEARRAY in Excel – 2416
Another new LAMBDA helper function in Excel is MAKEARRAY. This video shows a simple example, and then tackles the problem from episode 2317 of how to unwind a rectangular range into a single column so you can pass it to Continue reading “UNIQUE of Rectangular Range Using MAKEARRAY in Excel – 2416”
PRODUCTIF With MAP REDUCE or SCAN – 2416
Three more of the new Lambda Helper functions in Excel: MAP, REDUCE, and SCAN. In today’s episode, see three different ways to create a PRODUCTIF function in Excel using MAP, REDUCE, or SCAN.
Important points:
MAP can take one or more arrays.
MAP Continue reading “PRODUCTIF With MAP REDUCE or SCAN – 2416”
Excel First Look At Lambda Helper ByRow And By Col 2415
A first look at the new Excel functions BYROL and BYCOL. These functions, released to Insiders Fast this week are designed to be used with LAMBDA functions.
Read more about the 7 functions here:
https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-helper-functions-lambdas-as-arguments-and-more/bc-p/2587253#M2240
Is Power Query…..? | Google’s most asked questions on Power Query
Good Monday everyone!
In today’s video, I will answer Google most asked questions on Power Query. Enjoy!
Chapters:
00:00 Intro
00:16 Is power query free?
01:00 Is power query available in Excel 2010?
01:30 Is power query available for mac?
01:50 Is power query an ETL tool?
02:20 Continue reading “Is Power Query…..? | Google’s most asked questions on Power Query”
Creating Power BI Themes in Canva
For today’s video, I’d like to show how you can use and maximize Canva in creating custom Power BI themes. Canva is a graphic design and publishing platform that allows you to create visual artworks, presentations, and documents with easy-to-use tools Continue reading “Creating Power BI Themes in Canva”
Intro To Power Query/M Masterclass – Brand New Course
Continuing on our promise to provide new courses every month, we’ll be releasing one of our highly anticipated courses of the year – the first installment of Power Query/M Masterclass developed by our in-house Power Query expert, Melissa de Korte. Join Melissa, Continue reading “Intro To Power Query/M Masterclass – Brand New Course”
Where To Get Demo Data For Example Reports And Power BI Applications
For today’s video, I want to show you different ways how you can get a hold of demo data to practice running analysis and apply techniques that you’re learning from our channel and also through our education platform. You’d want Continue reading “Where To Get Demo Data For Example Reports And Power BI Applications”
eDNA Community Event (Member-Only)
EVENT DETAILS – https://enterprisedna.co/enterprise-dna-community-event/
When is it?
June 28th, 5pm New York (EDT), 2pm Los Angeles (PDT), 10pm London (BST)
June 29th, 7am Sydney (AEDT), 9am Auckland (NZDT)
How long is it?
Session will run for 60 mins
Where is it?
Join in from Continue reading “eDNA Community Event (Member-Only)”
Old Guy BMX Park & Racing in Same Day = Rad!
Excelisfun, aka Magic / Gel, gets rad with the Old Guys: BMX racing and BMX Park in the same day.
Peninsula Indoor BMX Track and Port Orchard Skate-BMX park hit in the same day in Port Orchard, WA. Old Guys Mike Continue reading “Old Guy BMX Park & Racing in Same Day = Rad!”
Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
Download Excel File: https://excelisfun.net/files/EMT1727.xlsx
See three formulas to lookup nth value:
1. (00:00) Introduction
2. (00:32) Formula #1: Microsoft 365 with INDEX and FILTER functions.
3. (01:31) Formula #2: Excel 2010 or later: AGGREGATE, ROW and INDEX functions.
4. (03:47) Ctrl + Continue reading “Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.”