Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel 2020 series. Today I will show you two ways in which you use Column and Row labels as named ranges. About...
Tag: Excel Tips
Hello Excellers. Today I will share with you a great Excel tip. How to remove really quickly duplicate data records using Power Query. Power Query (previously called Get & Transform) in...
Excel is a powerful tool for data analysis and presentation. With its built-in formulas and functions, you can create complex reports and graphs with just a few clicks. However, even the most...
Formula Friday- Are We There Yet? Are We There Yet How Close To Your Goal Are You?
Hello Excellers and welcome back to my #Excel #FormulaFriday blog post in my Excel 2020 series. Today's formula calculates how far you are from a goal. This is sometimes referred to...
Hello Excellers, welcome back to another Excel tip today. I will show you how to create a self-expanding chart. This tip is also a YouTube Video. Why not check it out in the...
Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today's blog will show you all you need to know about how to use Absolute (and Relative)...