Formula Friday- Using The Convert Function To Calculate How Long My Task Will Take.
Hello Formula Friday Excellers, today let's look at a really handy formula to help us calculate how many hours a total task from start to finish will take. The whole task is made of a lot of mini...
Formula Friday – How Excel Calculates – The Order Of Excel Calculations
If you plan on writing formulas in your Excel spreadsheet- I am assuming you do want to use Excel for calculations at this stage :-) then knowing the order of precedence or that Excel performs the...
Formula Friday- Always Add The Last 3 Values In Your Data Set Using The Offset Function
Happy Friday...More #FormulaFriday Fun for you. Today let's look at how to always add the last 3 values in your data set. This formua is one that I have used for always returning the sum of the...
In a previous Formula Friday Blog Post last week, which you can see here I went through 3 methods to enter formulas into Excel, some quicker than others, and I challenged readers to try methods 1 or...
Friday again Excellers, and today we are going use the COUNTIF function and get Excel to automatically to check how many classes students have signed up for ...or....simply ..count how many times a...
Formula Friday -Using The Workday Function To Calculate Status Of An SLA
I dont know about you, but our IT department at work has an SLA turnaround time of 8 days. That is 8 working days, so we can't really chase them for any updates until that time has elasped. ...