Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:

Training: Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts with these handy cheat sheets for Microsoft Office.

Note: Notice the checkbox at the bottom of the window that allows you to Add this data to the Data Model, shown in the following screen.A Data Model is created automatically when you import or work with two or more tables simultaneously. A Data Model integrates the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View.

File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:

To resize the image, select the image to see drag handles appear around the image. Move the drag handles to resize the image as necessary. Select the Picture Format tab on the ribbon, then use the options on it to format your image. For example, you can apply a style or a border to the image.

The FILTER function allows you to filter a range of data based on criteria you define.

To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts.

Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.

Dynamic lock is a security feature that automatically locks your device when you are not around. It uses Bluetooth to pair with a phone, and locks the device when the Bluetooth signal drops below a certain level, indicating that you are no longer near your device.

Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.