Excel 2016 and beyond versions of Microsoft Excel contain nine components that are backbone of "Modern Excel". We share "Modern Excel" knowledge.TheModernExcel.com DubaiJoined August 2020
𝗜𝗙𝗦 𝗼𝗿 𝗡𝗲𝘀𝘁𝗲𝗱 𝗜𝗙
Which is easier/better?
Excel Function 𝗜𝗙 is powerful. Combining IF with another IF, called 𝗡𝗲𝘀𝘁𝗲𝗱 𝗜𝗙, facilitates conditional logic. To reduce complexity, 𝗜𝗙𝗦 function was introduced in Excel 2016.
themodernexcel.com/Downloads/IFS.…#Excel
Excel Table is the foundation of Slicers, Data Model, Measures, Power Pivot, Power Query, & Power BI work
Yet, 95% of Excel users in Organizations still do not use Tables in Excel.
Why?
Adopt them. You will say "why did I not know about them all these days"!
Slicers were introduced in Excel 2010 to provide a more intuitive & user-friendly way to filter and analyze data/reports.
Despite being a very powerful & user-friendly, 90%+ users do not use them!
Why?
#TheModernExcel#SlicersInExcel
2K Followers 816 FollowingProject Manager turned into Data guy using #PowerBI | #PowerQuery | #DAX | Microsoft MVP | Romania #PowerBI and #Excel User Group founder | #Blockchain believer
945 Followers 3K FollowingProgramme chair for The European Spreadsheet Risks Interest Group, EuSpRIG - (“yewsprig”) for short. Academic and researcher in software and spreadsheet quality
60 Followers 317 FollowingCo-founder of ACE of Carts, one of the largest golf cart, LSV, and UTV dealerships in Florida. Oxford Comma enthusiast. UF Alum. Above-average NY Yankees fan.
27K Followers 666 FollowingExcel MVP, Author of 60 books: Excel, Pivot Tables, Power Pivot, VBA. Publisher at Holy Macro! Books. https://t.co/C9OvZvP6B4. Fan of Bruce Springsteen.
8K Followers 2K FollowingThe Power BI consulting firm everyone loves / Powered by data-loving humans doing the right thing /🎧 @RawDataByP3A / Subscribe for BI trends
1K Followers 199 FollowingMicrosoft MVP | Blog https://t.co/qwx9m8DZhg | Become a Power Query Pro - Join 1000+ subscribers and transform your job: https://t.co/DZi4ztUjD3
1K Followers 333 FollowingConsultant Architect • Mentor • Developer • BI/Data Engineer
C#/.Net, SQL, Power BI/Power Query, business strategy, …
Author of the Power Query M Primer series
502 Followers 298 FollowingFormer digital marketing analyst, advocate, ex-MVP. In my fifth year of information detox, coupled with self-inquiry meditation. Currently reinventing myself.
8K Followers 546 FollowingChrist follower first. Then family, and finally Power BI consultant 📊 @P3Adaptive. Also owns the best dog in the world. 🐶 Opinions are correct.
636K Followers 35 FollowingWe're an AI safety and research company that builds reliable, interpretable, and steerable AI systems. Talk to our AI assistant @claudeai on https://t.co/FhDI3KQh0n.
3K Followers 706 FollowingBringing data to life, addicted to Power BI and Microsoft Fabric, then, now, and even more in the future. Power BI and Fabric sherpa by day, addict by night!
329K Followers 39 FollowingThe official account for #Microsoft365: Do more with less using Microsoft Teams, Word, Excel, PowerPoint, and more - all in one place. Support: @MicrosoftHelps
282K Followers 2K FollowingSenior Editor @verge ║ Sign up to Notepad, my weekly newsletter on Microsoft's big bets at https://t.co/KqkAib2CKP ║ Tips? Msg on Signal app: tomwarren.01
1.3M Followers 2K FollowingFollow along for how-tos, demos, product news, and more. For company updates, check out @GoogleCloud.
Watch #GoogleCloudNext on demand ⬇️
4.3M Followers 3 FollowingOpenAI’s mission is to ensure that artificial general intelligence benefits all of humanity. We’re hiring: https://t.co/dJGr6Lg202
101K Followers 2K FollowingFollow for posts about GitHub repos, DSPy, and agents
Subscribe for top posts
DM to share your AI project (Due to volume of DMs I'll prioritize subscribers)
1K Followers 1K FollowingWe store, transform and give #insights in #data. Find out how passionate we are about #Microsoft technologies at #dataMindsConnect 7th, 8th & 9th October 2024
7K Followers 613 FollowingCorporate Vice President of Azure Data @Microsoft, runs Microsoft Fabric, Azure SQL, Cosmos, Postgres, MySQL, Data Factory, Service Bus, Synapse, and Power BI