Excel Consulting - Consultoria e desenvolvimento em Excel

10/02/2026

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.

17/09/2025

How to Use the SUMIFS Function in Microsoft Excel

Microsoft Excel's SUMIFS function calculates the sum of values in a range of cells based on multiple conditions. It avoids the need for complex filtering, and its conditions can be numbers, text, or dates, making it great for dynamic data analysis.

23/04/2025

You Need to Know What the Hash Sign Does in Excel Formulas

Excel spilled range operator ( #) allows formulas to automatically adjust to changes in the spilled range size.

07/03/2025

What’s New in Excel (February 2025)

12/02/2025

Excel’s 12 Number Format Options and How They Affect Your Data

Excel's 12 Number Format Options and How They Affect Your Data

30/01/2025

What’s New in Excel (January 2025)

Welcome to the January 2025 update. We are excited to announce that Copilot is now available to Microsoft 365 Personal and Family subscribers in most markets worldwide.

27/01/2025

Microsoft Excel Finally Has a Dark Mode on Windows

A long-awaited display feature of Microsoft Excel has finally arrived—Dark Mode. You can now work on your spreadsheets with a darker theme on Windows PCs.

14/01/2025

How do I calculate answers in Excel?

You can create a simple formula to add, subtract, multiply or divide values in your worksheet.

27/12/2024

A Excel Consulting deseja a todos Boas festas e um excelente Ano de 2025!

17/12/2024

Como fazer uma tabela no Excel?

11/12/2024

Como aceder ao Office online?

Como aceder ao Office online Excel