Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
This lecture covers advanced Excel functions and data analysis techniques, including automatic recording, inserting functions, formatting cells, using formulas, creating custom formats, managing names, protecting data, and using Solver for data analysis. The lecture also includes practical exercises on creating pivot tables, applying conditional formatting, and using Power Query to obtain and manipulate data.