Office 2016, mais possibilidades em Pivot Tables, publicação para power Bi, etc. Muito a ler neste artigo da MS.
Stop wasting hours manually sorting, deduplicating, and filtering your data in Excel. Instead, combine FILTER, UNIQUE, and SORTBY to create a self-cleaning data engine that does all the work from a single cell and never needs updating.
Microsoft Excel’s SUMIFS function calculates the sum of values in a range of cells based on multiple conditions.
Excel spilled range operator (#) allows formulas to automatically adjust to changes in the spilled range size.
Excel Consulting.
Welcome to the February 2025 update. We are excited to announce that Copilot in Excel with Python is now available on Windows platforms for all enterprise and consumer users. Also starting now, Excel users on Windows and web can get to Copilot faster from anywhere on the grid. Furthermore, Copilot can now bring web and organizational data into your spreadsheets—available for Windows and Mac Insider users.
