Skip to main content
About HEC About HEC Faculty & Research Faculty & Research Master’s programs Master’s programs MBA Programs MBA Programs PhD Program PhD Program Executive Education Executive Education Summer School Summer School HEC Online HEC Online About HEC Overview Overview Who We Are Who We Are Egalité des chances Egalité des chances Career Center Career Center International International Campus Life Campus Life Stories Stories The HEC Foundation The HEC Foundation Coronavirus Coronavirus Faculty & Research Overview Overview Faculty Directory Faculty Directory Departments Departments Centers Centers Chairs Chairs Knowledge Knowledge Master’s programs Master in
Management Master in
MSc International
Finance MSc International
Masters Specialized
programs X-HEC
programs Dual-Degree
Visiting students Visiting students Certificates Certificates Student Life Student Life
MBA Programs MBA MBA Executive MBA Executive MBA TRIUM EMBA TRIUM EMBA PhD Program Overview Overview HEC Difference HEC Difference Program details Program details Research areas Research areas HEC Community HEC Community Placement Placement Job Market Job Market Admissions Admissions Financing Financing Executive Education Executive Masters Executive Masters Executive Certificates Executive Certificates Executive short programs Executive short programs Online Online Train your teams Train your teams Executive MBA Executive MBA Summer School Youth Leadership Initiative Youth Leadership Initiative Summer programs Summer programs Admissions Admissions FAQ FAQ HEC Online Overview Overview Degree Program Degree Program Executive certificates Executive certificates MOOCs MOOCs


M1 Core Courses

A deep knowledge of Excel and modeling is essential to produce useful and efficient work with spreadsheets.

  • Advanced modeling with spreadsheets
  • Enlarge the scope of students’ view of Excel’s capabilities.
  • Important functions such as Offset(), Indirect(), Sumif(), Row(), Rows(), Countif() and more
  • Relative names
  • Troubleshooting a spreadsheet
  • Error handling
  • Linking between sheets or workbooks, consolidation
  • Working with dates
  • Working with text
  • Advanced work with databases
  • Advanced work with pivot tables (Tableaux croisés dynamiques in French)
  • Array functions
  • Recording and modifying a macro.