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...
Recent Posts
How To Create An In Cell Bar Chart Using The REPT Function In Excel -Formula Friday
Hello Excellers it is Friday again and time for #formulafriday where we have some Excel formula fun. Have you used the REPT function in Excel or ever used it?. It's a bit elusive so let's get it...
Hello Excellers, welcome to another #macromonday blog post in my Excel series. If you're an Excel user, there's a good chance you've had to convert text to numbers at some point. Maybe you needed to...
Formula Friday- Two Ways To Create A Time Stamp In You Excel Workbook
Do you need to create a timestamp in Excel? You have two methods to choose from. In this blog post, we'll show you how to do it with each method. Read on to learn more! This really is THE most...
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...