What we’re about
Welcome to the Southampton Excel User Group!
This user group is dedicated to bringing together Excel users of all levels and professional backgrounds to share knowledge, exchange tips and tricks, and explore the endless possibilities of all things Excel.
There will be regular meetups covering a range of Excel topics, from formulas and functions to advanced data analysis techniques, with presentations from experienced Excel users.
If you live in the Southampton area then sign up and come along to our free in person meetups to meet like minded Excel enthusiasts and keep up to date with the latest Excel features and best practices.
All events will also be streamed live so anyone unable to make the in person meetup will be able to tune in from anywhere in the world.
This group is sponsored by The Niche Partnership (www.tnpjobs.com), finance and accounting recruiters located in Southampton. All in person events will take place in their office in central Southampton.
Upcoming events (2)
See all- In Person Event - Dynamic Arrays in ExcelThreefield House, Southampton
This event will take place at the office of The Niche Partnership
Threefield House, Threefield Ln, Southampton SO14 3LP
***PARKING INFORMATION: Do not park in the Threefield House car park as this is reserved for employees only. Parking here will result in fines. The closest public car park is College Street Car Park, a few minutes walk away.***
Agenda
- 6:00 – 6:30 Meet & Greet
- 6:30-7:30 Dynamic Arrays in Excel by Ben Weiner
Summary:
Traditional Excel formulas could only return a single value, but with the introduction of Dynamic Array formulas its now possible to return multiple values into a range of cells using just one formula.I will go over new dynamic array functions, including FILTER, SEQUENCE, SORT, UNIQUE, as well as showing how these formulas can be combined with traditional formulas to make dynamic calculations that expand over multiple cells as the data changes.
If you currently find yourself having to repeat one formula over a large dataset and having to drag down those formulas every time your data expands, then come along and find out how dynamic arrays can help you create more flexible calculations.
Bio:
A qualified CIMA Chartered Management Accountant and Microsoft Excel Expert I have been working in finance for over ten years. Initially working in accounting roles in the past few years he has moved in financial analysis using advanced Excel features to analyse financial data and build financial models, accounts and budgets and forecasts.
- 7:30-8:30 Pizza and Networking
Thanks to our sponsor The Niche Partnership for hosting this events at their office and for providing the pizza.