Calculate How Long A Task Will Take Using CONVERT Function – Formula Friday
Hello Excellers, time for some more Excel formula fun on a Friday. What could be better?. In today's blog post let's look at a really handy Excel formula to help us to easily calculate how long...
Formula Friday – How To Count Formula Errors On An Excel Worksheet
Happy Friday and time for some more #formulafun on a Friday!. I recently was asked to find a way of knowing how many errors ( if any) were in an Excel worksheet. I came across this quick and easy...
Pad Numbers With Zeros Using The LEFT Excel Function – Formula Friday
Hello, Excellers welcome to another Excel #formulafriday. Today I want to share with you a solution to a problem that is really quite common and I get asked about from time to time. How do you...
Hi, Excellers welcome again to my #formulafriday blog post series. Today I want to share with you a great little hack for your chart axis labels. If you find yourself with a shortage of real...
Highlight Weekend Dates In Your Data Set. Conditional Formatting Using A Formula – Formula Friday
Hello Excellers and welcome to another #formulafriday blog post. Today let's take a look at using conditional formatting along with an Excel formula to highlight dates in our data set that fall on a...
If you have been using Excel for a while you probably have used, or have been sent a spreadsheet with at least one hyperlink in them. These work really well until the order of sheets is changed,...