Microsoft Excel

The TRIMRANGE function eliminates blank rows or columns from the boundaries of a specified range. This can be helpful when importing data from external sources, which can result in inconsistent formatting.

This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.

This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

This article provides an example of building a dynamic AR aging schedule in Excel.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

This month’s column shows how to use Excel’s Goal Seek for data analysis.

This column shows how to quickly project financial possibilities with Excel Scenario Manager.

This column tours of some of the most useful charts, starting with the basic ones and moving to the more advanced.

Learn how to use the new ChatGPT-4o (Omni) to interact with Microsoft Excel.

This article looks at a few ways to identify duplicates in Excel.

This column shows a couple of ways to create a watermark in Excel.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.