This Guest Post is contributed by Aprajita Sharma from ExcelChamps. Learn about 3 new charts available in Excel 2019 (or with a Office 365 subscription). (more…)
Tips
Once again I discovered a formula that I had written down in a notebook. What is it doing? Is there an easier way to solve this? (more…)
I’ll show you the weighted average formula, how it calculates, and I’ll prove that the answer is correct! (more…)
So many times vlookup (or index & match) saves the day and gets your answer! ….wait…are you sure it’s correct??? Read this post to see why you should use countifs to confirm your vlookup. (more…)
Before you analyze your data it’s important to decide if you need to unpivot it. Why unpivot? What’s unpivot? Are there exceptions? (more…)
Rearranging data is initially about recognizing the pattern. This screenshot is from Ken Puls. I instantly saw the steps to rearrange the data (thanks to Ken’s online course!) (more…)
Excel users who don’t know this concept waste hours manually looking through their data. A filter helps but creating a valid lookup key is what Mr Carlson needs! (more…)
Dynamic charts automatically adjust when new data is added in Excel. I’ll show you several ways to create dynamic charts and a few bonus tricks. (more…)
HOW DO WE SOLVE THIS PUZZLE? I’m 7 times as old as Lisa is now. In 20 years Lisa will be just half the age I will be then. How old is Lisa now? (more…)
Do You Excel?
