Translated by GoogleSee original

Excel pour l’analyse de données : bases et premiers tableaux de bord

From 18 C$ /h

Vous voulez analyser vos données avec Excel, sans vous perdre dans les formules ? Ce cours en ligne vous guide pas à pas, avec des exemples concrets et des exercices pratiques.

Vous apprendrez à :

organiser et nettoyer vos données (tri, filtres, suppression des doublons)
utiliser les formules essentielles (SOMME, SI, NB.SI, MOYENNE, RECHERCHEV / RECHERCHEX)
résumer vos données avec les tableaux croisés dynamiques
créer des graphiques clairs et présenter vos résultats

Le cours s’adapte à votre niveau et à vos besoins (études, travail, projet personnel). Je suis data analyst et j’utilise l’analyse de données au quotidien, ce qui me permet de vous montrer des cas pratiques.

Extra information

Prévoir un ordinateur avec Excel installé et une connexion internet stable. Si vous avez vos propres fichiers de données, vous pouvez les apporter pour travailler dessus.

Location

Online from Morocco

About Me

👋 Hello! My name is Hayat, passionate about programming, algorithmic logic... and languages! 🌟

With a Master's degree in modeling, scientific computing, and data science, I offer personalized courses in Python and algorithms, for all levels—from beginner to advanced.
My goal is to make each concept simple, clear and concrete, through practical examples and fun projects that develop your logical thinking and programming skills.

And because I also love sharing the richness of languages, I offer Arabic courses for foreigners, designed to teach you how to communicate easily while discovering Arab culture methodically and with pleasure.

✨ In summary: accessible, friendly and motivating courses, to learn to code, reason and speak Arabic with confidence! 🙌

Education

With a Bac+5 degree focused on advanced numerical methods, data analysis and machine learning applications, I have a solid scientific background allowing me to link theory, modeling and practice to solve complex problems effectively.

Experience / Qualifications

I gained hands-on experience through several internships focused on machine learning and artificial intelligence, including time series forecasting, real-time modeling, and AI image analysis.
I am proficient in Python, data analysis and mathematical modeling, with an approach that is both rigorous and oriented towards practical application.
I also have solid experience in tutoring, which has allowed me to develop a clear and accessible pedagogy to explain complex mathematical concepts.
Thanks to my in-depth training in statistics, algorithms and scientific computing, I know how to combine theory and practice in order to effectively solve various problems.

Age

Children (7-12 years old)

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Duration

60 minutes

The class is taught in

French

Arabic

English

Skills

Microsoft excel

Reviews

Availability of a typical week

