VLOOKUP based text grouping in Microsoft Excel
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or
What if you want people to add comments but NOT edit the document itself? That is what I call Adding only comments in Word. This is possible! With just few
Very recently a nice new feature is added to Outlook. @name in Outlook is just like what we do in Twitter. You can just add @ followed by name of
Here is the next installment in the Office 365 Worst Practices series. Office 365 contains many components. For regular users most of these components are new, except one – Office.
Yes. This feature has been requested for years. There were many workarounds. But no direct solution. Now we can Highlight text in PowerPoint just as we can in Word. Simple
Here is a list of articles, in recommended reading order for using Word Styles efficiently. Word Styles Top 3 Efficiency Habits: Use Word Styles, Excel Tables and PowerPoint SmartArt Most
It may not be an obvious usage scenario, but I use OneNote as a presentation tool all the time. It simplifies explanation of complex ideas. Therefore, I thought of sharing
This is a commonly asked question. There is a lot of confusion about exactly what it means. Here is a simple and practical description of What is Office 365 –
Sounds like there is no connection MS Word and SEO (Search Engine Optimization). But there is. One of the parameters which is important while performing SEO is the ease of
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
