#DynamicArrays

Upskill Office

@upskilloffice.bsky.social

3 months ago

Intersect - the hidden Excel operator YouTube video by Upskill Office

The intersect operator is a hidden gem in Excel. In this video I break down how to replace complex nested XLOOKUPs with a more elegant solution using just a single space character.
youtu.be/kEr9aJ3age8

#excel #exceltips #exceltutorial #financialmodelling #xlookup #dynamicarrays #intersect

GoatShipMate

@goatshipmate.bsky.social

8 months ago

Using #SVGs to give a hand shaded/sketched feel to bar charts in PowerPoint by generating flexible fill code in #Excel using #DynamicArrays and RANDBETWEEN(). Pretty pleased with this. Learnt a lot getting to this point.

Yaroslav Drohomyretskyi - HowToLearnExcel

@howtolearnexcel.bsky.social

8 months ago

Dynamic Arrays in Excel: Finally Explained for Beginners YouTube video by How to Learn Excel

Dynamic Arrays in Excel — Intro
One formula → multiple results. No more dragging.

If this is new to you, you're right on time.
▶️ Watch now: www.youtube.com/watch?v=R38R...
#Excel #DynamicArrays #HowToLearnExcel

Ken Puls, FCPA, MS MVP

@excelguru.ca

10 months ago

Lambda Array Formulas for Statistical Control Plots | Jon Peltier - VanPUG Excel Ed - Mar 2025 Conventional Excel techniques for generating Statistical Process Control (SPC) charts required more helper columns than chart source data columns. With the a...

If you missed charting legend Jon Peltier's presentation at last week's Vancouver #PowerBI and Modern #Excel meet-up, the recording is now available: youtu.be/FiYEtyLtQCs
We had a great time diving into how to use Lambda #DynamicArrays to create Statistical Process Control charts.
#DataVisualization

Yaroslav Drohomyretskyi - HowToLearnExcel

@howtolearnexcel.bsky.social

1 year ago

RESHAPING Tables with TOCOL and WRAPROWS: Excel DAF Challenge 01 YouTube video by How to Learn Excel

Reshape Tables with TOCOL & WRAPROWS in Excel

Transform messy tables effortlessly! Learn to reshape tables using Dynamic Array Formulas like TOCOL, WRAPROWS, and VSTACK. Ideal for Excel 365/2021 users.

🎥 Watch now: www.youtube.com/watch?v=5GHb...

#ExcelTips #DynamicArrays #HowToLearnExcel

Upskill Office

@upskilloffice.bsky.social

1 year ago

Excel GROUPBY and PIVOTBY functions: What you need to know to use them effectively, pros and cons versus Pivot Tables, and how I managed to crash Excel with PIVOTBY!
youtu.be/eykj3O4XCiQ

#microsoft #ms365 #msoffice #office #excel #groupby #pivotby #pivottables #dynamicarrays

Upskill Office

@upskilloffice.bsky.social

1 year ago

In an upcoming video, an in-depth look at GROUPBY and PIVOTBY, I managed to get one of these functions to repeatedly crash Excel. Something to watch out for!

#microsoft #ms365 #msoffice #office #excel #groupby #pivotby #dynamicarrays

Upskill Office

@upskilloffice.bsky.social

1 year ago

If you need to distribute an Excel-based Gantt chart within your project team, here's one more useful than most of the basic templates available.

youtu.be/5dGEiWbaHYM

#microsoft #ms365 #msoffice #office #excel #gantt #project #projectplan #dynamicarrays