Hello Excellers welcome back to another #Excel #FormulaFriday in my 2021 series. Today I want to show you how to extract the first letter of a first and second name without using Excel formulas. We can use the Excel Flash Fill feature to do this for us. So, yes Excel will do this for you without a formula or function in sight. Here is a sample of my data set. I have highlighted the column I want to populate with the Sales Person's initials. To get Excel to populate … [Read more...]
How To Use The Excel GETPIVOTDATA Function.
Hello Excellers, welcome back to another #Excel #FormulaFriday blog post in my 2021 series of Excel formula tips. So, due to a colleague asking about the GETPIVOTDATA function (which seemed to cause some confusion) I thought it was time to walk through GETPIVOTADATA . I therefore will use a sample Excel Pivot Table. So, read on to solve the GETPIVOTDATA issue. What Is The GETPIVOTDATA Function?. Have you heard of the GETPIVOTDATA function in Excel?. If you look up the Function in the … [Read more...]
Formula Friday – 3 Ways To Protect Your Excel Formulas
Hi Excellers, this is a different #formulafriday in my Excel 2020 series. I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you don't want anyone to mess up it up. So there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet. Here are my top 3 ways to protect your Excel Formulas!! Hide themLock CellsHide The Formula Bar With Some Simple … [Read more...]
Show Value And Percent In Same Report- No Formulas!
Hello, Excellers. Welcome back to one of the last #FormulaFriday Excel blog posts of 2020. Often you will need to display a value as well as percent in the same report. So, more formula (or no formula in this blog post) fun. Today I will show you how to avoid using formulas to do this! Yes, that is right it's not formula Friday really. We go back to one of the best tools in our Excel took kit, the Pivot Table. So, let's quickly build a Pivot Table using a sample data set. A … [Read more...]
Formula Friday – Easily Identify Cells That Begins With A Specified Letter in Excel
Hello, Excellers. It is Formula Friday time again!. Do you need to identify with conditional formatting cells that begin with certain letters?. Today I will show you how Excel can easily identify cells that begin with a specified letter. To highlight these cells, we can use Conditional Formatting to help identify the cells that meet our criteria. All we need to do is use two Excel functions. We can use the LEFT and the LEN Function. Let's take a recap of the syntax of both of these … [Read more...]
- 1
- 2
- 3
- …
- 52
- Next Page »
Recommended Excel Resources
