1er cours offert
Le profil de Chandan, son diplôme et ses coordonnées ont été vérifiés par nos experts
Chandan
- Tarif 20€
- Réponse 1h
-
Élèves13
Nombre d'élèves que Chandan a accompagné depuis son arrivée sur Superprof
Nombre d'élèves que Chandan a accompagné depuis son arrivée sur Superprof
20€/h
Contacter
1er cours offert
- Maths
- Algèbre
- Géométrie
- Statistiques
- Informatique scolaire
Data Analyst provides training and development sessions for Excel, VBA and Python from Beginner to Advanced level
- Maths
- Algèbre
- Géométrie
- Statistiques
- Informatique scolaire
Lieux du cours
-
Chez Chandan : Lozanne
- webcam
-
chez vous ou lieu public : déplacement jusqu'à 20 km depuis Lozanne
-
Recommandé
Chandan un professeur apprécié par sa communauté. Il a été recommandé pour son sérieux, sa pédagogie et la qualité de ses cours. Un bon choix pour progresser en toute confiance.
À propos de Chandan
Before the enrollment of Master, I was a teacher of Information and communication technology and I love to share my knowledge with others with a lot of patience. I am the one to whom you can assign your goals and be free, you will achieve them.
voir plus
À propos du cours
- Primaire
- Collège
- Seconde
- +5
niveaux :
Primaire
Collège
Seconde
Première
Terminale
BTS
Supérieur
Formation pour adultes
- Français
Toutes les langues parlées pour le cours :
Français
Data Analyst
EXCEL Training & Development
First hour free to get to know each other!
Let's say that...
My courses are aimed at all levels: beginner, intermediate or advanced (PC or MAC)
to all sectors: administrative, accounting, purchasing, logistics, finance, engineering, HR, education...
to all professions: executive assistant, salesperson, employee, supervisor, project manager, manager, entrepreneur, leader, student...
My lessons take place face-to-face or remotely on Zoom, all with a lot of lightness :) no loss of energy because we will directly approach theory and practice on the concepts that interest you. We will always favor the simplest method to remember to solve a problem.
You will also find a detailed program below.
My teaching philosophy can be summed up in 3 words:
Discover, Understand, Remember.
Many practical exercises are available, concrete and adapted to the learner's environment because repetition reinforces!
My teaching asset is the clarity of explanation because I systematically use many examples as well as images or diagrams.
The courses and concepts covered are always preceded by:
"What is it for? Why do it? When to do it? Who can do it? and How to do it?"
I insist on the "business" aspect of the learner and adapt to his needs with the possibility of working on the student's files.
I attach extreme importance to the visual rendering because I think that what differentiates:
the "good" result and the "best" result...
is the detail!
Color consistency and intuitiveness.
Precise, clear and refined data like Alaska!
The sessions will always include various time-saving tips (shortcuts, methods and others). We focus on the strengths of Excel that will really serve in the field.
The lessons are optimized because the explanatory notes and the follow-up of each lesson are entered directly by myself under the eyes of the student. Thus, the learner remains focused and the risk of errors in note taking will be eliminated.
The first half hour is free because it is important to make sure that my profile meets the needs of the learner and that we can progress together :)
Building a program tailored to the student
My teaching experience and my sociability will naturally accompany each of the sessions.
EXCEL KEYS & NOTIONS PROPOSED
AT BEGINNERS LEVEL:
TOP! TO MANAGE THE BASICS OF AN ACTIVITY
[ Work on small Excel tables with the correct number of cells, approximately the size of your pc screen ]
- WHAT IS A CELL, A RANGE, THE RIBBON?
- DISCOVERING THE RIBBON
- THE 2 OR 3 MOST IMPORTANT MENUS TO MASTER
- THE MAIN WIDGETS/BUTTONS
- BUILDING A SIMPLE TABLE -
QUICKLY FORMATTING A TABLE
- SIMPLE CALCULATION FORMULAS (Sum, average, max,
min)
- INCREMENT THESE CALCULATIONS ON NEIGHBORING CELLS
- USE ABSOLUTE REFERENCES ($A$1)
- SIMPLE DROPDOWN - GENERATE
COOL GRAPHICS AND KNOW PRINT CLEANLY.
(histogram, curves, pie chart)
INTERMEDIATE LEVEL:
TOP! TO SAVE TIME AND PRESENT WELL DURING MEETINGS :)
[ Work on large Excel tables, i.e. hundreds of rows or columns, spread over several different spreadsheets]
- MOVE IN A LARGE EXCEL TABLE
- LIKE A PRO
- KEYBOARD SHORTCUTS , "ACHIEVE" FUNCTION
- ADVANCED EXCEL CALCULATIONS
- AUTOMATE AND LINK ENTIRE SHEETS
- IF FUNCTION, CONDITIONAL FUNCTIONS
(COUNTIF, SUMIF.TOK)
- MIXED REFERENCES (A$1) TO EXTEND YOUR FORMULAS
IN ALL DIRECTIONS!
- SMART OR CASCADING DROPDOWN LISTS - ARRAY
FORMULAS
- V SEARCH, H SEARCH
- USE OF FILTERS AND
SORTS - CONDITIONAL FORMATTING WHEN A CELL CHANGES COLOR AUTOMATICALLY
- DYNAMIC CROSS TABLES AND GRAPHS.
(stacked histogram, scatter plots,
boxplot)
EXPERT LEVEL:
TOP! TO OPTIMIZE AND ANALYZE A MANAGEMENT LEVEL ACTIVITY
[ Work on real Database either thousands of rows or columns and spread over several different workbooks/files ]
- IF ADVANCED, NESTED OR MULTIPLE FUNCTIONS
- ADVANCED CONDITIONAL FORMATTING WHEN THE
ENTIRE ROW OR OTHERS CHANGES COLORS
AUTOMATICALLY
- STATISTICAL GRAPHS (Boxplot, scatterplot,
geographical maps graph)
- INDEX AND MATCH FUNCTION OR X SEARCH
- CREATE DASHBOARDS WITH KPI OR DASHBOARD INDICATORS - LOTS OF BEAUTIFUL COLORS
- OPTIMIZE AND SECURE YOUR SPREADSHEETS
- FIGHT AGAINST FILE SLOWNESS
- INTELLIGENTLY MERGE SEVERAL
EXCEL SHEETS TOGETHER AND GET
ONLY ONE OF THEM (INTERNAL-JOIN/EXTERNAL/LEFT/RIGHT)
- PROGRAM MACROS WITH THE RECORDER
- CODE IN VBA WITH THE CODE EDITOR.
- CREATE INTUITIVE FORMS IN VBA
Example of possible VBA macros:
Program a customer follow-up on a list of invoices due on a date of your choice.
In 1 mouse click, your macro analyzes, sorts and selects the customer lines to follow up.
Your macro automatically opens emails on Outlook for the attention of the recipient(s), concerned.
Your macro also fills in the body of the email, personalizes the subject of each email and adds its follow-up attachment.
After drinking your coffee,
it remains to check each email and click on "send"
Considerable time saving (Tested at EDF)
BONUS - DATA ANALYSIS IN PYTHON:
Use Python language for Excel
(Even more precise and faster than VBA)
BUT ALSO:
POWER QUERY - Cleaning of data in excel, csv, json etc format
POWER BI - Business Intelligence to restore data in dynamic Dashboard - graphics! all connected to each other
POWERPOINT - Present data on clean, dynamic and captivating slides.
USE PANDAS LIBRARY AND JUPYTER NOTEBOOK WITH EXCEL.
(TO HANDLE AND DISPLAY LARGE VOLUMES OF DATA)
- Extract Excel or CSV files
- Rework these same files with the Python language
- Clean the data
- Concatenate, join tables, internal, external
etc
- Reinject the reworked file on Excel
- All at the press of a single button
- Extremely precise and powerful
voir plus
Recommandations
Les recommandations proviennent des proches et des connaissances de ce professeur de Maths.
3
Il est très bon professeur de data analyst.
Il fait des project selon du niveau d'études.
Comme je suis débutant, il donne conseils pour trouver le boulot.Mr. Chandan is very nice professor, he kept believing in me and today, i am confident to work with my team for Data Analyst. Thank you Mr. Chandan.
Bonjour
Je suis très contente, de l'aide apportée par Chandan.
Il est à l'écoute, disponible, et donne de bons conseils.
N'hésitez pas, si vous avez besoin de vous faire aider. Je le contacterais à nouveau, en cas de besoin.Voir plus de recommandations
voir plus
Tarifs
Tarif
- 20€
Tarifs packs
- 5h : 100€
- 10h : 200€
webcam
- 8€/h
cours offert
Chandan offre son premier cours, il vous permettra de pratiquer votre première leçon et d'adapter vos besoins à vos prochains cours
- 1h
Professeurs de Maths similaires
Quentin
Lozanne & webcam
- 18€/h
- 1er cours offert
Totti
Fleurieux-sur-l'Arbresle & webcam
- 50€/h
- 1er cours offert
Philippe
Fleurieux-sur-l'Arbresle & webcam
- 20€/h
- 1er cours offert
Malo
Lentilly & webcam
- 25€/h
- 1er cours offert
Thomas
Lentilly & webcam
- 22€/h
- 1er cours offert
Hadjer
Morancé & webcam
- 35€/h
- 1er cours offert
Alix
La Tour-de-Salvagny & webcam
- 25€/h
- 1er cours offert
Coraline
La Tour-de-Salvagny & webcam
- 20€/h
- 1er cours offert
Anaïs
La Tour-de-Salvagny & webcam
- 20€/h
- 1er cours offert
Marie
Les Chères & webcam
- 23€/h
ELIANE
L'Arbresle & webcam
- 20€/h
- 1er cours offert
Asmae
L'Arbresle & webcam
- 17€/h
- 1er cours offert
Isabelle
Bully & webcam
- 25€/h
- 1er cours offert
Raphaël
Tassin-la-Demi-Lune & webcam
- 85€/h
Victor
Écully & webcam
- 30€/h
Chloé
Lentilly & webcam
- 20€/h
- 1er cours offert
Enora
Lentilly & webcam
- 20€/h
- 1er cours offert
Ptashanna
Lyon & webcam
- 100€/h
- 1er cours offert
Chlea
Dardilly & webcam
- 15€/h
- 1er cours offert
Tony
Saint-Pierre-la-Palud
- 20€/h
- 1er cours offert
-
Voir les professeurs de maths
