Create a forecast in Excel for Windows - Microsoft Support
When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column …
Create and save all your macros in a single workbook
To make your macros available every time you open Excel, you can create them in a workbook called Personal.xlsb. That’s a hidden workbook stored on your computer, which opens in the background every time you open Excel. Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it.
What to do if a data set is too large for the Excel grid
To help prevent reaching an Excel limit, make sure you’re using the .xlsx format instead of the .xls format to take advantage of the much larger limit. If you know your data set exceeds the .xlsx limit, use alternative workarounds to open and view all data. Tip: Be sure to cross-check that all data was imported when you open a data set in Excel.
Use slicers to filter data - Microsoft Support
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed. You can use a slicer to filter data in a table or PivotTable with ease.
Find what you need with search in Microsoft 365 apps
At the top of your Microsoft 365 apps on Windows you'll find the Microsoft Search box. This powerful tool helps you quickly find what you're looking for, from text to commands to help and more. Let's take a look at what it can do for you.
Microsoft Office Upload Center - Microsoft Support
Microsoft Office Upload Center now gives you a way to see the state of files you're uploading to a server, in one location.
Use the Field List to arrange fields in a PivotTable
After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields. If you want to sort or filter the columns of data shown in the PivotTable, see Sort data in a PivotTable and Filter data in a PivotTable.
Use the Analysis ToolPak to perform complex data analysis
Learn how to use the Analysis ToolPak to perform complex Excel data analysis. Explore the various data analysis functions available in Excel.
SUBTOTAL function - Microsoft Support
This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application.
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.