Microsoft Excel

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.

A share feature in Excel allows you to share your workbook and specify sections, tables, ranges, charts, or worksheets that need to be addressed or viewed by someone else.

Applying the same formatting to each sheet
in an Excel workbook is ideal when each of your
sheets is set up the same, but it can be helpful in
other circumstances as well.

An AutoFormat option in Excel will format your
table and allow you to choose from several options.