Chandan - Prof de maths - Lozanne
1er cours offert
Chandan - Prof de maths - Lozanne

Le profil de Chandan, son diplôme et ses coordonnées ont été vérifiés par nos experts

Chandan

  • Tarif 202 870 Ar
  • Réponse 1h
  • Élèves

    Nombre d'élèves que Chandan a accompagné depuis son arrivée sur Superprof

    16

    Nombre d'élèves que Chandan a accompagné depuis son arrivée sur Superprof

Chandan - Prof de maths - Lozanne
  • 5 (3 évaluations)

202 870 Ar/h

1er cours offert

Contacter

1er cours offert

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

Recommandé

Chandan 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
  • Anglais

Toutes les langues parlées pour le cours :

Français

Anglais

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

Tarifs

Tarif

  • 202 870 Ar

Tarifs packs

  • 5h : 912 915 Ar
  • 10h : 1 521 525 Ar

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

webcam

  • 152 152Ar/h

Professeurs de Maths similaires

SuperprofCours particuliersCours particuliers de maths Cours particuliers d'algèbre Cours particuliers de géométrie Cours particuliers de statistiques Cours particuliers d'informatique scolaire
Voir tous les professeurs

Diplôme vérifié

Le profil de Chandan, son diplôme et ses coordonnées ont été vérifiés par nos experts

niveaux

Primaire

Collège

Seconde

Première

Terminale

BTS

Supérieur

Formation pour adultes

Toutes les langues parlées pour le cours

Français

Anglais

Avis

Tous nos avis sont contrôlés par nos services et sont fiables à 100%. Elles correspondent à une vraie expérience vécue par les élèves avec Chandan.

Évaluations

Les évaluations regroupent tous les avis certifiés
ainsi que les recommandations laissées sur Chandan

Recommandations

Les recommandations proviennent des proches et des connaissances de ce professeur de Maths.

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

Signaler cette annonce

Décrivez le problème constaté sur cette annonce

À propos
Matières
Villes
Blogs & Aide