Macro Mondays – A Quick Macro To Refresh All Pivot Tables In Your Excel Workbook At Once
Hello Excellers and welcome to another blog post in my #macromonday 2019 series. It is time for some easy Macro writing today. Today's Excel macro is really small but very useful. Let's write...
Use The EXACT Function To Force Upper Case Data Entry Into Excel
Hello Excellers, a warm welcome back to another #formulafriday blog post. in my 2019 series. The Excel formula tip today is a recent favorite of mine at the moment, trying to get users to enter...
Formula Friday- Prevent Duplicate Data Entries With COUNTIF Formula And Data Validation
Happy Friday!...time to Excel with another #formulafriday blog post in this series. Today let's take a look at how to prevent duplicate name or employee ID numbers in a worksheet. So, how do we...
Formula Friday – FLOOR Function In Excel- Find Out The Decade That Song Was From
Happy Friday Excellers and welcome to another #formulafriday blog post. I found this little Excel formula out by accident. I was trying to find out what decade a date was from and thought it may...
Hello and welcome to yet another #formulafriday blog post. I want to share today with you an Excel formula problem a colleague of mine asked me to look at a week or so ago. So, I thought it would...
Macro Monday – A Macro To Sort your Excel Sheets Alphabetically By Name
Hello Excellers, I am happy to bring you another Excel Macro Tip today in the #macromonday blog post series. This macro is one that I use a lot at work - Sorting my Excel sheets alphabetically by...