It’s hard to pick formula favourites but we’re going to give it a go. Excel trainer Alan Murray streaming live from London explains what he loves about the SUMPRODUCT, SUMIFS and INDEX functions (and maybe a few more!)

Alan is an Excel trainer, YouTuber and freelance writer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. Alan runs his own blog – Computergaga and also writes for the HowTo Geek and GoSkills websites. He runs a monthly Excel meetup in London where ‘Excel people’ and go, share and help each other. Alan has a YouTube channel with over 500 videos and over 20 million views. Alan contributes to his channel regularly to share the latest Excel developments and techniques that he stumbles upon.

Register here for more virtual meetup events.