Learn 5 different ways to add the current date or time into Excel with keyboard shortcuts, functions, power query, power pivot and power automate.
5 Ways to Get the Current Date or Time in Excel
read more
DAX | Functions | Power Automate | Power Pivot | Power Query | Shortcuts | Tutorials
Everything You Need To Know About XLOOKUP
There was big news in the Excel world recently. A new replacement for the most...
6 New Functions in Excel 2019 and Office 365 You Must Learn
Microsoft Excel is a Powerful Tool, Period. And once you are loaded with all...
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.
4 Ways to Remove Unwanted Space Characters
Learn how to remove unwanted space characters from text data in Excel using various methods.
The Ultimate Guide To VLOOKUP
The VLOOKUP function allows you to search a value in the left most column of a range and return the corresponding value in a column to the right. The search is vertical from top to bottom and in fact, the “V” in VLOOKUP stands for vertical.
Get The Latest News
Follow Us
Follow us on social media to stay up to date with the latest tips in Excel!