Sheet Sensei

Ever wanted to calculate moving average in Excel? Use the Average and Take function to do it in less than a minute. #excel #msexcel #excel365

Is this a late post? Maybe it would have been if I posted three weeks ago! But here it is: I’m incredibly happy and grateful to have been renewed as a Microsoft MVP for the second year. Huge thanks to Cuong Pham for the nomination last year. I'm thrilled to keep sharing all things Excel with millions of people and learning something new every day. #mvpbuzz #Excel #microsoft

Say goodbye to boring charts 👋 Create Target vs Actual charts in less than a minute 😎 Don’t forget to share it with your work bestie 👩💻 #microsoftexcel #office365 #exceltip

#100 What’s the deal with Excel errors? I mean you’re just entering your data while sipping your lukewarm coffee and feeling like a number-crunching wizard and BAM! Excel hits you with an error message that might as well be in ancient Greek. You've got #DIV/0!, #NA, and my personal favorite, ###### - like it’s 2020 where throwback Thursdays is still a thing on Instagram. But, fear not, decoding Excel errors is not as difficult as decoding what your partner wants for dinner on Friday night. 1) ###### Error Behold the mysterious hashes—like a secret code from the Illuminati! When your cell screams #### it's just that Excel wants some space because your column is too narrow. Solution: Double-click the column border, and voilà! The column adjusts like magic. Or just stretch them manually like you are prepping them for a yoga class. 2) #CALC! Error This error pops up mostly when you are working with array functions and want Excel to perform beyond its current capability. Solution: Take a deep breath and review your array formulas. Check they’re correctly defined and there are no missing cell references. And remember, no empty arrays are allowed. 3) #DIV/0! Error The classic “trying to divide by zero”. It’s like sticking to your New Year's resolutions till March. Spoiler alert: That’s impossible. Solution: Use an IF statement to handle this division gracefully and just say NA if denominator is zero. Example: =IF(A3=0, “N/A”, B3/A3) 4) #N/A Error The unicorn of spreadsheet errors. It indicates the value you are looking for is not available or can’t be found. This is Excel’s way of saying “Your Lookup game needs to level up”. Solution: It’s time to check your data sources. Use IFERROR and ISNA to handle the error. We'll dive into a few more common errors in the next post. Until then, keep your functions clean, your references valid, and for the love of long weekends, don't divide by zero. #microsoftexcel #msexcel #exceltips