facebook
favorite button
dot icon
Récemment actif
super instructor icon
Professeur fiable
Ce professeur a un délai et un taux de réponse très élevé, démontrant un service de qualité et sa fidélité envers ses élèves.
member since icon
Depuis juillet 2017
Professeur depuis juillet 2017
Highly experienced tutor : Online tutoring in Financial modeling, Investment Banking, Valuation, Microsoft Excel, VBA, Algotrading in Python
course price icon
Àpd 87.14 $ /h
arrow icon
I am Dr Iyer- a tutor with a PhD in Finance and over 18 years of teaching experience as of 2023 and students from across the globe. I teach one-on-one online (over Skype/ Google Hangout and other media) using a pen tablet and the screen-share feature.

I teach from Bachelor's level to Masters level and professional certifications. I have helped several students from various parts of the world do remarkably well in several subjects like Financial modelling, Corporate Finance, Investments, Accounting, Microeconomics, CFA, FRM.

But more than that, I trust that if I can replace fear of a subject with love for it, then I would have truly made a difference to the student.
Informations supplémentaires
Topics can be customised as per student's requirement covering a wide range from Time value, financial functions, capital budgeting, DCF valuation, scenario analysis, sensitivity analysis, risk analysis, cost of capital, portfolio analysis, simulations etc.

For Students who want a higher track, I can deal with VBA/ Python programming.
Lieu
location type icon
En ligne depuis Suisse
Présentation
I am Dr Iyer. A tutor with PhD in Finance and over 18 years of teaching experience including over 18 years of online tutoring as of 2023. I have worked with students in all continents- Americas, Europe, Middle East, and Asia and thus have a good understanding of cultures and curricula followed in various parts of the world.

I have been very successful at making many students perform very well in the subjects that I have tutored, which makes me a sought after teacher. I would be able to provide you with a reference from one of my students so that you can check about my teaching.

My Approach: I believe in teaching the student and not the subject. That is adopting a teaching style that is customized to the learning style of the student. Hence I undertake only one-on-one tutoring. I am patient and friendly, yet firm. I understand student psychology and can strike a chord with students of different age groups.

Said in one line, my aim is to teach you the way I would have loved to have been taught, by making learning "alive and fun" leveraging the use of interactive technology.

Please take a look at the short video clip on my profile.
Education
I have a Masters degree in Business Administration and a doctorate in Computational Finance.

I have also hold a professional certification in Financial Risk Management.
Expérience / Qualifications
I am a freelance professional. I have taught for more than 18 years as of 2023 at all levels- school, undergraduate, postgraduate and professional certifications.
Age
Adolescents (13-17 ans)
Adultes (18-64 ans)
Seniors (65+ ans)
Niveau du Cours
Débutant
Intermédiaire
Avancé
Durée
60 minutes
90 minutes
120 minutes
Enseigné en
anglais
Commentaires
Disponibilité semaine type
(GMT -04:00)
New York
at teacher icon
Cours par webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
I am Dr Iyer- a tutor with a PhD in Finance and over 18 years of teaching experience as of 2023 and students from across the globe. I teach one-on-one online (over Zoom/ Skype/ Google Meet) using a pen tablet and the screen-share feature.

I teach from the high school level to Master's level including professional certifications. I have helped several students from various parts of the world do remarkably well in several subjects like Corporate Finance, Investments, Accounting, Microeconomics, and certifications like the CFA, FRM, ESG, SCR, Actuarial Science

Topics usually taught:
• Financial Statements Analysis
• Time Value of Money and Applications
• Bond Valuation
• Equity Valuation
• Capital Budgeting

But more than that, I trust that if I can replace fear of a subject with love for it, then I will have truly made a difference to the student.
Lire la suite
I am Dr. Iyer- a tutor with over 18 years of teaching experience as of 2023 and several hundreds of students from all parts of the globe. I teach one-on-one online over Zoom/ Skype/ Google Meet/ Teams using a pen tablet and the screen-share feature.

