๐ Need to check if Excel cells have the same value?
Save time with these 5 quick & easy methods! โ ๐
From formulas to conditional formatting, this guide will supercharge your Excel skills! ๐
Read now ๐ https://t.co/lQLb01ncaq
#Excel#ExcelTips
Today, I have something for all of you working in finance: Do you sometimes calculate an internal rate of return (IRR)? #Excel provides two functions: IRR and XIRR. Which one should you use?
https://t.co/3kpd9OAsse
Our founder, Henrik, got interviewed by @FinStrategists. Read the full interview here and get to know, how Professor Excel started!
https://t.co/b3YpTVmvh2 #interview
Quick #Excel tip for the start of the week: How to paste a copied cell to visible cells only - skipping all filtered out or hidden cells in-between.
https://t.co/O9cby445z3
Quick #Excel tip for the weekend: Use Center Across Selection instead of merging cells. Here is how to use it and how to speed it up!
https://t.co/zLIIsUwa4A
For the weekend a rather funny #Excel fact: Excel wrongly assumes the year 1900 to be a leap year. So, if you type 2/29/1900 into a cell, it will actually be recognized as a valid date.
Excel has this "bug" since the early versions of Multiplan / Excel.
Today (11/12/2021) is day 44512. If Microsoft now removes the wrong 2/29/1900, all consecutive days would calculate -1.
Microsoft says: "Because most users do not use dates before March 1, 1900, this problem is rare."