Somerset Chamber

Talk to the team 01823 444924

Menu

Would you like to sponsor a Chamber event?

Learn more

 
 

Chamber event

Training workshop - Discovering new Microsoft Excel functions

Attendees on this workshop will be introduced to some of the new functionality which Microsoft has released in Excel 365, including dynamic arrays and functions that make lookup analysis and text handling easier and more powerful. Spreadsheets using this new functionality are more efficient and less prone to error.
 
Attendees will discover the benefits of using some of the key new functions and discuss how they work with Excel's revamped calculation engine (dynamic array capability). They will leave the workshop confident of using these new functions instead of the legacy functions they may still be using!
 
This workshop is aimed at experienced Excel users who are still using Excel's VLOOKUP function and who are either unaware of its replacement function and the other new functions and features recently introduced, or simply have not found the time in their working day to explore them.
 
This is an Excel workshop covering intermediate/advanced level skills. It is not suitable for beginners.
Attendees should be comfortable with working in the Excel environment and be competent with data entry, editing and formatting tasks. 
 
They must have experience of entering formulae and functions, particularly functions with multiple arguments such as IF and VLOOKUP. Knowledge of tables, sorting and filtering is useful but not essential.
 
Note: The functionality covered on this workshop is only found in Excel 365 which is part of the Microsoft 365 subscription product. The workshop will be conducted on Windows based Excel 365.
 
The workshop format is interactive; attendees are expected to bring their own laptops to participate in the hands-on content. There will be demonstrations in Excel of the topics and attendees are encouraged to join in with these on their own laptops (trainer discretion – skills permitting) and simple exercises they do on their own.

This training workshop will be delivered by Sally Williams, of SJM Training


SJM Training provides expert IT training and consultancy on Microsoft Office and bespoke systems. Sally Williams MCT, MLPI is the managing director of SJM Training. She has over 30 years’ experience in training people to use Excel efficiently and effectively and of working on custom spreadsheet solutions for businesses of all sizes and from all sectors.
 
The SJM Training approach to training is different from many companies who run introduction, intermediate and advanced courses. With her real-life experience outside the classroom, Sally can ask the right questions to discover what you want to achieve from training – people do not always know what they need to know! Customised training content is created to be relevant to users, leading to greater understanding of functionality, faster application of knowledge in the workplace and better retention. 
 
Sally finds great personal satisfaction in helping people solve their problems, improve their knowledge, and make their working lives easier. Businesses benefit by gaining more productive and less frustrated employees.

Lunch and refreshments will be provided. Please inform us when booking if you have any dietary requirements or allergies. 

Please note: Due to limited places available, bookings are limited to one per company.

Bookings for this event will close 4pm, April 30. 

Somerset Chamber of Commerce is operating a cancellation policy in line with our terms and conditions which can be found here : https://www.somerset-chamber.co.uk/terms-conditions/

Event details

Wednesday 8 May 2024

9:30am – 1:30pm

Somerset Chamber of Commerce,  Equity House, Blackbrook, Blackbrook Business Park, Taunton, TA1 2PX

£65.00 + VAT - member ticket price  
£70.00 + VAT - non-member ticket price 

Price includes lunch and refreshments. 

Non-members are welcome to attend two Chamber events before we need to talk to you about joining us as a member.  *All prices exclude VAT

Register Now

Other events you may be interested in

See all events

April 2024

Solem Quartet

The award-winning ensemble returns to Cedars Hall with quartet masterpieces by Beethoven and Debussy plus music by Nadia and Lili Boulanger.

Event details

David's 24-hour line dance challenge for Secret World

Secret World's Fundraising Manager, David, is taking on his biggest fundraising challenge yet! He's going to be attempting a 24-hour line dan...

Event details

Hippychick April Warehouse Sale

Hippychick's popular Warehouse Sale returns on Saturday 27th April. Get up to 60% off a wonderful range of toys, nursery essentials and so much more!

Event details

Connect. Influence. Grow.

Join Somerset Chamber of Commerce to give your business a stronger voice both locally, regionally and nationally. Combined with local town chambers, we represent over 2,000 businesses across Somerset with a direct line to policy-makers at all levels.

Discover the benefitsJoin now