Keyboard shortcuts in Excel - Microsoft Support
To find any command quickly, press Alt+Windows logo key, Q to jump to the Search or Tell Me text field. In Search or Tell Me , type a word or the name of a command you want (available only in Editing mode).
Find what you need with search in Microsoft 365 apps
Get started quickly. Select the Microsoft Search box, or press ALT+Q. Before you even type anything, Search recalls recently used commands and suggest other actions you may want to take based on what you appear to be doing.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
Find or replace text and numbers on a worksheet
In the Find what box, type the text or numbers you want to find, or select the arrow in the Find what box, and then select a recent search item from the list. Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.
Create, load, or edit a query in Excel (Power Query)
You may find the Queries & Connections pane is more convenient to use when you have many queries in one workbook and you want to quickly find one. In Excel, select Data > Queries & Connections , and then select the Queries tab.
Use the keyboard to work with the ribbon - Microsoft Support
You can use the keyboard to work with the ribbon and move the focus among the tabs and commands until you find the feature you want to use. The following instructions describe how to move between the following main regions in the ribbon: Area A: Ribbon tabs
Keyboard shortcuts in Microsoft 365
For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse. Here you'll find links to most keyboard shortcut articles for Microsoft 365 apps.
Use Goal Seek to find the result you want by adjusting an input …
If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that you need to borrow some money. You know how much money you want, how long you want to take to pay off the loan, and how much you can afford to pay each month.
Group or ungroup data in a PivotTable - Microsoft Support
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and …
Detect errors in formulas - Microsoft Support
Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors and determine solutions.
Excel video training - Microsoft Support
Search Search for help. No results; Cancel. Sign in. Sign in with Microsoft. Sign in or create an account. Hello, Select a different account. You have multiple accounts. Choose the account you want to sign in with. Excel video training. Quick start. Intro to Excel. Rows & columns. Cells. Formatting. Formulas & functions. Tables.