Excel, Power BI et Python — Cours particuliers avec une Data Analyst certifiée Microsoft

From 41 C$ /h

Data Analyst certifiée Microsoft Power BI, avec environ 2 ans d'expérience en missions Data/BI en entreprise, je propose des cours particuliers d'Excel, Power BI et Python adaptés à votre niveau — du débutant complet à la personne souhaitant structurer des tableaux de bord ou automatiser des analyses professionnelles.

Ma méthode : chaque séance part d'un cas concret (budget, suivi commercial, reporting, automatisation d'un fichier) plutôt que d'exercices théoriques déconnectés. Vous repartez à chaque fois avec des compétences directement applicables à votre travail ou vos études.

Sur Python, j'accompagne notamment l'analyse de données (Pandas) et l'automatisation de tâches répétitives sur Excel.

Je m'adapte au rythme de chacun, avec un vrai souci de rendre les concepts techniques accessibles — sans jargon inutile.

Location

Use Ctrl + wheel to zoom!

At teacher's location :

Amicid’Art Ehtp, Casablanca, Morocco

Age

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

60 minutes

90 minutes

The class is taught in

English

Arabic

French

Skills

Microsoft excel

Python

Availability of a typical week

(GMT -04:00)

New York

At teacher's location

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Hassan

5.0

(1)

Formation's goal :

- Master and combine the most advanced features of Excel,
- Discover new tools and new very useful functions,
- Prepare, organize and control the data to facilitate analysis,
- Exploit the potential of Excel to automate and make calculations more reliable,
- Master the creation of advanced calculation formulas,
- Use data lists with management and summary tools,
- Prepare dashboards via Dynamic Cross Tables...
The training will be enhanced with examples and practical case studies...

Training content :

➢ General and Reminder on Level 1: Excel introduction,
➢ Simple functions then advanced functions,
➢ Calculation audits and advanced graphics,
➢ Excel databases and Management of large workbooks,
➢ PivotTables and PivotCharts,
➢ Hypertext Excel links,
➢ Sort / Filter and Advanced Filter options (Advanced),
➢ The validation rules and Conditional formatting,
➢ Import, export or link data...

Training program:

Reminder on Level 1: Excel introduction:
• Discover the Excel Ribbon,
• Name cells, ranges and tables,
• The options to hide, display, insert and delete,
• Concept of workbook and Excel sheet management,
• Insertion of comments.
Using time-saving tools
• Create custom formats.
• Define conditional formatting rules.
• Facilitate and control data entry with data validation.
Build simple and elaborate calculation formulas
• Master the copying of formulas: relative and absolute references,
• Make calculations more reliable: name cells or ranges of cells,
• Set up simple, complex, nested conditions: IF, OR, AND,
• Calculate statistics: NBVAL, NB, NB.IF, NB.EMPTY, ...
• Relate data with the VLOOKUP function.
• Calculate dates, times: MONTH.SHIFT, END.MONTH...
• Handle text: LEFT, RIGHT, STXT, NBCAR, ...
• Protect the sheet or filing cabinet.
Using a data list
• Put the data in tabular form.
• Apply multi-criteria and custom sorts.
• Query, extract data with automatic filters.
• Filter one or more tables with segments.
• Remove duplicates.
Illustrate your data with graphs
• Generate a graph from a data table,
• Modify the type: histogram, curve, sector,
• Add labels,
• Adjust the source data.
Lists / Sorts and filters
• Create a list,
• Use the lists with a data grid,
• Sort the data in a grid (Sort orders, sort by columns),
• Sorting and Filtering,
• Personalized sorting,
• Group the data in a list,
• Display the subtotals of a column, of several columns,
• Filter the data.
Validation rules and Conditional formatting:
• On drop-down lists
• On numbers (integer, decimal)
• On dates,
• Conditional formatting.
Set up pivot tables
• Set up pivot tables in 1, 2 or 3 dimensions.
• Group information by period, by tranche.
• Filter, sort, hide data.
• Add ratios, percentages.
• Insert a cross graph.

Zakaria

5.0

(1)

Do you want to learn the basics of computers or the use of software such as Word, Excel or Powerpoint?