(GMT -04:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Private Mathematics Tutoring – Middle School & High School (Morocco & International)

21 C$ /h

I have a degree in Modeling and Scientific Computing, with a strong background in mathematics and data science.

I offer private tutoring to help middle and high school students with:

Understanding the mathematical concepts of the curriculum

Succeeding in homework and exams

Prepare effectively for the Baccalaureate or other assessments

Follow the Moroccan or international program

Lessons are tailored to each student's level and pace, with clear explanations and practical exercises for rapid progress. I teach online via webcam, offering complete flexibility.

Learn Arabic for Foreigners – Reading, Writing and Conversation

16 C$ /h

This course is designed for anyone interested in learning Arabic, whether you're a complete beginner or looking to improve your skills. We'll gradually cover reading, writing, correct pronunciation, and oral communication skills through practical situations. The emphasis is on comprehension, practice, and the joy of learning a rich and vibrant language.

You will learn to:

Reading and writing the Arabic alphabet

Form simple words and sentences

Express yourself orally in everyday situations (introducing yourself, asking for directions, etc.)

Better understand the culture linked to language

Matías

4.88

(85)

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.

Salah

4.88

(85)

Do you aspire to maximum efficiency, limitless creativity and unparalleled productivity in the Gulf region? Let us guide you to excellence with Microsoft Office.

Why Choose Microsoft Office?

Harness Your Creativity: With Word, Excel, PowerPoint and more, you'll have powerful tools to bring your projects to life, whether creating corporate documents, developing cutting-edge financial tables or delivering presentations breathtaking.

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

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

Join the Microsoft Office Revolution!

Do not accept compromises in your daily professional life. Invest in the power of Microsoft Office and unlock your full potential.

Transform the way you work, create with ease, and reach new heights with Microsoft Office. Register now to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint at all levels and drive your business to excellence in the Gulf region.

Ikrami

4.88

(85)

I would guide you step by step to get familiarised with the tools of Microsoft Office programmes (Word, Excel, and PowerPoint) that you believe you might need to meet your purposes. Your level of experience will determine where we start and how we proceed through the course.
Contact me

Morad

4.88

(85)

You want to boost your Excel skills and unlock the full power of spreadsheets? Our online Excel classes are designed for everyone, from beginners to advanced users. Learn how to organize data, create powerful formulas, generate charts, and streamline your workflow with ease.

Led by expert instructors, our interactive lessons offer hands-on practice, covering everything from basic functions to advanced Excel techniques. Whether you're looking to improve your job performance, manage data more efficiently, or learn new skills, our flexible online classes allow you to learn at your own pace, from anywhere.

Take control of your data—sign up for our online Excel classes today and become an Excel pro!

Mounir

4.88

(85)

Unlock Your Potential: Private Online Excel & Word Classes

Master Excel and Word from the comfort of your home! Our personalized one-on-one online classes are designed to help you gain confidence and proficiency. Whether you're a beginner needing basics, a student tackling projects, or a professional aiming to boost productivity, we tailor lessons to your specific goals.

Flexible Scheduling
Customized Curriculum
Experienced Instructor
Boost Your Skills, Boost Your Career!

Brent

4.88

(85)

Stuck in Excel? Want to finally understand how those formulas really work? Do you need to create a pie chart of your expense report for work or school, but feel completely lost? Don’t worry! I’m here to help... at your pace, with no jargon or complicated explanations.

Whether you:
- are starting completely from scratch,
- already have some basic knowledge,
- or want to solve a specific problem,
we’ll tailor the session to your needs. No one-size-fits-all course, just practical help that actually works for you.

👨‍🏫 About me
I’ve been using Excel since I was a teenager — for personal use (like budgeting tools or calorie trackers) and professionally as part of my work and studies in data analysis. Thanks to my experience and structured approach, I explain Excel in a clear and understandable way. I know how frustrating it can be when something technical doesn’t work... and how satisfying it feels when it finally clicks.

🎯 Topics we can cover
- Smart formulas (IF, VLOOKUP, INDEX, MATCH, etc.)
- Creating charts, pivot tables, and dashboards
- Using Excel for budgeting, planning, or managing projects
- Data analysis and basic programming in Excel
- Preparing for Excel tests or improving job-related Excel skills

💻 Practical info
- Having your own laptop/PC is helpful, but not required
- Online or in-person sessions possible
- Have specific questions or files you’d like to work on? Let me know! I also have my own practice materials.

Feel free to send me a message with your question or goal. I’ll gladly look at how I can help you out!

Yassine

4.88

(85)

Unlock your full potential with personalized online private classes in Microsoft Excel, Word, and PowerPoint! Whether you are a beginner eager to learn the basics or an advanced user aiming to enhance your skills, these one-on-one sessions are tailored just for you.

Learn to create professional documents in Word, analyze data and automate tasks in Excel, and design stunning presentations in PowerPoint—all from the comfort of your home. Our expert instructors provide live demonstrations, hands-on practice, and real-world projects to ensure you gain practical knowledge quickly.

Flexible scheduling, customized lessons, and continuous teacher support make mastering Microsoft Office easy and convenient. Perfect for students, professionals, and anyone looking to boost productivity and confidence with essential office tools.

Book your private class today and start your journey to Microsoft Office mastery!

Asmer

4.88

(85)

Online Private Classes in Microsoft Word, Excel & PowerPoint – Master the Essentials from Home!

Unlock your full productivity potential with personalized, one-on-one online training in Microsoft Office Suite! Whether you're a student, professional, or looking to boost your digital skills, our tailored private classes in Microsoft Word, Excel, and PowerPoint are designed to meet your specific needs and learning pace.

🎯 What You’ll Learn:

📘 Microsoft Word:

Create professional documents, resumes, and reports
Format text, paragraphs, and styles efficiently
Use headers, footers, tables, and templates
Master mail merge, track changes, and collaboration tools
📊 Microsoft Excel:

Build and manage spreadsheets with confidence
Perform calculations using formulas and functions (SUM, AVERAGE, VLOOKUP, IF, etc.)
Create charts, pivot tables, and data analysis tools
Learn data sorting, filtering, and conditional formatting
📽️ Microsoft PowerPoint:

Design engaging, visually appealing presentations
Use animations, transitions, and multimedia elements
Apply themes, layouts, and master slides
Deliver impactful business or academic presentations
✅ Why Choose Our Online Private Classes?

100% customized to your skill level (beginner to advanced)
Flexible scheduling – learn at your convenience

Amin

4.88

(85)

Data skills can change your career, and you don't need to be a "math person" or have a technical background to learn them. If you can use a computer and you're curious, you can do this. In just 10 hours of one-to-one lessons, you'll go from "I don't know where to start" to analyzing real data on your own.

Maybe you're a student who needs to analyze data for a course or a thesis. Maybe you're looking for your first job in data, finance or business and want a skill that employers ask for. Maybe you already use Excel every day, but your reports take hours and you suspect there's a faster way. Or maybe you've never written a line of code and the idea feels intimidating. This class is built for all of you, and every lesson starts from where you are today.

I'm an engineer, and I work with data, statistics and programming (SQL, Python, R, Excel) every day. I don't teach theory for its own sake. I teach the way I use these tools in real work: you get a real question, a real dataset, and a clear method for turning one into the other.

In 10 hours, you will be able to:

Write SQL queries on your own. Select, filter, sort and group data, combine several tables with JOINs, and answer real questions such as "which product sold the most each month?"
Clean and analyze data in Excel. Use lookup formulas, conditional calculations and PivotTables, and build clear charts, instead of spending hours on manual work.
Build your first Power BI dashboard. Import data, clean it with Power Query, create interactive visuals, and share a report that looks professional.
Explain your results. Turn a business question into a query or a dashboard, check that your results make sense, and present them to someone who doesn't know the data.
Show a finished project. Leave with a portfolio-ready analysis you can use in an interview or in your thesis.

How the 10 hours are organized (we adapt this to your level and goal)

Hours 1-2: Foundations. We define your goal, check your level, and cover your first SQL queries (SELECT, WHERE, ORDER BY).
Hours 3-4: SQL in depth. Grouping and summarizing data, JOINs across tables, and cleaning messy data.
Hours 5-6: Excel for analysis. Advanced formulas, PivotTables, and charts.
Hours 7-8: Power BI. Importing and cleaning data, building visuals, and creating an interactive dashboard.
Hours 9-10: Your project. We put everything together on a realistic dataset (sales, finance, HR or your own data), and I give you feedback and a plan for what to practice next.

If you already know some Excel or SQL, we skip what you know and spend more time on what you need. If you want to go deeper later (for example advanced DAX, Python or statistics), we can continue from the same foundation.

How the lessons work

Every lesson is one-to-one and tailored to you. You practice on your own screen with my guidance, so you learn by doing rather than by watching. Between sessions I can give you short exercises if you want extra practice, and you can send me questions anytime. If you have your own files or work data (anonymized, of course), we can use them, which makes the learning much more relevant. Otherwise I provide practice datasets.

I explain in English or French (or Arabic if that's easier for you), and I'm patient. There are no silly questions. If something doesn't click, I'll explain it another way until it does.

Who this class is for

Students in business, economics, engineering, science or social sciences
Job seekers and career changers who want a first step into data analysis
Professionals who want to automate reports and work faster
Complete beginners. No previous experience with SQL or Power BI is needed.

Laroussi

4.88

(85)

Who should attend ?
This course is specifically designed for seniors, young retirees, or anyone wishing to update their computer skills at their own pace. No prior technical knowledge is required. Patience, clarity, and a supportive approach are at the heart of this training.

Why take this course?
Information technology should no longer be a barrier, but a tool to simplify your daily life and keep you connected with loved ones. This program has two objectives: to make you completely proficient with standard software (Word, Excel) and to introduce you, in a simple and engaging way, to the new Artificial Intelligence (AI) technologies that everyone is talking about.

Educational goals :
At the end of this learning cycle, you will be able to:

Drafting and formatting administrative or personal documents.

Managing a family budget or creating simple organizational lists.

Understand what Artificial Intelligence is (like ChatGPT or Gemini) and use it as a personal assistant on a daily basis.

Detailed program (Syllabus)
The program is adaptable to your initial level. Each session includes simplified theory and plenty of practice.

Module 1: The basics of office software (Microsoft Word)

Exploring the interface: the keyboard, the mouse, and the word processing screen.

Enter, correct and format text (bold, italics, colours, alignment).

Write an official letter or a letter to loved ones.

Save, find your document on the computer, and print it.

Module 2: Daily Organization (Microsoft Excel)

Understanding the principle of tables and cells.

Create simple lists (address book, shopping list).

Create a tracking table for the monthly budget (expenses, income).

Use basic formulas (automatic sum) to have the computer calculate for you.

Module 3: The Arrival of Artificial Intelligence (Chatbots)

What is Artificial Intelligence (AI)? A simple explanation and demystification.

Discover virtual assistants (ChatGPT or Gemini): how to access them for free and securely.

The art of the "Prompt" (the query): how to ask the right questions to the machine to get the best answers.

Practical workshops with AI:

Ask him to draft a complex email.

Looking for recipe ideas using leftovers from the fridge.

Have him summarize a long newspaper article.

Organize a travel itinerary from A to Z.

Module 4: Safety and Best Practices

Recognizing reliable information in the face of AI "hallucinations" (errors).

The golden rules for protecting your personal data on the internet and in Office documents.

My Pedagogical Methodology
The approach is entirely personalized. I adapt to your learning pace. Each new concept is immediately followed by a practical, concrete exercise directly related to your everyday needs (writing to an administration, planning your vacation, etc.). Simplified course materials can be provided at the end of each session to help you review on your own.

Anwae

4.88

(85)

Master Microsoft Excel with personalized courses!

Do you want to learn Excel or improve your skills? Whether you are a beginner, student, professional or entrepreneur, I offer courses tailored to your level and objectives.

✅ Discovering the Excel interface
✅ Data entry and formatting
✅ Essential formulas and functions (SUM, IF, VLOOKUP/XLOOKUP, INDEX, etc.)
✅ Professional charts and graphs
✅ Sorting, filters, and conditional formatting
✅ Pivot tables
✅ Data management and analysis
✅ Tips to save time and improve your productivity

🎯 Why choose these courses?

100% personalized training
Simple and practical explanations
Practical exercises and projects
Flexible hours
Step-by-step guidance
Suitable for students, employees, entrepreneurs and job seekers

Develop an essential skill and improve your efficiency with Microsoft Excel. Book your first lesson today and progress quickly with professional guidance!

Dina

4.88

(85)

I can help you learn Microsoft Excel from beginner to intermediate level through clear, practical lessons. Learn basic formulas and functions, create and format tables, build PivotTables, use VLOOKUP, and design charts and graphs. Gain the confidence to organize data, analyze information, and use Excel effectively for daily work and everyday tasks.

Madeline

4.88

(85)

Learn Microsoft Excel with Friendly, Practical 1-to-1 Online Lessons!

Would you like to feel more confident using Microsoft Excel for work, studying or everyday tasks?

I offer friendly, personalised online Excel lessons designed to help beginners develop practical skills and become more confident working with spreadsheets.

I have over three years of professional experience in merchandise planning and supply chain, having worked with luxury retailers and beauty brands including Harrods and Charlotte Tilbury. Excel has been an important part of my working life, and I love helping others develop skills they can use in real-world situations.

What you can learn:

* Excel basics, navigation and spreadsheet formatting
* Creating and organising spreadsheets
* Essential formulas, including SUM, AVERAGE and IF
* Sorting, filtering and managing data
* Conditional formatting
* Creating professional charts and graphs
* Building useful trackers and reports
* Improving your Excel skills for office and administrative roles

For students looking to develop their skills further, we can also explore more advanced formulas and reporting techniques depending on their experience and learning goals.

How my lessons work:

Every lesson is tailored to your current ability and what you want to achieve. Whether you’re completely new to Excel, preparing for an office-based role or looking to feel more confident at work, we’ll focus on practical exercises you can use outside our sessions.

Lessons are relaxed, supportive and interactive, with plenty of opportunities to ask questions and practise.

All lessons take place online, so you can learn comfortably from home.

I look forward to helping you build your Excel confidence!

Boris

4.88

(85)

As an Operations Engineer, I use Excel daily for my tasks (budgeting, planning, team management, dashboards, financial tracking, inventory management, etc.). Several years of experience have enabled me to save time on a daily basis and to master the essentials.

Methodology and organization:
We will create a detailed outline of the concepts to be covered together, tailored to your professional or personal needs, with increasing levels of complexity. Each session will include a case study with a specific objective, and we will collaboratively develop the tool to achieve the desired result.

Terms:
📅 Flexible availability during the week / weekend
✏️ In-person and online courses
📍I travel to Puteaux and surrounding towns, and can also receive visitors (Rue Paul Bert in Puteaux)

Mamoud

4.88

(85)

Do you want to work faster and more professionally in Excel and PowerPoint? These two programs are among the most important skills required today in any study or job, and mastering them saves you hours of work and makes you stand out to your colleagues and employers.

I use Excel and PowerPoint daily in my work:
- Calculating costs and preparing budgets for projects
Organizing and analyzing big data
- Preparing reports and monitoring workflow
Preparing presentations for meetings and clients
In my lessons, I teach you what you really need for studying and working, with practical examples from real life, not just what is found in books.

📊 Excel
Basic level:
- Familiarizing yourself with the program interface and important tools
- Quickly enter and edit data
- Formatting cells, numbers, dates, and currencies
- Create organized and easy-to-read schedules
- Printing and page layout correctly
Equations and functions:
- Basic arithmetic operations: SUM, AVERAGE, MIN, and MAX
- Counting and conditional summation functions: COUNTIF, SUMIF, and SUMIFS
Organizing and analyzing data:
Sorting and filtering big data
Charts and graphs:
- Choosing the right graph for your data
Designing clear and professional graphs and charts
Preparing cost schedules and budgets
- Building simple reports and dashboards
Protecting and sharing files with others

🎯 PowerPoint
Design:
- Building a well-organized presentation from start to finish
- Clean and professional slide design without clutter
Choosing colors and fonts in a harmonious way
- Use templates and Slide Master to standardize the design
- Arranging and aligning the elements accurately
Content:
- Converting long texts into clear and concise bullet points
Adding images, icons, and shapes
- Use SmartArt and diagrams to explain ideas
- Add video and audio when needed
Movement and presentation:
Movements and transitions should be appropriate and not exaggerated.
- Using Speaker Notes
- Presenter View mode during presentation
Tips for confidently presenting your presentation to others
- Preparing for questions and managing time during the presentation

Who are these lessons for?
- Students who need Excel and PowerPoint for their studies and university projects
Employees who want to work faster and more professionally
Job seekers who want to strengthen their resumes
Small business owners who want to organize their accounts and data
- Anyone who starts from scratch and wants to learn step by step

You can also bring your own files for us to work on together; the best way to learn is to work on what you actually need.

In my lessons, I teach you what you really need for studying and working, with practical examples from real life.
Each lesson is tailored to your level and goals, whether you're a student, an employee, or a job seeker looking to strengthen your resume. You can also bring your own files for us to work on together.