October's roundup has arrived!
Global Excel Summit
Limited Early Bird tickets available for Global Excel Summit 2025!
Hi there,
The spreadsheet celebrated its 45th birthday this month — are you old enough to remember VisiCalc? We should never forget its humble origins, as it laid the foundations for what we have today.
In other news, there are less than 70 in-person and 90 online?EARLY BIRD?tickets remaining?for the Global Excel Summit 2025. Don't wait —?get your ticket?at the lowest possible price!
There is also the?GENCFO Academy taking place next week. We have a very generous deal exclusively for Global Excel Summit subscribers, thanks to our partnership with GENCFO! You’ll receive a?complimentary?'Live Access' pass, saving you a whopping ￡97 —?just hit this link?to get?completely FREE access!
Last chance to nominate!
The Global Excel Awards nominations stage?closes on?3 November. If you haven't already, now's the time to put forward those that most deserve recognition in the Excel industry.
Six ways you can use AI with Excel
Copilot is Excel's ever-improving assistance tool, and there are various tasks it can help you with, whether it's managing charts and PivotTables, constructing formulas, formatting your worksheets, or generating Python code.
What new stuff has come to Excel?
You can now clean data with Copilot and use the GROUPBY and PIVOTBY functions, which have rolled out to the Current Channel. Other highlights include Focus Cell for Insiders and a colour picker (no, not that kind, unfortunately).
Stay focused on the right cell
Ever lose track of where you are in the worksheet grid? Focus Cell is a long-awaited feature that automatically highlights the row and column of the active cell so you can work with greater certainty.
Create a Python-based word cloud in Excel
Word clouds are a great way to visually represent text-based data, yet they used to be very difficult to create in Excel without resorting to add-ins or VBA. Thankfully, since the?advent of Python integration, there's a convenient way.
领英推荐
Be careful summing when hiding rows and filtering
Summing a column of data might sound like a simple task, but are you aware of the impact hiding and filtering rows have? Find out the effect different formulas have on a table's Total Row, so you know you're looking at the correct figure.
Futureproofing finance with GENCFO Academy
Between?5–8 November, join finance leaders and industry experts at the virtual event to drive change and address challenges in the industry. They will tackle all things agility, analytics, and automation.
Master financial modelling under pressure
On 19 November, Carolina Lago will show you the best way to beat the clock when building financial models. She'll cover strategies for rapid model development, techniques to prioritise key components, and methods to maintain balance sheet integrity.
London Excel Meetup Group
On 19 November, Steve Kraynak will demonstrate several handy methods to avoid repeating actions in Excel by setting up workbook templates, cell styles, and a Personal Macro Workbook.
Thanks for being a part of our ever-growing community.
Best wishes,