How to Join Microsoft Tech Community & Leina Future Data & AI Hub (Step-by-Step Guide) - Arabic
This session provides a step-by-step walkthrough on how to officially join the Microsoft Tech Community and become a member of the Leina Future Data & AI Hub – Microsoft User Group. The event is designed to help learners, trainers, and data professionals understand: • How to create and verify a Microsoft Tech Community profile • How to join an official Microsoft User Group • How community membership supports learning, networking, and professional growth • How participants can access recorded sessions, resources, and future events This session supports community enablement and knowledge sharing within the Microsoft ecosystem, with a focus on Data, AI, Power BI, and Microsoft Fabric learners. Target Audience: • Students and fresh graduates • Data analysts and Excel/Power BI learners • Trainers and professionals interested in Microsoft communities Session Format: • Recorded session • Practical walkthrough • Community-focused learning Speaker / Host Dr. Leina Nazar Abdelgalil Microsoft Certified Trainer (MCT) Founder – Leina Future Data & AI HubControl data conversions in Excel
(Originally published on July 5, 2022 by Chirag Fifadra) Hi, Insiders. My name is Chirag Fifadra, and I'm a Product Manager on the Excel team. I'm excited to share with you an improvement to Excel for Windows that will give you more control over data conversions. More specifically, you can now control how and whether the data you enter is automatically converted to specific formats. Control data conversions We have consistently heard from customers over the years (and likely from some of you!) that they're frustrated by the fact that Excel automatically converts data to specific formats. They have expressed a desire for more control over data conversions. We are now giving you the ability to change Excel’s default behavior and disable specific types of automatic data conversions as needed. This way, you won’t need to worry about your data being converted to a format that you didn't want and weren't expecting. How it works To disable specific automatic data conversions, select File > Options > Advanced > Automatic Data Conversion. Then choose the conversion(s) that you'd like to disable. Currently, you can enable or disable the following options: Remove leading zeros from numerical text and convert to a number. Truncate numerical data to 15 digits of precision and convert to a number that may be displayed in scientific notation, if needed. Convert numerical data surrounding the letter "E" to a number displayed in scientific notation. NOTE: You can also select the When loading a .csv file or similar file, notify me of any automatic number conversions check box. By doing so, Excel will display a warning message when it detects that at least one of the optional automatic data conversions is enabled and about to occur when opening a .csv or .txt file. The message gives the ability to do a "one-time load" of the file without converting the data. Scenarios to try Based on the settings you chose above, try some or all of the scenarios below to test the increased control over data conversions. Type directly into a cell. Copy and paste from external sources (e.g., a web page). Open a .csv or .txt file. Find and replace operations. Select Data > Text to Columns, and then use the Convert Text to Columns Wizard. NOTE: Since the feature works by saving the entered data as text, you might see a green triangle with a Number stored as text error. This is expected. You can dismiss the error by selecting Ignore error in the context menu. Also, you may not be able to use that data in mathematical operations. Known issues Support for disabling these conversions during macro execution is planned but not yet available. Support for automatic conversion to dates is planned but not yet available. Availability This feature is available to Office Insiders running Version 2207 (Build 15427.20000) or later on Windows. We are working to bring the same options to Mac soon. Features are enabled gradually over a period of time so that we can ensure things are working smoothly. Even though we've announced this feature, it might not yet be available to you. Sometimes we remove elements to further improve them, based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it. Feedback We want to hear from you! Please click Help > Feedback, in Excel and select one of the Feedback options. Enter #automaticdataconversions in the text box along with your comments, and then click the Submit button. Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!
name manager rejecting lambdas
I tried pasting a lambda in name manager but excel refused. I belive that it's because either it is too long (which it isnt) or it has too many optional parameters (8). Anyone knows why name manager will reject to paste my lambda? These are the parameters: =LAMBDA(array,slice1,[index1],[return_index_slice2],[index2],[return_index],[if_not_found],[logic],[headers],[function],LET(...))
Native FIFO Inventory Costing Function for Excel (Proof of Concept with LAMBDA)
Excel currently lacks a native function to calculate FIFO (First-In, First-Out) inventory costs when products are purchased at different unit prices and later issued in partial quantities. FIFO costing is a standard accounting requirement under IFRS and is widely used in inventory management, retail, manufacturing, and financial reporting. Today, Excel users must rely on VBA, Power Query, or complex multi-step formulas, which are error-prone and difficult to maintain. As a proof of concept, I created a native Excel implementation using modern functions such as LAMBDA, LET, SCAN, MAP, and dynamic arrays. The function calculates the FIFO unit cost of the latest outgoing inventory movement, given: an array of incoming quantities • an array of unit costs for each incoming batch • an array of outgoing quantities While this demonstrates that FIFO costing is feasible using native Excel functionality, the level of complexity required highlights a clear feature gap. A built-in FIFO inventory costing function would significantly improve usability, readability, performance, and accessibility for non-technical users. I believe a native function such as FIFO.COST() or INVENTORY.FIFO() would be a valuable addition to Excel, alongside potential support for LIFO and weighted average costing methods. I’m sharing this example to illustrate both the feasibility and the need for native inventory costing functions in Excel. =LAMBDA( InQty, UnitCost, OutQty, LET( PrevOutQty, TAKE(OutQty, ROWS(OutQty)-1), LastOutQty, INDEX(OutQty, SEQUENCE(1,1,ROWS(OutQty))), OutIndex, ROWS(OutQty), RemainingFromPrevious, LET( InMatrix, InQty, OutMatrix, PrevOutQty, ApplyFIFO, LAMBDA(InMatrix, OutMatrix, LET( n, ROWS(OutMatrix), RecursiveFIFO, LAMBDA(self, Remaining, i, IF( i > n, Remaining, self( self, LET( OutAmount, INDEX(OutMatrix, i), CurrentStock, Remaining, Consumed, VSTACK( OutAmount, TAKE( SCAN( OutAmount, CurrentStock, LAMBDA(acc, qty, IF(qty > acc, 0, acc - qty) ) ), ROWS(CurrentStock)-1 ) ), IF(CurrentStock > Consumed, CurrentStock - Consumed, 0) ), i + 1 ) ) ), RecursiveFIFO(RecursiveFIFO, InMatrix, 1) ) ), ApplyFIFO(InMatrix, OutMatrix) ), FirstRemaining, SCAN( LastOutQty, IF(OutIndex = 1, InQty, RemainingFromPrevious), LAMBDA(stock, qty, IF(qty >= stock, 0, stock - qty) ) ), SecondRemaining, VSTACK( LastOutQty, TAKE(FirstRemaining, ROWS(FirstRemaining)-1) ), FIFOQuantities, MAP( IF(OutIndex = 1, InQty, RemainingFromPrevious), SecondRemaining, LAMBDA(stock, qty, MIN(stock, qty)) ), FIFOUnitCost, SUMPRODUCT(FIFOQuantities, UnitCost) / LastOutQty, IF(ROWS(InQty) = 1, UnitCost, FIFOUnitCost) ) ) Have a nice day. Juan Miguel Arraztoa
Using mode with several criteria
Hello everyone! I'm currently treating some data before I send it to do some machine learning. I have the following data: id Ano mês data_inversa dia_semana horario uf br km municipio causa_acidente tipo_acidente classificacao_acidente fase_dia sentido_via condicao_metereologica tipo_pista tracado_via uso_solo ano pessoas mortos feridos_leves feridos_graves ilesos ignorados feridos veiculos And I created a new table to summarize this data for months instead of accidents, here are the columns: BR KM Ano Mês Clima (Moda) Tipo Pista Acidentes Veículos Ilesos Feridos Leves Feridos Graves Mortes Causa (Moda) Risco What I want to do is calculate the mode of condicao_metereologica for each combination of BR, KM, Ano and Mês. But I can't wrap my head around on how I could do this. Any help is appreciated! Let me know if I made anything not as clear as it is in my head xD
Data Reconciliation Assistance Needed – Time Range & Sum Matching
I have two sets of data that need to be reconciled. Specifically, I’m trying to identify which combinations of numbers from these datasets can sum up to a specific target value. Additionally, the reconciliation should only consider entries that fall within a defined time range—from approximately 8:00 AM on one day to 10:00 PM the following day. I’ve tried using Solver and Goal Seek, but the results don’t seem accurate. I also attempted using Microsoft Copilot, but the outcome still appears incorrect. Could you assist with identifying or generating the correct combinations based on the criteria above?Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Can't print this document! Print preview not matching Page Layout or Page Break Preview
I'm trying to "print" this to PDF, but can't get all my tables and graphs to fit nicely when printing This is my view in Page Break Preview This is my view in Page Layout This is the Print Preview screen, I think when it's scaling the rows to fit on one page, it's not scaling the graphs as well so they keep moving around. How do I make this look nice when I print? I have 16 tables with graphs plus a footer, so they aren't going to fit all on one page, that's why I set it to print over 4 pages.
