How To Convert Date Formats In Get And Transform/Power Query – Excel Power Tip
Hello Power Excellers. In this blog post, I want to share with you two ways to convert dates in Excel Power Query. Why are there multiple ways?. Well one of them uses and Menus available on...
How To Write An Excel Macro To Log Changes To An Excel Workbook – Macro Mondays
Do you like a bit of Big Brother?. Or do you just want to know if someone has changed something on your Excel worksheet? Either way, here is how to track and document changes to an Excel workbook...
Hi Excellers. Today it is time for some more formula fun. Here is one way to display percentages and numbers together in one column that are currently stored in separate columns on a worksheet,...
Excel Tip – Insert The Contents Of A Cell Into A Text String – Formula Friday
Welcome back to another Excel #formulafriday blog. Today I want to share with you a nice handy Excel tip using a well-known formula. Let's learn how to insert the contents of an Excel cell into a...
Write An Excel Macro To Display A Message When Data Has Been Updated- Macro Monday
Hello Excellers. Welcome back to another #macromonday blog post. I want to show you how to write an Excel Macro which will display a message when data has been updated. So how will this be...
Hello and welcome back for some more #formulafriday formula fun. Today let's look at how to calculate the exact dates that your excel reports are due. We can do this with two formulas. The...