The LAMBDA function is my new favorite thing in Excel, after templates. It allows you to create your own custom named functions without VBA! You can then use that function throughout your workbook. And, the function is easily copied into other workbooks. In Google Sheets, the feature is called "Named Functions" and it is equally ..read more

Learn how to set up x-Input and x-Output Data Tables in Excel! With this technique you are no longer limited to 1-D or 2-D ..read more

Learn need-to-know information about Dynamic Arrays, the spill behavior, and many of the new functions such as SEQUENCE, VSTACK, FILTER, TOCOL, etc ..read more

Are you a fan of spreadsheets AND card games? If so, check out this new project, just for fun: Spreadsheet-themed playing cards and a crazy card game ..read more

Learn how to make and vote on feature suggestions for Excel, using the official Microsoft website. In this article, I have listed some of the features that I would like most, so please vote on them ..read more

Learn essential keyboard shortcuts for Excel and Google Sheets. Download a keyboard shortcut bingo sheet to help you learn hotkeys one at a time ..read more

Learn over 20 different ways to use conditional formatting in Excel to do things like add color scales for data analysis, add data bars for in-cell charts and progress bars, and create a gantt chart ..read more