Hello Excellers. I am excited to share with you some more Formula Fun, and in particular a checklist to double check your Excel formulas are on point!. Let's face it, formulas are awesome, but they can can also cause huge headaches even with a tiny mistake, Excel will go ahead and do what you tell it to, so you have to make sure your are giving it the right instructions. Here is a simple checklist to double check your Excel formula work. 1. Are You Mixed Up?..... It is … [Read more...]

## Formula Friday – Tidy Your Data Quickly With A Substitution

Hi Excellers, welcome to another Formula Friday. Today I want to share with you a really quick way to tidy up your data and get rid of those pieces of data or indeed swap out pieces of data you do not want in your data set. Here is an example of this method I demonstrated to an Excel user this week, using the SUBSTITUTE function. But first, let's take a quick look at the syntax of this handy formula. SUBSTITUTE(text, old_text, new_text, … [Read more...]

## Formula Friday – Highlight Overdue Tasks With Conditional Formatting And A Logical Formula

Have you started the New Year with some new good habits, maybe you are tracking your To Do or Task List in Excel (why wouldn't you?). Here is a great way to highlight overdue tasks, using conditional formatting. We can conditionally format one cell based on another cells value, such as highlighting a Task in the Task Name column, if the number of days in the Days Overdue Column is over -6 days. There are two parts to this procedure. 1. Write the formatting rule logic we want Excel to … [Read more...]

## Formula Friday – Write Formulas Faster With Auto Correct In Excel

Hello Excellers, time for some more formula fun, or some fast formula writing fun. Let's look at using one of Excel's features - Auto Correct and put it to another use to speed up Formula Writing. With the Auto Correct feature in Excel, we can specify our own Auto Corrects, essentially we can use shortcuts of text to get Excel to automaticially fill in the beginning of the formula we are wanting to type. For example, let's say we want to type VL and get Excel to auto correct us and type … [Read more...]

## Formula Friday – Calculating The Percent Of Year Completed And Remaining Using The YEARFRAC Function.

Hello Excellers, time for another Formula Friday. Today let's look at calculating the percentage of the year that is completed and that is remaining really easily using the YEARFRAC function in Excel. This figure can be used as a standalone number or calculation for the audience of your report, or used as part of another calculation in your report. Syntax of YEARFRAC YEARFRAC(start_date, end_date, [basis]) Where Start_date this is required. A start date. End_date this is … [Read more...]

- 1
- 2
- 3
- …
- 11
- Next Page »