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.

The LAMBDA function in Microsoft 365 Excel is a fantastic option for advanced users, empowering them to create custom, reusable functions that significantly boost productivity and precision.

I discovered artificial intelligence tool GPT Excel in my quest to cut down on all the busywork it takes to create and update spreadsheets.