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...
Recent Posts
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...
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my Excel 2020 series. Today I will show you how to write some Excel VBA code that will hide all of your Excel worksheets...
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 and welcome back to another #McaroMonday #Excel blog posit in my Excel Macro 2020 series. Today I will show you how to write some code that will allow you to check if an Excel folder...