incspaces’ Post

Array of arrays – TEXTSPLIT wrapped inside TEXTJOIN Over the last couple of years, Microsoft has introduced a few very powerful dynamic array functions. One of their characteristics is that a formula in one cell can take everything in a muti-cell array, and perform an action on it. Alternatively, a formula can take a cell and generate a multi-column or muti-row answer. TEXTSPLIT is in the latter category, that is to say, it can split one cell, but it cannot natively split an array of cells (I have learnt that this is referred to as the “array of arrays” problem). I owe Giles Male a huge debt for showing that there is a way to use TEXTSPLIT on an array, which is to wrap TEXTSPLIT inside TEXTJOIN, and to then use a delimited that is not part of the original array to execute the TEXTSPLIT. Here’s an example: Imagine that you have a table in cells A1:A4 where there are the format of each cell is as follows: Gleneagles – Perthshire – Scotland Dubai Creek – Dubai – UAE Etc. If you enter =TEXTSPLIT(“-“,A1:A4), this will just give the first values in a column. However, we can fix this by wrapping it in TEXTJOIN as follows:  =TEXTSPLIT(TEXTJOIN(";",,A1:A4),"-",";"). This will give all three columns in four rows. And if we have different delimiters, e.g. Golf du Medoc – Bordeaux : France, we can fix that by putting all the appropriate delimiters in curly brackets as follows:  =TEXTSPLIT(TEXTJOIN(";",,A1:A4),{"-";":"},";") If you have not yet seen the series of videos that Giles Male and Diarmuid Early are putting out this week in preparation for the Excel World Cup, you are missing out!

Different between My workspace and workspace in Power bi services? =>    My workspace is only use for our practice and research purpose =>     My workspace is look like  same to workspace but it’s not possible to share anyone  => Workspace is use to create reports, dashboard and also fabric etc . => Workspace is we can share to anyone use to manage access in our organisation only

This week we had the honor of hosting Michael Olafusi, who took us on the topic “Dashboards in M365 Excel” In case you missed the live interaction, we have recorded the session, providing you with a comprehensive understanding of the subject matter. 🎥Youtube: https://lnkd.in/dBGFKyge We look forward to hearing your feedback after you’ve watched the session! #webinar #webinarseries #UrBizEdge #datadriven #msexcel

https://lnkd.in/grMTqydr  It Is Time To Increase Your Thinking and Intelligence Capacity With Unique Tools #networking #networkingmarketing #network #connectingprofessionals #letsconnecteveryone https://lnkd.in/gS39AFcj    Utilize the Power of Visualization to Manifest Your Unprocessed Goals  

Are you interested in learning more about Microsoft Dynamics 365 and Power Platform? Do you want to network with other professionals and experts in the field? If yes, then you don’t want to miss Dynamics User Group (DUG) DynamicsCon LIVE 2024! You can expect to see over 100 sessions covering topics such as Business Central, Finance and Operations, Customer Engagement, Power BI, Power Apps, Power Automate, and more. register at https://lnkd.in/eKr7AtAk. #powerplatform #powerautomate #dynamics365 #dynamics365businesscentral #communityrocks

How to use the FILTER function Find us on: - Facebook: Excel Experts - YouTube: Microsoft Excel Experts - Twitter: DFWExcelExperts - Instagram: DFWExcelExperts - TikTok: excel.experts VISIT US: www.dfwexcel.com #exceltips #excelformulas #excelfunctions #microsoftexcel #microsoft365

Do you know Excel Competitions Are a Thing—and They're Serious Business! When you think of competitive sports, Excel probably doesn’t come to mind. But believe it or not, Microsoft Excel has its own world championship, where the best spreadsheet minds compete to solve complex problems in record time! So what Is the Excel Championship? 🔸 The championship brings together Excel experts to compete in solving real-world data challenges. 🔸 Participants are tested on advanced skills, such as formulas, data visualization, and automation. 🔸 They work under extreme pressure, showcasing just how powerful Excel can be beyond basic spreadsheet tasks. Why Does This Matter? For most of us, Excel is just a tool for tracking budgets or making simple tables. But these competitions highlight the true potential of Excel as a powerful problem-solving tool for businesses. Example: In one challenge, competitors were tasked with optimizing warehouse inventory. Using advanced Excel formulas and data analysis, they had to find the best solution in just a few minutes! This isn’t just a test of skills, it’s real-world problem solving at lightning speed. Key Takeaways: 🔸 It’s a powerhouse for data analysis, automation, and decision-making. 🔸 Mastering Excel can give you a competitive edge in your career. 🔸 These events show how creative and innovative you can be with Excel. Would you enter an Excel competition? Or, do you see Excel as just another office tool? Share your thoughts below! 👇 #Excel #DataAnalysis #Microsoft #Automation #CareerGrowth #SkillsDevelopment #ProblemSolving #Productivity

In this video from FORVIS, you will learn how to use #PowerBI to display financial report information, include visuals, and allow users to drill down for more details. Watch here.

In this video from FORVIS, you will learn how to use #PowerBI to display financial report information, include visuals, and allow users to drill down for more details. Watch here.

In this video from FORVIS, you will learn how to use #PowerBI to display financial report information, include visuals, and allow users to drill down for more details. Watch here.