Hello, Excellers welcome to another blog post in my 2019 #FormulaFriday #Excel tips series. Today let's take a look at creating a formula or a calculation within an Excel Pivot Table. If you...
Tag: Excel
Hello, Excellers and welcome back. It is Friday Formula time again. Today's post will look at how to use wildcards in a VLOOKUP formula. Let's begin with an example to demonstrate the...
Add 5% to my Sales Targets Without Using Extra Columns Or Cells
Hello, Excellers. welcome to another blog post with an #exceltip in my 2019 #formulafriday series. Today I want to share with you how to carry out a calculation with no excel formula, and no...
Excel Formula Friday – Using Find And Replace To Quickly Change Formulas
Welcome Excellers to another #formulafriday blog post. Today let's take a look at how to quickly change your Excel formula without having to rewrite any of those formulas. I have...
Happy Friday Excellers. Time for some more Formula Fun. Today I want to show you how to use SUMIF in Excel to sum only the POSITIVE numbers in your data set. Let's take an...
IHello Excellers, welcome back to today's #excel #macromonday blog post in this 2019 series. Today I will show you how to add your own Excel macros you have written to the ribbon. With Excel...