I really do not recommend too many Excel products or courses (as you can probably see from my site), and I have a few rules that I apply when paying for either an Excel product or a Course for...
Posts by Barbara
Find The Excel Cell Address Of The Maximum Number In Your Data Set
Hello Excellers, welcome to another blog post in my #Excel Tips, #FormulaFriday 2019 series. Today, let's take a look at how to find the address of the cell that contains the maximum number in your...
Hello, Excellers and welcome back to another #MacroMonday blog post in my#Excel 2019 series. Today let's look at how to update or calculate only selected or specific cells in your Excel worksheet. ...
Formula Friday – SUM Only NEGATIVE Numbers In An Excel Range Using The SUMIF Function.
Happy Friday Excellers. It's #formulafriday time therefore time for another blog post in my Excel series. Today let's look at counting all of the negative values in a data range. This formula is...
It's that time again folks. Time for some more #MacroMonday fun. Today I want to show you how to write a simple #Excel macro that will take a sentence (or a load of text) and split it into...
Add Decimal Places To An Existing Data Set – No Formulas Needed.
Hello, Excellers welcome back to more #FormulaFriday #Excel fun. Today let's look at how to add decimal places to a dataset of existing numbers. Really quickly. (Without using a formula). Here is...