Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Enable or disable macros in Microsoft 365 files
Block suspicious macros in Office on Windows 10 S. How malware can infect your PC. Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.
Replace a formula with its result - Microsoft Support
Replace a formula with its result. You can convert the contents of a cell that contains a formula so that the calculated value replaces the formula. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.
Display the relationships between formulas and cells
To assist you in checking your formulas, you can use the Trace Precedents and Trace Dependents commands to graphically display and trace the relationships between these cells and formulas with tracer arrows, as shown in this figure.
Convert numbers stored as text to numbers in Excel
Use a formula to convert from text to numbers. You can use the VALUE function to return just the numeric value of the text. Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column.
What is Protected View? - Microsoft Support
Protected View is a read-only mode where most editing functions are disabled. There are several reasons why a file opens in Protected View: The file was opened from an Internet location - When you see the message in Protected View that says "Be careful - …
Calculate values in a PivotTable - Microsoft Support
PivotTables provide ways to calculate data. Learn about the calculation methods that are available, how calculations are affected by the type of source data, and how to use formulas in PivotTables and PivotCharts.
Trusted documents - Microsoft Support
Jan 24, 2022 · Trusted documents are files that have been marked as trusted by enabling active content in them. Active content (macros, ActiveX controls, data connections, and so on) opens without the Message Bar warning after you mark the file as trusted.
Using Checkboxes in Excel - Microsoft Support
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox.
CONCATENATE function - Microsoft Support
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.
Use AND and OR to test a combination of conditions
This formula nests the AND function inside the OR function to search for units sold between April 1, 2011 and January 1, 2012, or any units sold by Nancy. You can see it returns True for units sold by Nancy, and also for units sold by Tim and Ed during the dates specified in the formula.