Using Formulas for Data Validation
This is the continuation of the earlier article about Validations. Data Validation using Formula is not very well understood. Hence this article. Try it out and you will immediately know
This is the continuation of the earlier article about Validations. Data Validation using Formula is not very well understood. Hence this article. Try it out and you will immediately know
This is a very old feature. But it is still very useful. Spend 10 minutes to learn where you should use and not use Range Names in Excel.
This is a short article. We know how to hide rows, columns and sheets. Did you know you can hide cell contents as well in Excel? When we want to
Le The more I work with customers, the more I realize that data quality is still a very big problem. Data Validation in Excel is an effective solution to this
Watch this five minute video to understand what we “really” mean by Remove Duplicate Rows in Excel. The default option removes the duplicate rows automatically. Most of us want to
I noticed a spelling mistake in my LinkedIn profile and updated it. I was flooded with hundreds of Congrats messages. Has it happened to you? There is a simple way
Now it does give you WOW, Love and other things in the regular LIKE button, but not a Dislike (Thumbs Down) button. But in the chat window, Facebook does give
Power BI Glossary is a one line description of relevant terms. Jargon free and easy to assimilate. This is actually part of the Power BI Udemy course I am working
PowerPoint Transitions are extremely useful in emphasizing the change from the previous to the next slide. We have already seen how to learn all the transitions quickly. In this article,
Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
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.
