Formula Friday – 5 Ways To Double Check Your Excel Formulas.
Hello Excellers. I am excited to share with you some more Formula Fun, and in particular a checklist to double check your Excel formulas are on point!. Let's face it, formulas are awesome, but...
Hi Excellers, welcome to another Formula Friday. Today I want to share with you a really quick way to tidy up your data and get rid of those pieces of data or indeed swap out pieces of data you do...
Macro Mondays – Mail Your Active Workbook As An Attachment With An Excel Macro
Hello Excellers, I am going to share what I think is one of my favorite Macros to date. It emails the active workbook as an attachment from Outlook. How often do you send the same updated...
Formula Friday – Highlight Overdue Tasks With Conditional Formatting And A Logical Formula
Have you started the New Year with some new good habits, maybe you are tracking your To Do or Task List in Excel (why wouldn't you?). Here is a great way to highlight overdue tasks, using...
Macro Mondays – How To Prevent A Workbook Closing Until A Cell Is Populated By The User
Hello Excellers and welcome to another Macro Monday blog post. Today let's look at forcing a user to populate a specific cell in the workbook before they are allowed to close it. If you want...
Formula Friday – Easily SUM Values From Different Excel Sheets With The Same Cell Address
Time for some more Friday Formula Fun. Today we are looking at the good old SUM function, but we are going to use it to SUM the values from the same cell in multiple Excel worksheets. What does...