How To Find The Minimum Number In A Excel Data Set – Two Formula Options – Formula Friday
Hello Excellers and welcome to my regular blog spot of #formulafriday. Today is really a double edition as I show you two great ways to find the minimum number in an Excel data set using two Excel...
How To Create A Variable Drop Down List In Excel – Formula Friday
Hello Excellers and welcome to another #formulafriday blog post. Today let's look at how to create a variable drop-down list in Excel. That's right to be able to choose a value from one cell, and...
Display An Pop Up Message To Users Opening An Excel File – Macro Monday
Welcome, Excellers and time for another #macromonday. Today I want to share with you how to display we welcome (or any other message) on your Excel workbook when it is opened. I use this small...
Defer Data Updates In Your Excel Pivot Table. – Pivot Table Tip
Hello, Excellers. Today I want to show you a really quick Excel Pivot Table tip that might be very useful for you if you are updating or making changes to a large Pivot Table. You may already...
Hello Excellers, and welcome to some more #macromonday fun. Today, let's look at how to use an Excel VBA macro to unmerge cells in our Excel worksheet. As working with merged cells can be...
VBA Sub and Function Procedures- Explanation and Examples – Macro Monday
Hi and a warm welcome to my Excel blog if this is your first time visiting. A huge welcome back if you are a regular. In today's Macro Monday post I want to chat about the difference between a...