Get word list and count from a column in Excel - use for word cloud |

Split data in a column into individual words, remove duplicates, remove unwanted characters and count the occurrences of each word. All using the Excel 365 new functions like Reduce, Lambda, Let, TextJoin and more
You can use it to create word clouds or other types of lexical analysis like text mining, word frequency analysis, natural language processing and more.

Download sample file
https://efficiency365.com/wp-content/...

Contact Dr Nitin to transform work efficiency in your organization.
Send a mail to [email protected]

#excel #wordcloud #arrayformula #lambda

Contents 📚
00:00 - The Need
00:40 - The solution
00:51 - Unique word list
01:11 - Let function example
02:55 - Substitute function
03:35 - Reduce function
04:21 - Lambda function
06:29 - Textjoin
06:45 - Text Split
07:09 - Remove duplicate words
07:55 - Combine Words and Counts
08:34 - Choose to combine lists
10:29 - Practical use


Related videos 📺
Apply Excel chart templates - Macro -    • Apply Excel chart templates - Macro |...  
Three must have add-ins for Excel -    • Three must have add-ins for Excel | @...  
Microsoft Forms to Excel - live update -    • Microsoft Forms to Excel - live updat...  
Scanned PDF or picture to Excel data -    • Scanned PDF or picture to Excel data ...  
4 ways to open multiple Excel files instantly -    • 4 ways to open multiple Excel files i...  
7 New Excel Features -    • 7 New Excel Features | @efficiency365  
Write data using stylus in Excel - Action Pen -    • Write data using stylus in Excel - Ac...  
Excel PivotBy function - use multiple fields in rows and columns -    • Excel PivotBy function - use multiple...  
Excel - Find Replace Formatting -    • Excel - Find Replace Formatting | @ef...  



Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape  
Twitter :   / drnitinp  

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)