How-To Geek on MSN

How to use LAMBDA in Excel to create scalable, reusable functions

LAMBDA lets you turn repeated Excel logic into reusable functions that update automatically across your entire workbook.

How to Build an Auto-Updating Excel Report Without Macros or Pivot Tables

Stop updating Excel manually. Discover how to use dynamic array formulas to create self-updating reports and dropdown lists ...
Excel Dictionary on MSN

Create an attendance tracker in Excel (in 2 minutes)

Learn how to create a simple dynamic Attendance Tracker in Excel in just 2 minutes. First, we will insert the new checkboxes, then we will calculate the percent attended using the COUNTA and COUNTIF ...