Microsoft Excel

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.

In this month’s column, find out how to change text strings to sentence case in Excel.

The Navigation Pane in Excel is a useful tool that allows users to easily move around and manage large workbooks.

This column discusses the resources available to help sharpen your Microsoft skills.

The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be shown.