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 a rather large calculator then you have probably used it to do something like this- ( the result being 23) =1+2+4+6+10 or =A1+A2+A3+A4+A5 What you have done in Excel right there in the example above is used a Formula. If you find this useful, then that is great, but Excel is way more … [Read more...]

## Formula Friday – Paste A Name Into An Excel Formula

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 ranges I suggest you take a look at my blog posts below. 3 Reasons To Use Named Ranges In Your Excel Formulas Creating Named Ranges If you want to download the example Excel File used in this blog post then you can do so here If you are happy with named ranges then let's keep … [Read more...]

## Formula Friday – View All Of Your Calculated Fields And Items Contained In Your Excel Pivot Table

Welcome Excellers, Happy Friday and let's have some Excel fun. Today let's look at how to easily see all of your Calculated Fields and Calculated Items that you have created to use in your Pivot Table. After you have added some new Calculated Fields and Items, it can be tricky to keep track of things. We can however see all of our workings and logic with a feature in Excel Pivot Tables that allows us to extract all our Pivot Table Formulas. Here is my basic data set and my Pivot Table I have … [Read more...]

## 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 story. He was trying to analyse his data set by Monthly Sales using a Pivot Table. You can see a sample of the data below. The Pivot analysis looks like this; it analysed data the Day and Month together as expected. He just wants Monthly Sales total though. So, my colleague duly selected all … [Read more...]

## Formula Friday – Use SUMIF To Calculate Total Sales Except One Item

Hello Excellers - #formulafriday again, today let's look at calculating the total sales of all but one item in data list, we can do this with the SUMIF function and instruct Excel to omit the values of the item we specifiy. First let's take a look at the syntax of SUMIF. =SUMIF(range, criteria, sum_range) Where range - this is required and is the data range you want Excel to evaluate criteria - this is required and needs to be in the form of a number, expression, a cell … [Read more...]

- « Previous Page
- 1
- …
- 8
- 9
- 10
- 11
- 12
- …
- 16
- Next Page »