Excel has been the spreadsheet standard for over 30 years. Microsoft has been accused of being a laggard in the end user technology however it has been shown that, yes, they have been a bit behind, but once that became an issue, they rebounded massively and became the leader. Recently Excel’s Dynamic Arrays are a demonstration of this. But Microsoft has been aggressively become a leader in this technology and its totally offerings are demonstrating its leadership in this market. While this is an Excel site, we will be bringing some of Microsoft’s offerings to you with the hope of educating you with the technology world beyond the Excel world.
Artificial Intelligence (AI) is here (2023) and is integrated (directly and indirectly) into Excel. ChatGPT will create Excel solutions for you and write VBA macros.
Excel now has Excel Office Scripts, tools to record your repetitive activity and save it for future use…..a new era of automation, claiming to gradually replace VBA and the preferred method for automating Excel tasks.
VBA is limited to Excel Desktop and will never be able to execute in Excel Online. Excel Office Scripts will execute online.
ChatGPT will create the script for you with your very detailed instruction to the tool.
Please check back for more on what’s new with both Excel and Microsoft.