This article is contributed. See the original author and article here.
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.
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.
Recent Comments