Block or unblock external content in Office documents
To help protect your security and privacy, Microsoft Office is configured by default to block external content—such as images, linked media, hyperlinks, and data connections—in workbooks and presentations.
INTERCEPT function - Microsoft Support
Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the INTERCEPT function when you want to determine the value of the dependent variable when the independent variable is 0 (zero).
MONTH function - Microsoft Support
Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December). MONTH (serial_number) The MONTH function syntax has the following arguments: Serial_number Required. The date of …
Overview of diagnostic log files for Office - Microsoft Support
When a user runs an Office app, such as Word or Excel, diagnostic information is collected and saved to log files on the user’s device. These log files contain information about the processes and components running in the application, and can help detect, diagnose, and fix issues and help make improvements to Office.
Total the data in an Excel table - Microsoft Support
You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column. The Total Row default selections use the SUBTOTAL function, which allow you to include or ignore hidden table rows, however you can also use other functions.