Depending on and tailored to the learning style of the student (visual, kinesthetic/ tactile, etc.) my teaching adopts a great deal of "Visual" or "Learn by Doing" methodology that leverages the power of web-based interactive tools so as to build a solid foundational understanding.

I have helped several students to do remarkably well in areas like Algebra, Geometry, Trigonometry, Precalculus, Calculus, Statistics.

I have experience with various syllabi and therefore, a good sense of what is emphasized by each of them. These include:
IB Diploma,
Cambridge AS and A levels,
Cambridge IGCSE,
AP Calculus,
Saxon Math
ICSE, CBSE

I also prepare students for competitive tests like the ACT, SAT, GRE, GMAT, Oxford MAT, TMUA, STEP, etc.

More than anything, I trust that if I can replace the "fear" of a subject with "love" for it, then I would have truly made a difference to the student.
Lire la suite
Voir plus
arrow icon
Cours Similaires
arrow icon previousarrow icon next
verified badge
Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations.

Why choose Microsoft Office?

Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation.

Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters.

Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management.

Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master.

Available Everywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential.


Transform the way you work, create with ease, and reach new heights with Microsoft Office.
verified badge
Repeater for over 8 years, my students are only improving their grades.

Satisfied or refunded!

Always save time for the student to bring exercises, theories, homework, failed tests and corrections ...
I am patient, used, cool, flexible and honest.

See you soon!
verified badge
The teaching methodology will be based on your course content and your objectives. My aim is primarily to help you with the concepts and application of that knowledge when submitting assignments and answering questions. I am passionate about teaching. I love sharing my knowledge and experience with my students. I am a life long learner and deeply passionate about books and learning new things. I teach students at High school, Undergraduate and Graduate levels.
verified badge
Microsoft Office skills are expected in almost every professional environment — yet most people have never been properly taught how to use these tools efficiently.
This course covers Word, Excel, and PowerPoint at whatever level you need, from basic document formatting to advanced Excel functions and automation.
Excel (most popular):

Formulas and functions (VLOOKUP, INDEX/MATCH, IF, SUMIFS, and more)
PivotTables and data analysis
Charts and professional dashboards
Macros and VBA automation — eliminate repetitive tasks entirely

Word: Professional document formatting, styles, tables, mail merge
PowerPoint: Clean, professional presentation design and structure
This is a hands-on course — we work directly on your files and your real-world tasks, not generic exercises. You'll leave each session knowing exactly how to apply what you learned to your actual work.
Ideal for students, job seekers, administrative professionals, and anyone who wants to stop wasting time on manual work.
verified badge
Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level!

If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office.

Why Choose Microsoft Office?

Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features.

Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential.

Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.
verified badge
With experience in surgical precision

📈 Private Trading Lessons – CFDs on Stocks & Stock Indices 📉

Do you want to learn how to trade the financial markets seriously and develop a real investment strategy?
I offer personalized courses adapted to your level, from beginner to more experienced trader.

🎯 Proposed program:

Understanding and using the TradingView platform

Basics and improvement of Price Action

ICT & Smart Money Concepts (SMC) methodologies

Analysis via Volume Profile and Liquidity Zones

Reading chart patterns and market structures

Risk Management and Trading Psychology

Application on CFDs on Shares and Stock Indices

✅ Objective: to make you independent in your analysis and decision-making, by developing a rigorous and professional approach with the aim of becoming profitable and profitable.

👨‍🏫 Format:

Online courses (video conferencing, screen sharing, live case studies)

Step-by-step monitoring and support


📩 Contact me now for more information or to book an initial discovery session.
verified badge
- Distance Excel courses For all levels: ONLINE-

I give Excel lessons remotely for all levels.

I offer remote Excel sessions for all levels.

I provide extensive support and well supported by the most effective learning tools.

For more information, contact me
verified badge
Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.
verified badge
Master Microsoft Office, the essential tools of the professional world!

Do you want to gain efficiency and confidence with Excel, Word, and PowerPoint? Whether you're a beginner or already familiar with the basics, my customized course will guide you step by step to become independent and efficient.

What you will learn:
Excel: from data entry and formatting to advanced formulas, pivot tables, etc.

