Excel Workshop – Lorenzo Bezzi, Senior Associate Consultant @Bain

The first Viral Talk of this new academic year was a great success!

Lorenzo Bezzi, Senior Associate Consultant at Bain, held an excel workshop showing most of the tools, and tricks, used in his daily tasks. Starting from a  reproduction of a company database, he showed how and when excel tools can be applied to perform in-depth data analysis. Here follows his workshop recap:

  • SUMIFS, AVERAGEIFS, COUNTIFS, IF, COUNTA, VLOOKUP, INDEX, MATCH, IRR
  • Lists (Data Validation to create specific data views), Goal Seek (What-if-Analysis),  Scenario Analysis (What-if-Analysis), Pivot Table

 

Don’t forget to sign up to our Microsoft Teams channel where all the Viral Talks are organised. Please contact us if you don’t know how to do that. Remember: the entire workshop material has been shared on the Teams channel.

If you don’t want to miss any opportunity to build up your skills, follow the Mentorship Program Instagram page (“Clamdaalumni”) and keep up-to-date with the coming workshops and talks.

Stay tuned  and in case you want to be our next guest speaker just reach out to us 😉

 

 

 

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments