The implicit intersection operator was introduced as part of substantial upgrade to Excel's formula language to support dynamic arrays. Dynamic arrays bring significant new calculation ability and functionality to Excel.

Find out how to get started, collaborate, format, analyze, and troubleshoot Excel. Learn from live instructors, explore templates, use Analyze Data, and more.

Learn how to use the IF function with AND, OR, and NOT to perform multiple evaluations in Excel. See examples, formulas, and tips for conditional formatting with these functions.

Learn Excel skills from beginner to advanced level with video tutorials, templates and other resources. Explore topics such as formulas, charts, PivotTables, Power Query and more.

Learn how to use Excel for simple calculations and tracking information with cells, formulas, and charts. Find out how to open a workbook, enter and format data, and try some quick analysis features.

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

Excel is a spreadsheet program that lets you crunch numbers, create charts, and spot trends. Learn how to open a workbook, enter data, and fill data in a series with Excel.

Operators specify the type of calculation that you want to perform on the elements of a formula. Excel follows general mathematical rules for calculations, which is Parentheses, Exponents, Multiplication and Division, and Addition and Subtraction, or the acronym PEMDAS (Please Excuse My Dear Aunt Sally).

Excel 2024 and Excel 2024 for Mac enable you to quickly and accurately analyze data using these new features: dynamic charts, improved accessibility, new text and array functions, faster workbooks and more.

Lists all Excel functions by their category, such as Logical functions or Text functions.