Microsoft Excel

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.

The Automate tab allows you to create and run Office Scripts, which allow users to
automate tasks in Excel.

You can choose from several text orientations in Excel.

You can automate the task of inserting red circles around items using Data Validation tools.