Word: Professional document creation, styles, table of contents, mail merge, and advanced layout.

PowerPoint: Design impactful presentations, animations, and visual storytelling techniques.

Why choose this course?
✔️ Adapted progression: from total beginner to advanced user, everyone progresses at their own pace.
✔️ Practical and personalized approach: concrete exercises linked to your personal or professional projects.
✔️ Flexible: online courses, individual
✔️ Complete educational support: documents, tips and personalized follow-up between sessions.
✔️ Certified expertise: experienced trainer with an engineering background and several years of professional training
verified badge
This Forex Trading course aims to provide an in-depth understanding of the foreign exchange market and to develop a rigorous analytical methodology based on technical and fundamental principles.

The program covers:

• Introduction to the Forex market (structure, operation, participants)
• Reading and interpreting graphs (market structure, trends, accumulation/distribution phases)
• Advanced technical analysis (support and resistance levels, chart patterns, breakouts, retracements, technical indicators)
• Fundamental analysis (macroeconomic data, monetary policies, impact of central banks)
• Professional Risk Management and Money Management
• Development of a structured trading plan
• Practical case studies in real markets

Training aims :

✔ Master the basics and mechanisms of the Forex market
✔ Develop an independent technical and fundamental analysis capacity
✔ Apply disciplined and optimized capital management
✔ Build a consistent and measurable trading strategy

The training is aimed at beginners wishing to acquire a solid foundation as well as intermediate traders wishing to structure their approach professionally.
verified badge
I offer computer courses tailored to your level, using a simple, practical and personalized approach.

As a former developer with nine years of experience, I've created numerous websites for various projects: showcase sites, e-commerce sites, and professional platforms. I can assist you if you want to understand how a website works, create your own, or improve an existing project.

For adults and seniors, I also offer a progressive introduction: using a computer, the Internet, managing emails, digital security, Excel... The goal is to gain autonomy and confidence.

Each session is built around your real needs. We progress step by step, without pressure, with plenty of practice.
verified badge
Improve your writing with the expertise of an English specialist. With over ten years of experience in high-level English literature and linguistics, I help students and aspiring writers transform complex ideas into captivating prose.

For students: I offer personalized support for writing undergraduate theses. We focus on structural rigor, academic style, and careful proofreading to ensure your research meets international standards.

For creative authors: Master the art of the short story. Whether you're writing a 20-page tech thriller or a 50-page space opera, I offer in-depth coaching on building your world, developing your characters, and pacing your narrative.

My method is personalized: from the very first session, we identify your roadblocks and develop a strategy to achieve a flawless final version. Together, let's transform your drafts into professional-quality manuscripts.
verified badge
Suivi 10h00 personnalisé avec un formateur agréé & dédié en visio, évaluation entrée & sortie, progression des compétences, fiche pédagogique & certificat de réalisation

Tout public & collaborateur (assistant(e), souhaitant gagner en efficacité sur Excel et valider ses compétences par une certification reconnue.

Prérequis : Avoir des connaissances de base sur Excel (savoir saisir des données, enregistrer un fichier, effectuer des calculs simples comme l’addition).

Matériel : Ordinateur équipé d'Excel (version 2016, 2019 ou 365).

📚 Objectifs détaillés (par domaine TOSA)
1. Environnement et Méthodes
Naviguer avec fluidité dans le ruban et utiliser la barre d'outils accès rapide.

Gérer efficacement les feuilles de calcul (déplacement, copie, groupement, liaison entre feuilles).

Configurer les options d'impression complexes (zone d'impression, sauts de page, répétition des titres).

Utiliser les raccourcis clavier essentiels pour accélérer la production.

2. Calculs et Formules
Maîtriser les différents types de références (relatives, absolues $, mixtes) pour copier des formules sans erreur.

Effectuer des calculs conditionnels simples et imbriqués (Fonctions SI, SI.CONDITIONS, NB.SI, SOMME.SI).

Croiser des données issues de plusieurs tableaux (Fonctions RECHERCHEV, RECHERCHEX ou INDEX/EQUIV).

