Excel pour Managers

Catalog of Institut Mines-Télécom Business School courses

Code

MUFF INF 3003

Level

L3

Field

Informatique

Language

Français/French

ECTS Credits

4

Class hours

24

Total student load

80

Program Manager(s)

Department

  • Technologies, Information et Management

Educational team

Introduction to the module

L'objectif pédagogique de ce cours est de fournir aux étudiants une connaissance des outils de productivité individuels. L’étudiant devra apprendre à maîtriser le tableur EXCEL afin de résoudre des problèmes entrepreneuriaux.
Il s'agira de résoudre divers problèmes de Management (Marketing, Finance, Comptabilité, Logistique, RH…). Les étudiants devront être capables de modéliser des problèmes décisionnels en utilisant les fonctions de base et les fonctions avancées pour réaliser des simulations et aider à la prise de décision.

Learning goals/Programme objectives

  • LG1 Being able to extend digital intelligence through its different dimensions
  • LG2 Having the ability to manage uncertainty and complexity with accuracy and rigor
  • LG4 Having access to different cross disciplinary management approaches and tools

Learning objectives/Intended learning outcomes

  • 1.2 - Develop digital creativity for the individual and the organizational
  • 1.3 - Develop competitiveness in business, and digital sovereignty
  • 2.1 - Identify and analyze in depth problems, causes and impacts
  • 2.2 - Explore solutions, decisions, and their relative and absolute impacts
  • 2.3 - Identify optimal solution(s) and priorities toward implementation
  • 4.2 - Understand and employ cross-disciplinary concepts, knowledge, theories

Rubrics

Concevoir et développer des services numériques en fonction des besoins métiers.
Il s'agira de résoudre divers problèmes de Management (Marketing, Finance, Comptabilité, Logistique, RH…) ,via les fonctionnalités avancées du tableur EXCEL.

Content : structure and schedule

1 séance par semaine.
SEANCE 1
Outils et fonctions de base d’EXCEL :
Adresses relatives absolues mixtes
Création de graphiques
La fonction SI SOMME MOYENNE...
SEANCE 2
La fonction RECHERCHEV RECHERCHEH LIGNE....
SEANCE 3
Les listes de données Les tableaux croisés dynamiques
SEANCE 4
Création de modèle de simulation
Recherche d’un optimum : le solveur
Modélisation d’un problème de Marketing et logistique
SEANCE 5
Fonctions financières : VAN TRI (analyse financière)
Fonctions financières (suite) : création d’échéanciers de remboursements d’emprunts : INTPER PRINCPER VPM

Sustainable Development Goals

Industrie, Innovation et Infrastructure

Number of SDG's addressed among the 17

1

Learning delivery

synchrone

Pedagogical methods

Différentes approches pédagogiques sont utilisées : Cours, Travaux Dirigés, Travaux individuels, évaluation par les pairs.

Evaluation and grading system and catch up exams

The evaluation consists of an examination (CF). This evaluation can take place in person or remotely. There are also assignments between sessions.
The evaluation is built on homework between each session which prepares for the final exam.
The final grade corresponds to the grade of the exam (CF1).
In case of a make-up, an exam (CF2) will be offered and will replace the CF1 grade.

Module Policies

Professor-Student Communication
● The professor will contact the students through their school email address (IMT-BS/TSP) and the Moodle portal. No communication via personal email addresses will take place. It is the student responsibility to regularly check their IMT-BS/TSP mailbox.
● Students can communicate with the professor by emailing him/her to his institutional address. If necessary, it is possible to meet the professor in his office during office-hours or by appointment.

Students with accommodation needs
If a student has a disability that will prevent from completing the described work or require any kind of accommodation, he may inform the program director (with supporting documents) as soon as possible. Also, students are encouraged to discuss it with the professor.

Class behavior
● Out of courtesy for the professor and classmates, all mobile phones, electronic games or other devices that generate sound should be turned off during class.
● Students should avoid disruptive and disrespectful behavior such as: arriving late, leaving early, careless behavior (e.g. sleeping, reading a non-course material, using vulgar language, over-speaking, eating, drinking, etc.). A warning may be given on the first infraction of these rules. Repeated violators will be penalized and may face expulsion from the class and/or other disciplinary proceedings.
● The tolerated delay is 5 minutes. Attendance will be declared on Moodle during these 5 minutes via a QR code provided by the teacher at each course start.
● Student should arrive on time for exams and other assessments. No one will be allowed to enter the classroom once the first person has finished the exam and left the room. There is absolutely no exception to this rule. No student can continue to take an exam once the time is up. No student may leave the room during an examination unless he / she has finished and handed over all the documents.
● In the case of remote learning, the student must keep his camera on unless instructed otherwise by the professor.

Honor code
IMT-BS is committed to a policy of honesty in the academic community. Conduct that compromises this policy may result in academic and / or disciplinary sanctions. Students must refrain from cheating, lying, plagiarizing and stealing. This includes completing your own original work and giving credit to any other person whose ideas and printed materials (including those from the Internet) are paraphrased or quoted directly. Any student who violates or helps another student violate academic behavior standards will be penalized according to IMT-BS rules.

Textbook Required and Suggested Readings

• Microsoft 365 et Teams : Les bonnes pratiques pour collaborer et travailler en équipe (Coffret de 2 livres)
Auteur : Gilles Balmisse
Nb pages : 586 pages, Editeur : ENI ,2021
ISBN : 978-2409030116
• Les nouveaux outils bureautiques gratuits: Collaborer, échanger et s'organiser avec les outils du web
Auteurs : Christophe Blazquez, Samir Zamoum
Nb pages : 171 pages, Editeur : Gereso ,2021
ISBN : 978-2359534085
• Office 2016 : Pack Office 2016 Word/Excel/PowerPoint Outils collaboratifs et d'animation
Auteur : Marie-Elisabeth Charre
Nb pages : 192 pages, Editeur : Fontaine Picard ,2017
ISBN : 978-2744628931
• Analysez efficacement vos données à l'aide des tableaux croisés dynamiques (versions 2019 et Office 365)
Auteur : Pierre Rigollet
Nb pages : 316 pages, Editeur : ENI ,2020
ISBN : 978-2409025945

Keywords

outils de productivité individuels, EXCEL, bureautique, résolution de problèmes, modélisation de problèmes décisionnels avec outils