It explains how the Excel files on this web site can be used in a variety of ways to help students learn. The files are standalone and freely available. They use Visual Basic code to support buttons, ...

Record a macro: Create a simple macro and save it in the “Personal Macro Workbook” location. Add VBA code: Include scripts for automating Power Query tasks, such as toggling refresh settings ...

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

How to create an automated list of worksheet names in Excel -- and add a table of contents.