Formula Friday – Whats The Difference Between An Excel Formula and A Excel Function?
Let's get back to basics today in #formulafriday and discuss something I am asked quite frequently about...... What is the difference between a Formula and a Function in Excel? If you use Excel as...
Hello Excellers, Friday again and I have a really quick, easy and really useful way to use named ranges you have already created into your formulas. If you need more details on creating named...
Formula Friday – View All Of Your Calculated Fields And Items Contained In Your Excel Pivot Table
Welcome, Excellers. Almost everyone who has used Excel has had to work with Pivot Tables at some stage. I will show you how to list all the calculated fields and items in your Pivot table in today's...
Formula Friday – 3 Ways To Remove Days From A Date In Excel To Leave Just The Month And Year
Hello again Exellers, today let's look at 3 ways to remove the Days portion from a date in Excel. This was an issue one of my collgeaues came across this week. Let's take a look at the...
Formula Friday – Auto Sum Packs A Punch With This Cool Trick
Friday again, time for #formulafriday. You can download todays example here. [wpdm_package id='9896'] Ok, so you are probably saying AUTOSUM, really?. Whats special about that then?. ...
Formula Friday – Generate Random Odd Or Even Numbers With RANDBETWEEN
Happy Friday Excellers. Today let's look at RANDBETWEEN to generate some random numbers, but we can combine the function with others in Excel which is exactly what we are going to do today. This...