Restrict access to workbooks with Information Rights Management …
Select File > Info. Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select Restrict permission to this workbook, and then assign the access levels that you want for each user.
Protect controls and linked cells on a worksheet
Protect controls and linked cells on a worksheet. Applies To. You may want to add protection to Form controls and ActiveX controls to prevent users from moving, changing, or deleting controls. If one or more controls is an ActiveX control: Make sure that the Developer tab is available.
Learn to combine multiple data sources (Power Query) - Microsoft …
In this tutorial, you can use Power Query's Query Editor to import data from a local Excel file that contains product information and from an OData feed that contains product order information. You perform transformation and aggregation steps, and combine data from both sources to produce a "Total Sales per Product and Year" report.
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
Macros or VBA code found - Microsoft Support
Here's how you can find macros and VBA modules in your document: In Word or Excel, click View > Macro > View Macros. In PowerPoint, click View > Macro. In the Macro box, pick the macro you want to remove and click Delete. Press Alt+F11 to find macros in the VBA Editor.
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.