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,...
Make Your Excel Hyperlinks Dynamic – Using The Hyperlink Function – Formula Friday
Hello, Excellers. Time for some hyperlink fun in Excel today. If you have been using Excel for a while you probably have used, or have been sent a spreadsheet with hyperlinks in them. These...
How To Write An Excel VLOOKUP Formula With An IF Statement – Formula Friday
Hello Excellers, I am delighted to share another Excel #formulafriday Excel tip with you today. If you have used Excel for some time, you probably know how to use a VLOOKUP formula. If you do not...