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
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,
Amazing presentation with few clicks using PowerPoint Morph PowerPoint Morph is a revolutionary feature. It eliminates the need for complex animation. Technically speaking, PowerPoint Morph is a transition, but
I posted this blog article about flying a plane using PowerPoint few days back. Just realized that all the effort I put in to animate that thing is not necessary!
Just finished a one-week tour of New Zealand. Covered 20 customers and 1100+ users. During the session for Air New Zealand, I promised them that I will write a blog
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.
