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...
Tag: Excel Tips
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...
Do you need to easily find your most recent Excel workbooks?. Well, pinning seems to be quite popular now with PINTEREST. So, it seems fitting then to share with you an Excel Tip that will allow...