Category: Excel

LET – Names in Formulas – Generally Available

Earlier this year we announced the release of a new function, LET, which allows you to give names to calculations or expressions in your formulae (Announcing LET). As of earlier this month, the LET function is now generally available within the Product…

LET – Names in Formulas – Generally Available

Earlier this year we announced the release of a new function, LET, which allows you to give names to calculations or expressions in your formulae (Announcing LET). As of earlier this month, the LET function is now generally available within the Product…

Announcing Power Query Data Types

We are excited to announce a new and exciting update to Get & Transform Data capabilities in Excel – Power Query data types! This tool will help you organize your data better and consume it easily.
 
Power Query data types are available as par…

Excel MVP Blog Roundup

This week’s blog roundup brought to you by Excel MVPs Chandoo and Jeff Lenning.
 
ChandooJeff Lenning
 
6 Must Know Line Chart variations for Data Analysis, Chandoo
6 line chart variations that every business analyst and data person should kn…

Welcome to the Day of Data visualization challenge!

Here is an opportunity to showcase your visualization skills to the rest of the community by answering one or more of our space-themed challenges!
The challenge will run from October 17th (World Spreadsheet Day) to November 2nd (the 20th anniversary of…

Excel MVP Blog Roundup

This week’s blog roundup brought to you by Excel MVPs Ajay Anand, Mourad Louha, and Ismael Romero.
 
Ajay AnandMourad LouhaIsmael Romero
 
How to Connect Excel Tables, Ajay Anand
Ajay shows how to build relationships between tables using Data…

Celebrate World Spreadsheet Day with the Day of Data!

We are excited to partner with NASA to bring you the Day of Data, where you can explore how data powers our astronauts, our space missions, and our world. Celebrate World Spreadsheet Day and 20 years of humans living and working aboard the Internationa…

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…