I can give you the necessary skills to better understand the functionalities of these software to write, for example, a document, a request, an administrative letter, termination, etc.

I can also provide you with advice on making the best use of the internet, protecting and backing up your data, or using your computer on a daily basis.

I am a computer and office automation trainer, and I offer home lessons adapted to your situation.

Abdelaziz

5.0

(1)

LEARN TO PROGRAM WITH PYTHON:
-------------------------------------------------- ---------------
** Full Training:
>>> - CREATION OF DESKTOP SOFTWARE - <<<

-LEVEL 1:
_ [THE BASICS OF PROGRAMMING]: algorithm and logic and analytics
_ [PRINCIPLE OF NETWORKS]: know the basics of Computer Network and important tools
_ [Language Python]: the basics of Language Python

- LEVEL 2 :
___PROJECT__
start of the project: creation diagram for your 1st desktop software
Commander coded lines of code
-LEVEL 3:
__ADVANCED PROJECT__
] - DATABASE MANAGEMENT -> Learn SQL Language
] - BUG CORRECTION

END OF PROJECT: test your 1st application

Adham

5.0

(1)

I don't want to eat anywhere near the distance to all our neighbors.

I'll offer my children's memories at a distance from all around the world.

I'm sure you will receive a solution and be supported by outils of the application for more efficaces.

Pour plus information, contactez moy.

Elbachir

5.0

(1)

Python is the most widely used open source programming language for computer scientists. This language has propelled itself to the forefront of infrastructure management, data analysis and software development. Indeed, among its qualities, Python allows developers to focus on what they do rather than how they do it. It has freed developers from the constraints of form that occupied their time with older languages. Thus, developing code with Python is faster than with other languages.
I'm a software engineer who likes to share what I do. I benefit by teaching and motivating people.
I am used to working with people of different ages. I believe in segmentation, progress visualization, objective results and practice.

the training program:

Python #1: Introduction & coding first program

Python #2: Variables & Operations

Python #3: Conditions & Loops
Python #4: Functions & Modularity
Python #5: Introduction to object programming
Python #6: classes & attributes
Python #7: encapsulation & inheritance properties
Python #8: Strings & Lists & Tuples & Dictionaries
Python #9: Files

Brahim

5.0

(1)

At the end of this learning and this coaching, I will be able to master the in-depth techniques of general and analytical accounting and management control. From my long practical experience you will be impregnated with techniques and practical exercises using Microsoft Excel and Google Sheet.

Rachid

5.0

(1)

I am a Data Scientist / Statistical Engineer who specializes in machine learning and data mining services. I have a great experience in the analysis of données and the mise in place of predictive models for the enterprises at the beginning of the decisions.

He proposed designing machine learning and data mining services for companies to help on an additional level of public life. Message domains included:

Aggression styles: linéaire, logistique, multinomiale, poisson, etc.
Classification patterns: arbres de decision, forêts aléatoires, SVM, etc.
Clustering: k-means, DBSCAN, etc.
Réseaux de neurons: Réseaux de neurones artificiels, Réseaux de neurones convolutifs, Réseaux de neurones récurrents, etc.
Traitement du langage naturel: sentiment analysis, text classification, etc.
Chronology analyzes of events: ARIMA, SARIMA, etc.
I want you to help prepare your données, install models, improve performance and the developer. I use these tools to use Python, R, TensorFlow, Keras, PyTorch, scikit-learn, etc.

Don't hesitate to contact me if you have something to do for your machine learning and data extraction projects. I am available for individual descriptions, formations or major projects.

Mousab

5.0

(1)

The Word, Excel and PowerPoint office course aims to teach students the essential skills to effectively use these three popular applications in the Microsoft Office suite. This course is designed for beginners or those with basic knowledge of office software, and it provides a practical mastery of the key features offered by Word, Excel and PowerPoint. Here is a description of typical course content:

Microsoft Word:

Introduction to Microsoft Word and its user interface.
Creation, formatting and editing of text documents.
Using layout tools such as margins, alignment, tabs and bullets.
Inserting and modifying images, tables and objects in a document.
Using spelling and grammar checking features.
Creating document templates for repeated use.
Microsoft Excel:

