Learn how to improve the clarity of text and images displayed on your screen by changing the screen resolution of your monitor.

Use the Microsoft Wireless Display Adapter. The Microsoft Wireless Display Adapter is a strong, reliable way to project your content, photos, and videos to a big screen.

How to use the FILTER function in Excel to filter a range of data based on criteria you define.

Add an easy to maintain Table of Contents using heading styles that automatically updates when you make changes to your headings.

TEXTSPLIT function. Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function .

How to use the COUNTIF function in Excel to count the number of cells that meet values you set.

Create a cell reference. Cell references can refer to cells on the same worksheet, a different worksheet, or a different workbook.

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional formulas.

Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.

Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.