Show the Developer tab - Microsoft Support
The Developer tab isn't displayed by default, but you can add it to the ribbon. On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box.
Change macro security settings in Excel - Microsoft Support
In Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.
Use Power Query to import data for Python in Excel
Use Power Query with Python in Excel to import external data into Excel and then analyze that data with Python. Important: Power Query is the only way to import external data for use with Python in Excel. To learn more about Power Query, see Power Query for Excel Help.
Quick start: Create a macro - Microsoft Support
You can learn a little about the Visual Basic programming language by editing a macro. To edit a macro, in the Code group on the Developer tab, click Macros, select the name of the macro, and click Edit. This starts the Visual Basic Editor. See how …
Add or remove add-ins in Excel - Microsoft Support
Add or remove add-ins in Excel. Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them.
Run a macro - Microsoft Support
There are several ways to run a macro in Microsoft Excel. A macro is an action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language. You can always run a macro by clicking the Macros command on the Developer tab on the ribbon.
Format data for Copilot in Excel - Microsoft Support
Learn how to format your data in Excel so that you can use Copilot to get insights, generate formulas for new columns, and highlight, sort, and filter your data.
Create a Data Model in Excel - Microsoft Support
Use a Data Model to create a PivotTable or PivotChart. An Excel workbook can contain only one Data Model, but that model can contain multiple tables which can be used repeatedly throughout the workbook. You can add more tables to an existing Data Model at any time. In …
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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.
Automate tasks with the Macro Recorder - Microsoft Support
When you record a macro, the macro recorder records all the steps in Visual Basic for Applications (VBA) code. These steps can include typing text or numbers, clicking cells or commands on the ribbon or on menus, formatting cells, rows, or columns, or even importing data from an external source, say, Microsoft Access.