The Query Editor, which opens when creating a new query or opening an existing one under Get & Transform, provides intuitive data shaping and transformation options, enabling you to prepare a data set with only the information you want to see and in the way you want to see it.

Access them from the Get & Transform section on the Data tab. These new capabilities, previously only available as a separate add-in called Power Query, can be found within Microsoft Excel 2019.

Microsoft Excel LTSC 2021 CSP now comes with built-in functionality that brings ease and speed to getting and transforming your data, allowing you to find and access all the data you need into one place. The software has new and improved business analytics features and makes improvements to the design with analysts in mind. Excel is the world's most widely used and familiar data analysis tool, especially now with the new Power BI and Power BI Desktop to provide business analysts with a powerful portfolio of analytic tools unique in the industry.

Excel ltsc