Training: Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts with these handy cheat sheets for Microsoft Office.

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.

Quick tips for using keyboard shortcuts with Excel for the web. 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). Search or Tell Me searches for related options and provides a list. Use the ...

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Using functions and nested functions in Excel formulas. Define and use names in formulas. Guidelines and examples of array formulas. Delete or remove a formula. How to avoid broken formulas. Find and correct errors in formulas. Excel keyboard shortcuts and function keys. Excel functions (by category)

Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often. If all you want is the syntax for VLOOKUP, here it is: VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

Keyboard shortcuts in Excel. Use keyboard shortcuts to create PowerPoint presentations. Keyboard shortcuts for Microsoft Lens for iOS

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.