Excel adds features for improved productivity and functionality

Microsoft has recently updated Excel with several new features aimed at enhancing productivity. Notable improvements include an upgraded Copilot that can now fetch online data directly into workbooks, making it easier to compare various parameters. Power Query now supports automatic data refreshing from secure sources without needing to re-enter login credentials. Additionally, users can create forms directly in Excel, allowing for real-time data collection and storage in spreadsheets. Excel has also added native support for Regex functions, simplifying text manipulation. Furthermore, Python scripts can now be used in Excel for the web, expanding capabilities for online users.