Hello Excellers, welcome back to another #macromonday blog post in my 2019 series of Excel tips. I want to share with you an easy Excel macro which hopefully will save you some time when preparing...
Tag: Excel Tips
When you are working with data in Excel, you may often find yourself needing to combine the results of two or more separate cell formulas into a single cell. This process is called concatenation. In...
Formula Friday – 3 Reasons To Use Named Ranges In Your Excel Formulas
Hey Excellers, thanks for joining me for another #formulafriday. Today I want to share my top 3 reasons to use named ranges in your formulas. There are many benefits to using named ranges in your...
Hello Excellers and welcome back to another blog post in my Excel tips #Excel #FormulaFriday blog post in my Excel series. A lot of systems (mainframe usually) use Julian dates. This blogpost will...
Formula Friday – How To Easily View Your Formulas With FORMULATEXT Function In Excel
This handy function is available from Excel 2013 onwards, unfortunately it is not available for earlier versions of Excel. Sorry guys..... but if you do have Excel 2013....here you go......
Macros Mondays – How To Attach A Macro To Command Button In Excel
Time for another #macromonday, welcome. Today let's look at saving even more time in Excel by attaching that great macro you have written to a button on your worksheet. The Macro can then run...