Category: Excel

Excel MVP Blog Roundup

This week’s blog roundup brought to you by Excel MVPs Leila Gharani, Bill “Mr. Excel” Jelen, and Cristiano Galvão.
 
Leila GharaniBill “Mr. Excel” JelenCristiano Galvão
 
Excel Filter Trick Using Non-Adjacent Columns, Leila Gharani
Leila Ghar…

Spreadsheet Day Celebration – Oct 14, 5 PM ET

Spreadsheet Day Celebration – Oct 14, 5 PM ET

Did you know October 17 is Spreadsheet Day?  Learn more about its history from Excel MVP Debra Dalgleish, founder of Spreadsheet Day.
 
To celebrate this year’s Spreadsheet Day, the Toronto Excel User Group, led by Excel MVP Celia Alves, is h…

Excel MVP Blog Roundup

Excel MVP Blog Roundup

This week’s blog roundup brought to you by Excel MVPs Paula Guilfoyle, Ron de Bruin, and John MacDougall
 
Excel Hidden and Very Hidden Sheets – What’s the difference?
Paula Guilfoyle explains the differences between hidden and very hidden wo…

Excel MVP Blog Roundup

Excel MVP Blog Roundup

This week’s blog roundup brought to you by Excel MVPs Charles Williams, David Abiola, and Yolanda Cuesta
 
Backward Compatibility of Dynamic ArraysCharles Williams offers an in-depth discussion of dynamic array backward compatibility
 
L…

Excel MVP Blog Roundup

Excel MVP Blog Roundup

This week, MVPs Mynda Treacy, Tony de Jonker, and Alan Murray share their Excel knowledge with us
 
Excel PivotTable Profit and LossMynda Treacy shows how to create an easy-to-read interactive profit and loss statement in Excel using PivotTab…

Microsoft Excel at Ignite 2020

Microsoft Excel at Ignite 2020

Experience a reimagined Microsoft Ignite as a digital event this year, Sep 22-24.  Connect with Microsoft experts and your world-wide community like never before.
 
This year, we’re excited to share our modern Excel story in the context of in…

Excel MVP Blog Roundup

Excel MVP Blog Roundup

This week, we bring you more Excel knowledge from MVPs Chandoo, Jan Karel Pieterse, and Jeff Lenning.
 
Power Query Tutorial – What is it, How to use, Full examples, Tips & Tricks
Chandoo shares a tutorial on Power Query in Excel, includi…

Excel MVP Blog Roundup

Excel MVP Blog Roundup

This week, we bring you recent articles by Excel MVPs Mourad Louha, Ismael Romero, and Frederic Le Guen.
 
Datentypen aus Power BI in Excel abrufen (Get data types from Power BI in Excel)
Excel MVP Mourad Louha describes his first experience with …

Excel MVP Blog Roundup

Excel MVP Blog Roundup

Excel MVPs are Excel experts who passionately share their knowledge with the community. They’re deeply knowledgeable of Excel and use that knowledge to solve real world problems. They’re driven by their passion, community spirit and quest for knowledge…