Yahoo Search Búsqueda en la Web

Entrar

Resultado de búsqueda

  1. Videos

    Ver todo

  2. support.microsoft.com › en-us › officeCreate, load, or edit a query in Excel (Power Query)

    Import data. Create, load, or edit a query in Excel (Power Query) Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window.

  3. learn.microsoft.com › en-us › powerquery-mRecord.Field - PowerQuery M | Microsoft Learn

    24 de abr. de 2024 · Example 1. Syntax. Record.Field( record as record, field as text) as any. About. Returns the value of the specified field in the record. If the field is not found, an exception is thrown. Example 1. Find the value of field "CustomerID" in the record. Usage. Power Query M. Copy.

  4. support.microsoft.com › en-us › officeAdd a custom column (Power Query) - Microsoft Support

    To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, edit, and load a query in Excel . Select Add Column > Custom Column . the Custom Column dialog box appears.

  5. support.microsoft.com › en-us › officeWork with a List, Record, or Table structured column (Power...

    Power Query for Excel Help. Merge queries. Grouping or summarizing rows (docs.com) A column of complex values, such as tables, lists, records or links, can be expanded to reveal the values contained in the complex value. In Microsoft Power Query for Excel, you use the Expand operation to bring related tables back together.

  6. www.ablebits.com › office-addins-blog › how-to-use-power-query-excelHow to use Power Query in Excel with examples - Ablebits

    26 de oct. de 2023 · How to use Power Query in Excel – practical examples. by Alexander Frolov, updated on October 26, 2023. The tutorial delves into practical real-life scenarios of using Power Query in Excel. In the previous article, we laid the groundwork by exploring the basics of Excel Power Query. Now, it’s time to put it to use in real-world scenarios.

  7. www.howtoexcel.org › the-complete-guide-to-power-queryThe Complete Guide to Power Query | How To Excel

    14 de abr. de 2020 · Power Query is a business intelligence tool available in Excel that allows you to import data from many different sources and then clean, transform and reshape your data as needed. It allows you to set up a query once and then reuse it with a simple refresh. It’s also pretty powerful.

  8. www.ablebits.com › office-addins-blog › excel-power-query-tutorialPower Query in Excel tutorial: how to get, use and auto-refresh -...

    26 de oct. de 2023 · This comprehensive Power Query tutorial is your entry point to mastering advanced data transformations in Excel. You will learn how to import data from diverse sources, transform and merge it according to your requirements, write formulas in the M language, automate query refreshes, and more.