exceltips99
@exceltips99
Sharing Excel tips that make complex tasks simple — database-style tables, advanced functions like LAMBDA and spill/dynamic arrays, smoother workflows.
Excel’s LAMBDA function library. The functions it defines look pretty concrete and may not be for everyone, but the way it handles importing functions is worth learning from. Vertex42 LAMBDA Function Library vertex42.com/lambda/
Using INDIRECT or OFFSET in Excel is probably best treated as a last resort. Especially in recent versions of Excel, you can usually get things done without relying on those functions.
If you're still using helper columns or dragging formulas endlessly for cumulative totals… let me introduce you to SCAN + LAMBDA — Excel’s new power combo. Today I used this formula to convert a raw number list into a dynamic cumulative total: =SCAN(0, A3:A1000, LAMBDA(x, y, x…
You replied! Yesss!!! 🥳🎊 - COUNT, COUNTA - XLOOKUP, INDEX, MATCH - SUMIF(S), COUNTIF(S) - AND, OR - FILTER, UNIQUE, SORT, CHOOSECOLS They’re all grouped based on functionality. Oh, lest I forget, no 2025 Excel webinar is complete without a little LET & LAMBDA 😀
Keep formulas in one place with a spill (dynamic array) — prevents cases where a few cells have different formulas.
Show Excel Formulas Without Clicking Each Cell — Here’s How! #exceltips #exceltricks #exceltutorial #microsoftexcel #excelforbeginners #easyclicklearning #excelformulas youtube.com/shorts/xE92sc0…
youtube.com
YouTube
This Hidden Excel Function Shows the Formula — Not the Result!
If I apply to a company and hear they use Google sheet, I’ll run far. Google Sheets una! Na me you want stress
I now understand why some FP&As prefer to use Google Sheets for their financial models. Before, I always thought “why google sheet and not Excel”. But now I understand 🥲 The fact that you can work on your model anytime, anywhere just with your email >>>>>>>>
I only wish their was an open source alternative that even came close to the heavy lifting that Excel provides. VBA, Lambda functions, dynamic arrays, etc etc.
Nice tip! If you’re using Excel on Microsoft 365, you can easily do this using a trim reference and the TAKE function.
How to Get the Last Value from a list in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet
Use LET when you must pack everything into one Excel cell: - temp 2-D workspace for intermediate calcs - prevent blanks turning into 0 - register named functions - make copy-pasteable formulas - have an external AI generate the formula
The LET function in Excel is one that changes how you work. It simplifies long formulas using the DRY program in principle. I’ve made a simple intro video on how to use it. Link: tinyurl.com/2wvuher6 Make me happy: watch, like and drop your questions/comment, if any 🙏
I recorded a video on intro to LET function in Excel. When I post it, make sure you watch, like, comment, repost, retweet, consume, digest, replicate and be mind blown 🫵
My version — I prefer the classical INDEX+MATCH+MATCH approach, which works in Excel 2021 and earlier, rather than XLOOKUP+XLOOKUP. I find the formula easier to read.
Hot take: My Excel hack when getting started is to avoid pivot tables like the plague. Do the hard work, write the aggregation formulas yourself (SUMIFS, COUNTIFS, GROUPBY, etc), learn the backend, build from ground up. Trust me, your excel game will change forever. 💯
First time i learnt and discovered the pivot table on excel felt like I had discovered gold 😂
Excel is the most purely functional of all programming languages — a convenient way to try out functional programming.
When you press Ctrl+C, don’t split the keys between your hands. Instead press both keys with your left hand — Ctrl with your pinky and C with your index finger — so your right hand stays free to operate the mouse. #Excel #ShortcutKey
Excel functions like FILTER and BYROW are fine for beginners to use casually, but if you try to use them seriously they become extremely difficult.
Spill functionality has been available since Excel 2021, but to make full use of it you’ll want Excel 2024, which offers comprehensive array features. Because writing advanced array formulas in Excel 2024 can be difficult for non-experts, I recommend Microsoft 365 for beginners.
In Excel, keep sheet names, table names, and table column names short so formulas are easier to read.
United States Trends
- 1. Greg Biffle 79.3K posts
- 2. Kennedy Center 63.3K posts
- 3. Hunger Games 37K posts
- 4. Muschamp 4,124 posts
- 5. NASCAR 60.6K posts
- 6. #Cookiemas2025 N/A
- 7. Puka 23.6K posts
- 8. Patriot Games 6,852 posts
- 9. North Carolina 54.3K posts
- 10. Jim Hunt N/A
- 11. blackpink 47.8K posts
- 12. Adin Ross 5,567 posts
- 13. Hurricane Helene 15.1K posts
- 14. Parkinson 5,918 posts
- 15. James Caan N/A
- 16. Seahawks ML N/A
- 17. Heartbreaking 52.9K posts
- 18. David Brooks 6,434 posts
- 19. Lincoln Memorial 6,861 posts
- 20. Loveland 1,744 posts
Something went wrong.
Something went wrong.