Manipuler des données textuelles et temporelles (Fonctions GAUCHE, DROITE, CONCAT, DATE, MOIS).

3. Mise en forme
Appliquer des formats de nombres personnalisés (devises, dates, pourcentages).

Mettre en place des Mises en Forme Conditionnelles (MFC) pour faire ressortir visuellement les indicateurs clés (jeux d'icônes, barres de données, formules dans les MFC).

Utiliser les styles de cellules et les thèmes pour uniformiser la présentation des documents.

4. Gestion des Données et Graphiques
Convertir des plages de données en "Tableaux de données Excel" (Tableau structuré) pour faciliter la gestion et les calculs automatiques.

Trier et filtrer les données (filtres avancés, segments).

Synthétiser de grands volumes de données grâce aux Tableaux Croisés Dynamiques (TCD) : groupements, champs calculés, pourcentages.

Illustrer les données par des graphiques pertinents (histogrammes, courbes, secteurs, graphiques combinés) et les mettre en forme professionnellement.

5 Automatisation

De la mise en forme

🎓 Modalités d'évaluation
Des connaissances acquises précédemment par l’apprentissage, l’étude ou l’expérience

Continue : Cas pratiques et exercices, Quizz, etc, tout au long de la formation avec le formateur, accompagné de la plateforme www.behahu.eu.

Des nouvelles connaissances
Un rapport de progression est délivré à l'apprenant à l'issue
verified badge
Maîtrisez les outils essentiels de la suite Microsoft Office pour booster votre productivité. Ce cours pratique vous enseigne à créer des documents impeccables sur Word, à concevoir des présentations percutantes sur PowerPoint et surtout à dompter Excel, de la gestion de données aux formules complexes. Adaptée à tous les niveaux, ma méthode repose sur des exercices concrets pour vous rendre autonome rapidement. Gagnez en efficacité professionnelle et transformez votre manière de travailler.
verified badge
I support those who want to become profitable, as well as beginner traders who want to progress. My goal is simple: to improve your strategy and mindset so you can go further and reach a concrete milestone in your trading.
My approach is based on comprehensive support to guide you through to obtaining your first funded account. I guide you step by step through the Prop Firm validation processes (such as Take Profit Trader) to enable you to trade with substantial capital.
I also offer a trading journal analysis service for more advanced traders.
message icon
Contacter Dr. Iyer
repeat students icon
Le premier cours est couvert par notre Garantie Le-Bon-Prof
Cours Similaires
arrow icon previousarrow icon next
verified badge
Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations.

Why choose Microsoft Office?

Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation.

Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters.

Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management.

Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master.

Available Everywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential.


Transform the way you work, create with ease, and reach new heights with Microsoft Office.
verified badge
Repeater for over 8 years, my students are only improving their grades.

Satisfied or refunded!

Always save time for the student to bring exercises, theories, homework, failed tests and corrections ...
I am patient, used, cool, flexible and honest.

See you soon!
verified badge
The teaching methodology will be based on your course content and your objectives. My aim is primarily to help you with the concepts and application of that knowledge when submitting assignments and answering questions. I am passionate about teaching. I love sharing my knowledge and experience with my students. I am a life long learner and deeply passionate about books and learning new things. I teach students at High school, Undergraduate and Graduate levels.
verified badge
Microsoft Office skills are expected in almost every professional environment — yet most people have never been properly taught how to use these tools efficiently.
This course covers Word, Excel, and PowerPoint at whatever level you need, from basic document formatting to advanced Excel functions and automation.
Excel (most popular):

Formulas and functions (VLOOKUP, INDEX/MATCH, IF, SUMIFS, and more)
PivotTables and data analysis
Charts and professional dashboards
Macros and VBA automation — eliminate repetitive tasks entirely

Word: Professional document formatting, styles, tables, mail merge
PowerPoint: Clean, professional presentation design and structure
This is a hands-on course — we work directly on your files and your real-world tasks, not generic exercises. You'll leave each session knowing exactly how to apply what you learned to your actual work.
Ideal for students, job seekers, administrative professionals, and anyone who wants to stop wasting time on manual work.
verified badge
Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level!

If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office.

Why Choose Microsoft Office?

Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features.

Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential.

Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.
verified badge
With experience in surgical precision

📈 Private Trading Lessons – CFDs on Stocks & Stock Indices 📉

Do you want to learn how to trade the financial markets seriously and develop a real investment strategy?
I offer personalized courses adapted to your level, from beginner to more experienced trader.

🎯 Proposed program:

Understanding and using the TradingView platform

Basics and improvement of Price Action

ICT & Smart Money Concepts (SMC) methodologies

Analysis via Volume Profile and Liquidity Zones

Reading chart patterns and market structures

Risk Management and Trading Psychology

Application on CFDs on Shares and Stock Indices

✅ Objective: to make you independent in your analysis and decision-making, by developing a rigorous and professional approach with the aim of becoming profitable and profitable.

👨‍🏫 Format:

Online courses (video conferencing, screen sharing, live case studies)

Step-by-step monitoring and support


📩 Contact me now for more information or to book an initial discovery session.
verified badge
- Distance Excel courses For all levels: ONLINE-

I give Excel lessons remotely for all levels.

I offer remote Excel sessions for all levels.

I provide extensive support and well supported by the most effective learning tools.

For more information, contact me
verified badge
Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.
verified badge
Master Microsoft Office, the essential tools of the professional world!

Do you want to gain efficiency and confidence with Excel, Word, and PowerPoint? Whether you're a beginner or already familiar with the basics, my customized course will guide you step by step to become independent and efficient.

What you will learn:
Excel: from data entry and formatting to advanced formulas, pivot tables, etc.

Word: Professional document creation, styles, table of contents, mail merge, and advanced layout.

PowerPoint: Design impactful presentations, animations, and visual storytelling techniques.

Why choose this course?
✔️ Adapted progression: from total beginner to advanced user, everyone progresses at their own pace.
✔️ Practical and personalized approach: concrete exercises linked to your personal or professional projects.
✔️ Flexible: online courses, individual
✔️ Complete educational support: documents, tips and personalized follow-up between sessions.
✔️ Certified expertise: experienced trainer with an engineering background and several years of professional training
verified badge
This Forex Trading course aims to provide an in-depth understanding of the foreign exchange market and to develop a rigorous analytical methodology based on technical and fundamental principles.

The program covers:

• Introduction to the Forex market (structure, operation, participants)
• Reading and interpreting graphs (market structure, trends, accumulation/distribution phases)
• Advanced technical analysis (support and resistance levels, chart patterns, breakouts, retracements, technical indicators)
• Fundamental analysis (macroeconomic data, monetary policies, impact of central banks)
• Professional Risk Management and Money Management
• Development of a structured trading plan
• Practical case studies in real markets

Training aims :

✔ Master the basics and mechanisms of the Forex market
✔ Develop an independent technical and fundamental analysis capacity
✔ Apply disciplined and optimized capital management
✔ Build a consistent and measurable trading strategy

The training is aimed at beginners wishing to acquire a solid foundation as well as intermediate traders wishing to structure their approach professionally.
verified badge
I offer computer courses tailored to your level, using a simple, practical and personalized approach.

As a former developer with nine years of experience, I've created numerous websites for various projects: showcase sites, e-commerce sites, and professional platforms. I can assist you if you want to understand how a website works, create your own, or improve an existing project.

For adults and seniors, I also offer a progressive introduction: using a computer, the Internet, managing emails, digital security, Excel... The goal is to gain autonomy and confidence.

Each session is built around your real needs. We progress step by step, without pressure, with plenty of practice.
verified badge
Improve your writing with the expertise of an English specialist. With over ten years of experience in high-level English literature and linguistics, I help students and aspiring writers transform complex ideas into captivating prose.

For students: I offer personalized support for writing undergraduate theses. We focus on structural rigor, academic style, and careful proofreading to ensure your research meets international standards.

For creative authors: Master the art of the short story. Whether you're writing a 20-page tech thriller or a 50-page space opera, I offer in-depth coaching on building your world, developing your characters, and pacing your narrative.

My method is personalized: from the very first session, we identify your roadblocks and develop a strategy to achieve a flawless final version. Together, let's transform your drafts into professional-quality manuscripts.
verified badge
Suivi 10h00 personnalisé avec un formateur agréé & dédié en visio, évaluation entrée & sortie, progression des compétences, fiche pédagogique & certificat de réalisation

Tout public & collaborateur (assistant(e), souhaitant gagner en efficacité sur Excel et valider ses compétences par une certification reconnue.

Prérequis : Avoir des connaissances de base sur Excel (savoir saisir des données, enregistrer un fichier, effectuer des calculs simples comme l’addition).

Matériel : Ordinateur équipé d'Excel (version 2016, 2019 ou 365).

📚 Objectifs détaillés (par domaine TOSA)
1. Environnement et Méthodes
Naviguer avec fluidité dans le ruban et utiliser la barre d'outils accès rapide.

Gérer efficacement les feuilles de calcul (déplacement, copie, groupement, liaison entre feuilles).

Configurer les options d'impression complexes (zone d'impression, sauts de page, répétition des titres).

Utiliser les raccourcis clavier essentiels pour accélérer la production.

2. Calculs et Formules
Maîtriser les différents types de références (relatives, absolues $, mixtes) pour copier des formules sans erreur.

Effectuer des calculs conditionnels simples et imbriqués (Fonctions SI, SI.CONDITIONS, NB.SI, SOMME.SI).

Croiser des données issues de plusieurs tableaux (Fonctions RECHERCHEV, RECHERCHEX ou INDEX/EQUIV).

Manipuler des données textuelles et temporelles (Fonctions GAUCHE, DROITE, CONCAT, DATE, MOIS).

3. Mise en forme
Appliquer des formats de nombres personnalisés (devises, dates, pourcentages).

Mettre en place des Mises en Forme Conditionnelles (MFC) pour faire ressortir visuellement les indicateurs clés (jeux d'icônes, barres de données, formules dans les MFC).

Utiliser les styles de cellules et les thèmes pour uniformiser la présentation des documents.

4. Gestion des Données et Graphiques
Convertir des plages de données en "Tableaux de données Excel" (Tableau structuré) pour faciliter la gestion et les calculs automatiques.

Trier et filtrer les données (filtres avancés, segments).

Synthétiser de grands volumes de données grâce aux Tableaux Croisés Dynamiques (TCD) : groupements, champs calculés, pourcentages.

Illustrer les données par des graphiques pertinents (histogrammes, courbes, secteurs, graphiques combinés) et les mettre en forme professionnellement.

5 Automatisation

De la mise en forme

🎓 Modalités d'évaluation
Des connaissances acquises précédemment par l’apprentissage, l’étude ou l’expérience

Continue : Cas pratiques et exercices, Quizz, etc, tout au long de la formation avec le formateur, accompagné de la plateforme www.behahu.eu.

Des nouvelles connaissances
Un rapport de progression est délivré à l'apprenant à l'issue
verified badge
Maîtrisez les outils essentiels de la suite Microsoft Office pour booster votre productivité. Ce cours pratique vous enseigne à créer des documents impeccables sur Word, à concevoir des présentations percutantes sur PowerPoint et surtout à dompter Excel, de la gestion de données aux formules complexes. Adaptée à tous les niveaux, ma méthode repose sur des exercices concrets pour vous rendre autonome rapidement. Gagnez en efficacité professionnelle et transformez votre manière de travailler.
verified badge
I support those who want to become profitable, as well as beginner traders who want to progress. My goal is simple: to improve your strategy and mindset so you can go further and reach a concrete milestone in your trading.
My approach is based on comprehensive support to guide you through to obtaining your first funded account. I guide you step by step through the Prop Firm validation processes (such as Take Profit Trader) to enable you to trade with substantial capital.
I also offer a trading journal analysis service for more advanced traders.
Garantie Le-Bon-Prof
favorite button
message icon
Contacter Dr. Iyer