Welcome to the September 2026 edition of What's New in Excel!

In this video, Ken explains the different types of blanks that can show up in PivotTables built from the Data Model. You’ll see why measure calculations can return blanks when no rows remain after…

In this week's episode of Monkey Shorts, Ken explores a recipe to fix non-aligned data issues. It all started with a PDF import where data shifted into different columns on different rows. It all…

YouTube video by Ilgar Zarbaliyev

Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with...

**SESSION TRACK:** Excel & Power BI **SESSION OUTLINE:** First, our resident Power BI expert Joseph Yeates will show us what's new in Power BI. Then, Microsoft MVP Wyn Hop

I recently lead some Excel training for a private client, and one of the topics discussed was how to safely and successfully use Artificial Intelligence. Based on that discussion, I thought I would…

YouTube video by Mike Thomas

YouTube video by Curt Frye

In this Vancouver Power BI & Modern Excel User Group meetup, Melissa De Korte presents a deep dive into Power Query splitters and how they can be used to solve more advanced text-splitting challenges…

Have you ever discovered errors in your data after unpivoting? Should you deal with them before you unpivot, or after? Can you remove all errors and still preserve a list of the records which…

**SESSION TRACK:** Power BI & Excel **SESSION OUTLINE:** Joseph Yeates will start things off by showing us some of the latest and greatest in Power BI. Then, Microsoft MVP

YouTube video by Curt Frye

Learn how to unpivot data easily using Power Query in Excel (and Power BI). In this video, Ken shows how to convert a human-friendly report layout into a clean tabular format that works beautifully…

By default, when you unpivot a set of data in Power Query, all null records are suppressed. But what if you need them in your unpivoted data set? In this week's episode of Monkey Shorts, Ken shows…

YouTube video by Skillwave Training

While Power Query has a super easy way to merge columns, there is no easy-to-use user-interface command which allows you to merge multiple rows into a single cell. In this week's episode of Monkey…

**SESSION TRACK:** Excel **SESSION OUTLINE:** AI is changing the way we work with data — but where does it actually fit alongside Excel? In this session, Fay Bordbar will

In this video, Ken shows how the Parameter Table and Function feature in Monkey Tools can automatically add the fnGetParameter() function and the required parameter table setup into your Excel…

YouTube video by Curt Frye

Did you know that when merging columns in Power Query, the behaviour is different depending on whether you trigger the command from the Transform or Add column tabs? (And no, we're not talking about…

**SESSION TRACK:** Power BI & Excel **SESSION OUTLINE:** Joseph Yeates will start things off by showing us some of the latest and greatest in Power BI. Then, Microsoft MVP

Welcome to the August 2026 edition of What's New in Excel!

YouTube video by Curt Frye

In this Vancouver Power BI & Modern Excel User Group meetup, Echo Swinford presents practical guidance for creating clearer, more effective charts and data visualizations. Echo explains how people…

In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.

**SESSION TRACK:** Excel and Power BI **SESSION OUTLINE:** Joseph Yeates will start things off by showing us what's new in Power BI. Then we welcome our feature presenter,