Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, ...

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

The Excel ISEVEN function aims to return True if the number is even. This tutorial will show you how to use the ISEVEN function in Excel.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

Learn how to master Excel's MOD function for smarter data management, advanced analysis, and streamlined workflows in your spreadsheets.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

If you find entering data into spreadsheets to be mind-numbing drudgery, then you probably don't know about these cool, time-saving tricks that make Excel 2010 do the heavy lifting for you.