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 Tips
Hello, Excellers welcome to my next blog post in my #MacroMonday #Excel tip 2019 series. Today lets' look at how to create a quick and simple Excel VBA macro which will highlight all cells that...
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...
Welcome back Excellers to another blog post in my #macromonday 2019 series. Today we will create an easy Excel VBA macro to highlight negative numbers easily with conditional formatting. This will...
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...
Hello, Excellers welcome back to my blog for another #macromondays #exceltips blog post in my 2019 Monday Series. Today lets look at creating a list of unique values. We will make this lightning...