What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong! Check out this post to learn when and why you should use the pound sign in your formulas.
Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.
The new Excel LET function can make your formulas easier to read. PLUS it can improve the performance of your formulas so they run faster. How should you use this function and does it really make your files faster?
Are you up for a really cool trick with Excel's new FILTER function? With this, you can get multiple match results from non-adjacent columns in a simple, dynamic way! You can also use it to get unique values from different columns. Check out the full article.
Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything