Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Keyboard shortcuts in Excel - Microsoft Support
To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words. If an action that you use often does not have a shortcut key, you can record a macro to create one. For instructions, go to Automate tasks with the Macro Recorder. Download our 50 time-saving Excel shortcuts quick tips guide.
Open a document after a file corruption error - Microsoft Support
Open and repair a document after getting a file corruption error, and see how to prevent file corruption in the future.
Show or hide the ribbon in Office - Microsoft Support
Show the ribbon when hidden, and set options to shows tabs and commands, just tabs, or automatically hide the ribbon for the maximum document space.
Use the Selection pane to manage objects in documents
You can use the Selection pane to manage objects in your document: re-order them, show or hide them, and group or ungroup them. Tip: In Word, you might want to set the location of objects within a paragraph. When you move a paragraph, the corresponding anchored image (s) move with the paragraph.
Crop a picture to fit in a shape - Microsoft Support
With Microsoft PowerPoint, Word, Outlook, or Excel, you can easily change the outline of a photo by turning it into a shape like a circle or a rounded rectangle. The Crop to Shape feature provides options for cropping an image to a specific shape or starting with …
Using structured references with Excel tables - Microsoft Support
When you add formulas to an Excel table, those names can appear automatically as you enter the formula and select the cell references in the table instead of manually entering them. Here's an example of what Excel does: That combination of table and …
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Unhide the first column or row in a worksheet - Microsoft Support
To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. On the Home tab, in the Editing …