Excel MVP Blog Roundup

By
Published Aug 28 2020 06:53 AM 2,031 Views
Microsoft

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, and always willing to help each other.

 

We want to start sharing with you some of the knowledge directly from our Excel MVPs:

 

Have You Got What It Text? Introducing ARRAYTOTEXT and VALUETOTEXT

Excel MVP Liam Bastick looks at what he has been able to glean about these welcome new additions to the Excel myriad of functions, features, and formulae.

11 Solid Reasons to Use Excel Tables

Excel MVP Ajay Anand explains 11 advantages of using Excel Tables. There are few bonus tips like the least known shortcut for creating Excel Table, Tables as source data for Dynamic Drop-Down List, shortcuts for Excel Tables, etc.

 

Bereichsvariable in der Funktion LET verwenden (Use Range Variable in the LET function)

Excel MVP Mourad Louha describes with an example how to use the new function LET and shows an interesting feature of this function.

 

Find this useful or want to know more about a specific Excel topic? Leave a comment below.

 

 

1 Comment
Contributor

Great!

Version history
Last update:
‎Aug 28 2020 06:53 AM
Updated by: