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 macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Open your Excel workbook and navigate to the Automate tab. You can glance over several existing scripts, such as removing hyperlinks, counting empty rows, freezing selection, and more.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.