Excel MVP Blog Roundup

This post has been republished via RSS; it originally appeared at: Excel Blog articles.

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.

 

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.