Please note javascript is required for full website functionality.

News

New Features for Excel September 2024

26 September 2024

This month’s updates see the announcement of Copilot in Excel and Python in Excel, both of which are now Generally Available and ready to assist data-driven professionals around the world. In addition, there’s the public Preview of Copilot in Excel with Python, enabling powerful advanced analysis too.


September 2024 Updates for Power BI

26 September 2024

Some big news for those that like to “go dark”...


Python in Excel – Now Generally Available for Windows users of Microsoft 365 Business and Enterprise

17 September 2024

Python in Excel is now Generally Available for Windows users of Microsoft 365 Business and Enterprise. Back in August 2023, in partnership with Anaconda, Microsoft introduced Python integrated into Excel, making it possible to combine Python and Excel analytics within the same workbook, with no setup required. Since then, Excel has brought the power of popular Python analytics libraries such as pandas, Matplotlib and NLTK to analytical users.


Copilot in Excel Now Generally Available

17 September 2024

Microsoft has recently unveiled the next wave of Copilot including the announcement that Copilot in Excel is now Generally Available. In addition, the company has also broadcast the public Preview of Copilot in Excel with Python too.


Keeping in TRIM

29 August 2024

Microsoft announced a new function, TRIMRANGE, and an accompanying set of new reference operators today...


New Features for Excel August 2024

28 August 2024

This month’s updates see Excel reach a new watermark – quite literally!


August 2024 Updates for Power BI

21 August 2024

It’s that time of the month again. This month’s updates see you now able to ask Copilot questions against your semantic model. But there is always more. For example, updated Save and ‘Upload to OneDrive Flow’ in Power BI, plus the Narrative visual with Copilot is now available in SaaS embed.


New Regex Modes for XLOOKUP and XMATCH

14 August 2024

The term “regex” is an abbreviation of “regular expressions” and is a language used for pattern-matching text content. Regular expressions are starting to infiltrate Excel. In the latest release, currently in Preview, you may take further advantage of regex within the existing XLOOKUP and XMATCH functions...


Kathryn Hits 400

31 July 2024

Congratulations to SumProduct’s very own Kathryn Newitt who has just contributed / co-contributed her 400th Power Query / Get & Transform article.


New Features for Excel July 2024

31 July 2024

This month sees you able to use Copilot in Excel to unlock insights from data, work on data ranges resembling tables and prompt for step-by-step instructions including formula examples. But that’s not all...


Newsletter