Microsoft Excel is full of little tricks and features that are designed to make it easier for you to set up and manage your spreadsheets. Though unlike formulas — which can be used to automatically ...

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a ...

Microsoft has blocked macros in Excel due to potential security risks. Learn why this matters and how to protect your ...

Click to download a workbook and open in Excel; make sure to enable macros for full functionality. The workbooks contain screencasts that explain what to do and include tasks that can be assigned.