View my privacy options in the Microsoft Office Trust Center
The options available in the Trust Center allow you to share documents with the people you want, as well as to find and remove hidden information you may not want to disclose. To learn more about Office privacy, read the Microsoft Privacy Statement.
Differences between the OpenDocument Spreadsheet (.ods) …
Differences between the OpenDocument Spreadsheet (.ods) format and the Excel for Windows (.xlsx) format. When you work with two file formats, like .xlsx and .ods, there might be formatting differences, and not all features are available.
Apply sensitivity labels to your files and email - Microsoft Support
The sensitivity bar makes it easy for you to see what label is applied to your file, and to apply or change a label whenever you need to, including when saving the file. Just select the sensitivity bar in the save dialog to see the labeling options for this file.
Import or export text (.txt or .csv) files - Microsoft Support
There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down …
TEXT function - Microsoft Support
Overview. In its simplest form, the TEXT function says: =TEXT (Value you want to format, "Format code you want to apply") Here are some popular examples, which you can copy directly into Excel to experiment with on your own. Notice the format codes within quotation marks.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Calculate multiple results by using a data table
Unlike scenarios, data tables show you all the outcomes in one table on one worksheet. Using data tables makes it easy to examine a range of possibilities at a glance. Because you focus on only one or two variables, results are easy to read and share in tabular form.
Keyboard shortcuts in Microsoft 365
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Create a chart from start to finish - Microsoft Support
Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.
LET function - Microsoft Support
Benefits. Improved Performance If you write the same expression multiple times in a formula, Excel calculated that result multiple times. LET allows you to call the expression by name and for Excel to calculate it once.
SWITCH function - Microsoft Support
Applies To. The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.