Hi Excellers, time for some more #formulafriday fun. This blog post is based on a question I was asked by a subscriber a few weeks ago and I thought it would be a good share it on...
Tag: Excel Tips
Formula Friday – Easily Add Symbols To Your Excel To Do List Using The IF Function
Happy Friday Excellers. If you use a To Do List in Excel like I do then here is a great way to highlight with some great but easy visualization, the status of your To List Activities. We can use...
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...
Formula Friday – Write Formulas Faster With Auto Correct In Excel
Hello Excellers, time for some more formula fun, or some fast formula writing fun. Let's look at using one of Excel's features - Auto Correct and put it to another use to speed up Formula...
Hello Excellers, time for another Formula Friday. Today let's look at calculating the percentage of the year that is completed and that is remaining really easily using the YEARFRAC function in...