Do you want to make impressive looking and functioning Excel workbooks without...
read more
7 Ways To Find And Remove Duplicate Values In Microsoft Excel
In this tutorial we are going to look at 7 easy methods to find and remove duplicate values from your data.
The Complete Guide To Microsoft PowerApps
Learn about the Microsoft PowerApps drag and drop formula based app building platform. Quickly build useful business apps using the intuitive PowerApps visual builder that doesn’t require traditional coding.
Everything You Need To Know About Flash Fill In Microsoft Excel [15 Examples]
In this post you're going to learn everything you need to know about Flash...
The Complete Guide to Rich Data Types in Excel
Learn all about rich data types in Excel and how to use them to get more from your data such as current financial data, currency rates, cryptocurrency values and geographical data with just a couple clicks.
5 Ways To Change Text Case In Excel
Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.