The best way to stay up to date on all the possibilities in Office 365 / SharePoint development is to dive in and give it a try.
When I come across something I find interesting, useful or noteworthy for any other reason, I will try to make a note of it here. Hopefully it can be of use to others as well!
Displaying a modern page without header and navigation SharePoint CSS
Azure App Authentication in an Azure Function PnP PowerShell Azure
Azure AD App authentication in PnP PowerShell PnP PowerShell Azure
Scheduled update of an Excel file from Azure Function Excel SharePoint Azure PowerShell PnP
Open a specific Excel Worksheet in the browser Excel SharePoint
Supplying credentials for Connect-PnPOnline PnP PowerShell SharePoint
New-PnPSite, New-PnPTenantSite, New-SPOSite? PnP PowerShell SharePoint
Strange problem with executeFlow in customRowAction Bugs Flow Power Automate JSON