Introduction to Microsoft Excel and its user interface.
Creation and management of spreadsheets.
Using formulas and functions to perform calculations.
Formatting data, cells and tables for professional presentation.
Creating graphs and charts to visualize data.
Using sorting, filtering, and search functions to analyze data.
Microsoft PowerPoint:

Introduction to Microsoft PowerPoint and its user interface.
Creating professional presentations with slides.
Adding text, images, graphics and media to slides.
Using transitions and animations to make presentations dynamic.
Effective oral presentation and use of notes and presenter mode.
Integration between applications:

Learn to copy and paste data between Word, Excel and PowerPoint.
Using bindings to automatically update data in different applications.
Embedding objects and graphics into documents and presentations.
The Word, Excel and PowerPoint office course is essential for anyone who wants to improve their skills in word processing, data management and creating professional presentations. By the end of the course, students should be able to use these applications independently and effectively, which will benefit them both in their professional and personal lives.

Salah

5.0

(1)

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.

Mourad

5.0

(1)

Whether you are a management controller, HR, auditor, accountant or finance professional, and you have a taste for Numbers, Statistics and Analysis.
I offer you a complete range of Excel and VBA training courses adapted to your needs.
Remote training on Skype or Zoom or Google Meet or Microsoft Teams, for greater efficiency.

NB. I could currently provide distance learning.

Regarding the working method, according to your availability we fix the sessions, then I will send you the course support / exercises. We do the sessions on Skype or Zoom or on Google Meet at your own pace, where we can share the screen.

Excel 365 Training Modules:

Module 1

- Basics
- References
- SI Logic Function
- SI Nested Logic Function
- Basic Math / Statis Functions
- Functions COUNTIF, SUMIF, COUNTIFENT, SUMIFENT, LARGEVALUE, SUMPRODUCT...
- ResearchV
- INDEX and EQUIV and EQUIVX search functions
- ResearchX
- Error Management
Study of practical professional cases

Module 2

- Validation and data protection
- INDIRECT function
- OFFSET function
- Dynamic Array (Sort, Unique, Filter. ..)
- LET Function
- LAMBDA FUNCTION
- LAMBDA Helper Functions (MAP, REDUCE, SCAN, MAKEARRAY, BYROW, BYCOL, ISOMITTED)
- New Data Types
- Matric functions
- 3D functions (Multi-Sheets)
Study of professional practical cases

Module 3

- Data table / Sort / Automatic and custom filter
- Advanced Filter / Database Functions
- Dynamic Pivot Table / Advanced Tips
- Solver / Analysis Scenarios
Study of professional practical cases

Module 4
Power Query
Language M
Data Preparation
Data Analytics
Study of professional practical cases

Module 5

- Simple Chart
- Advanced Chart
- Dashboard

Study of practical professional cases

Salah

5.0

(1)

I offer Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office sessions

Word is a word processing software developed by Microsoft. It is used to create documents, letters, reports, presentations...

Excel is a spreadsheet software from the Microsoft Office suite developed and distributed by the publisher Microsoft. It is used to create spreadsheets, tables, graphs, etc.

Powerpoint is a presentation software developed by Microsoft. It is part of the Microsoft Office suite. It is used to create presentations, slide shows...

I am waiting for your message.

Saad

5.0

(1)

- Interactive Learning: My lessons are designed to be engaging and adaptable to your skill level, whether you're a beginner or already familiar with programming.
- Comprehensive Curriculum: You’ll master key programming concepts, including writing, debugging, and testing code in Python and other popular languages.
- Real-World Projects: Each lesson includes practical tasks that relate directly to real-world scenarios, helping you apply what you learn immediately.
- Flexible Schedule: Classes are live on Zoom/Google Meet, with recordings available after each session.
GET YOUR FIRST COURSE !
Plus, enjoy CODE DEBUGGING ON CHAT anytime to help you overcome any challenges.
Bonus: Special sessions on how to leverage your programming skills for freelancing or landing a job.

Let’s start your programming journey with practical knowledge and hands-on experience!

Good-fit Instructor Guarantee

Contact Meriem