Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the "Format cells that contain specific text" criteria.
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.
Filter by using advanced criteria - Microsoft Support
Click a cell in the list range. Using the example, click any cell in the range A6:C10. On the Data tab, in the Sort & Filter group, click Advanced. Do one of the following: To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.
Create a PivotTable to analyze worksheet data - Microsoft Support
Calculate values in a PivotTable. Delete a PivotTable. How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
How to find and enable missing Copilot button in Microsoft 365 …
There are two settings here that can cause Copilot to not appear in your Microsoft 365 apps. First confirm that Experiences that analyze your content is turned on. Then scroll down and make sure that All connected experiences is turned on. Learn more. Copilot Lab - Start your Copilot journey!
Overview of Excel tables - Microsoft Support
Learn about the elements of an Excel table. A table can include the following elements: Header row By default, a table has a header row. Every table column has filtering enabled in the header row so that you can filter or sort your table data quickly. For more information, see Filter data or Sort data. You can turn off the header row in a table.
Excel functions (by category) - Microsoft Support
Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) returns the number 2, because 7 is the second item in the range.
Tutorial: Import Data into Excel, and Create a Data Model
A Data Model integrates the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View. When you import tables from a database, the existing database relationships between those tables is used to create the Data Model in Excel.
Keyboard shortcuts in Excel - Microsoft Support
Keyboard shortcuts in the Paste Special dialog box in Excel. In Excel, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog box.
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER (A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").