Microsoft 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.

You can combine text that is separated into multiple cells in Excel.

Excel allows you to extract data from a picture.

This article offers four methods to join usernames to the @ symbol and domain.

Surveys are great for collecting information from your clients, and using software to collect responses makes generating reports and metrics a breeze.

Excel recently released @mentions to tag specific people within the comments.