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

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 ...

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.

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

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.

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.

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