Formulas, Macros & Power Query for Excel
Just Added

Formulas, Macros & Power Query for Excel

Get ready to level up your Excel game with Formulas, Macros & Power Query - it's time to unlock the full potential of your spreadsheets!

By Rock Learning.

Date and time

Location

Gibraltar Digital Skills Academy

Suite 745 Europort GX11 1AA Gibraltar Gibraltar

Refund Policy

Refunds up to 7 days before event.

About this event

  • Event lasts 7 hours

Course Overview - Formulas, Macros & Power Query for ExcelA one day workshop on Excel formulas, such as VLOOKUP and its successor XLOOKUP, aggregations such as SUMIFS, TEXTJOIN, conditional functions such as IF, SWITCH and more listed below. We also cover data validation to ensure robustness and modern tools such as images inside cells, live exchange rates and more. Finally we will go through macros for automation and Power query which is Excel’s built in data transformation tool which has been game changing for those working to reshape data, or those who import data into Excel and find copy & paste is tedious and time consuming.

Learning objectivesBy the end of workshop participants should be able to:Create Power Query steps to automate data reshapingAutomate how to clean up messy data exports from other systemsRecord macros and edit via the VBA code editorAdvanced copy & paste and data validation for robust dataUse VLOOKUP and its successor XLOOKUP to merge tablesUse IF and SWITCH for conditional formulasAggregate with AVERAGE, TEXTJOIN, SUMIFS, AGGREGATE & more.

Pre-requisites

This workshop is aimed at people using Excel for 3 or more hours per week, all regular Excel users can benefit, particularly those who require more advanced formulas, data manipulation and automation.Take home materials and documentationPost training website featuring all post course resources like this one with:Written notes on the key points coveredYouTube videos from the trainer’s 12,000+ subscriber tutorial channelSlides which were covered in classThe completed exercise filesInvestment: £299 including light lunch, or £549 if combined with Analytics course the previous day.

Trainer profile

Originally from Gibraltar, David Benaim ACA has trained over 3000 people in Excel globally and provides data and spreadsheet consulting services through his Cambodia based company Xlconsulting. David is a Microsoft MVP, a prestigious title given to the top 100 Excel people globally, his MVP bio shows a full list of his blogs webinars, videos and more, meanwhile his LinkedIn has over 10k followers and connections. David has a YouTube channel with over 9,000 subscribers where he releases weekly videos about tech tutorials, focusing on new features.

For any queries or special dietary/accessibilty requirements contact Jo on rocklearninggib@gmail.com or whatsapp +44 7419 993491

Organized by

£324.64Sep 4 · 9:00 AM GMT+2