Keyboard shortcuts in Excel - Microsoft Support
Access keys: Shortcuts for using the ribbon. Excel for the web offers access keys, keyboard shortcuts to navigate the ribbon. If you’ve used access keys to save time on Excel for desktop computers, you’ll find access keys very similar in Excel for the web.
Undo, redo, or repeat an action - Microsoft Support
To undo an action press Ctrl+Z on your keyboard, or select Undo on the Quick Access Toolbar. You can press Undo (or Ctrl+Z) repeatedly if you want to undo multiple steps.
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.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Find or replace text and numbers on a worksheet
Find or replace text and numbers on a worksheet. Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
Excel functions (alphabetical) - Microsoft Support
Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. A complete list of all Excel functions in alphabetical order.
Using Checkboxes in Excel - Microsoft Support
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox. Removing Checkboxes. To …
Add or remove items from a drop-down list - Microsoft Support
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Using structured references with Excel tables - Microsoft Support
Structured reference: (DeptSales [ [#Totals], [Sales Amount]] and DeptSales [ [#Data], [Commission Amount]] are structured references, represented by a string that begins with the table name and ends with the column specifier. To create or edit structured references manually, use these syntax rules:
Fill data automatically in worksheet cells - Microsoft Support
Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.