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