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 – Easily SUM Values From Different Excel Sheets With The Same Cell Address

Time for some more Friday Formula Fun. Today we are looking at the good old SUM function, but we are going to use it to SUM the values from the same cell in multiple Excel worksheets. What does that mean?. Have you ever had the same cell value on multiple Excel sheets in the same workbook, for example having Sales on each sheet, being an individual monthly report, but being combined into one one Summary worksheet?. We can quickly and easily SUM all of the months into the summary … [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...]

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