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 Excel VBA macro to un-merge cells in our Excel worksheet. As working with merged cells can be tricky...
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...