Advanced Excel, VBA & Power BI Training | Build Smarter Tools for Operations & Business in English

Àpd 55.67 $ /h

Tired of repetitive Excel tasks eating up your day, complex data staying messy, or manual reporting slowing you down? Want to automate workflows with VBA, create dynamic Power BI dashboards that give instant insights, or use AI to make everything easier? I'll teach you step by step: hands-on, clear, and completely tailored to your goals.

I'm Dorian, an operations leader with 8+ years in high-volume logistics and supply chain. In fast-paced warehouse environments, I automated nearly all key workflows to drive major improvements:
- Developed and deployed real-time Power BI dashboards that turned raw WMS data into the main leadership monitoring tool, slashing manual reporting time by 80% and enabling proactive decisions.
- Created multiple VBA automation tools to standardize data flows, reduce errors and eliminate bottleneck, allowing autonomous oversight and cutting incident response time by 40%.
- Overhauled production scheduling, shipment processes, and cross-functional collaboration (operations + IT teams) — resulting in 99.2% on-time delivery, 50% throughput increases, and 60% less team overtime.
These aren't just numbers — they're the result of hands-on automation that made operations smoother, faster, and more reliable. Now I share these practical skills to help beginners, professionals, and advanced users in logistics, operations, business, finance, or any field save time and work smarter.

What you'll learn with me:
Excel Beginner to Advanced: Formulas, Power Query, PivotTables, charts, data optimization
VBA Automation: Macros, scripts, error handling, custom tools to automate repetitive work
Power BI: Data modeling, DAX, interactive dashboards, real-time KPIs
AI Bonus: Prompt engineering for ChatGPT/Copilot to generate formulas, insights, or automate tasks
Extra Inspiration: Automation ideas from my Home Assistant/IoT home setup (smart daily efficiency)

Who it's for:
Operations, logistics, supply chain, or business professionals
Beginners building confidence
Intermediate/advanced users for projects, career advancement, or deeper mastery

My approach: 80% hands-on (we build your own solutions together), 20% clear explanations with real examples from warehouses and ops. Patient, structured, flexible, short focused sessions with takeaways you can use immediately.

Online (evenings/weekends flexible)

Lieu

En ligne depuis Belgique

Age

Adolescents (13-17 ans)

Adultes (18-64 ans)

Seniors (65+ ans)

Niveau du Cours

Débutant

Intermédiaire

Avancé

Durée

30 minutes

45 minutes

60 minutes

Enseigné en

anglais

Compétences

Microsoft excel

Formation à la gestion logistique

Disponibilité semaine type

(GMT -04:00)

New York

Cours par webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Anas

4.75

(12)

>>> What is Excel?
Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs.

>>> What about pedagogy?
I favor the learning by doing method

>>> Who am I?
For information, I am consultant / trainer and certified Microsoft Excel Expert.
I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private.

>>> Location of the training?
The place is to be agreed with the apprentice.
Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...)

>>> Content of the training
I can adapt to your level and your needs in terms of content.
Here is a non-exhaustive example of the subjects taught.

**** Excel Training (Beginner and Intermediate) ****

Part I: Basic Concepts
What is Excel?
Discover the Excel window.
Workbooks, spreadsheets, cells.
Use the toolbars, the menu, the help.

Part II: Working in a spreadsheet
Identify basic concepts
Manage cells: capture and copy
Set up formulas.
Master the modes of referencing cells: absolute, relative.
Insert, delete rows or columns, move fields.

Part III: Formatting a spreadsheet
Format cells: present numbers, text, titles.
Define conditional formatting.
Print the entire sheet or part.
Build the layout: titles, pagination

Part IV: Workbook Management
Save, edit a workbook.
Divide your data over several sheets.
Insert, delete, move, copy a sheet.
Edit multiple sheets simultaneously

Part V: Data Analysis Using Functions
Calculate percentages, establish ratios.
Perform statistics: AVERAGE, MAX, MIN
Apply conditions: SI.
Use functions: NOW, TODAY.
Consolidate multiple sheets of a workbook with the SUM function.

Part VI: Linking spreadsheets
Transfer data from one table to another
Copy / paste with link.
Create summary tables.

Part VII: Illustrate with graphics
Create a chart from a table
Change the type: histogram, curve, sector.
Add or delete a series.

**** Excel Training (Advanced) ****

Part I: Configure Excel Options
Set up Excel options.
Customize the interface.

Part II: Gaining time to present his paintings
Define styles, use themes.
Define conditional formats.
Insert Sparklines charts.

Part III: Creating simple and complex calculation formulas
Master the various modes of referencing: relative, absolute, mixed.
Name cells.
Set up simple and complex conditions: IF, OR, AND.
Calculate statistics: NBVAL, NB, NB.SI.
Use mathematical functions: Sum and SUM.
Retrieve data with search functions: VLOOKUP
Calculate dates, times: DATE(), DAY() and MONTH() ...
Manipulate text: CAPITAL, MINISCULE and CONCATENATE.
Protect formulas, sheets or binders.

Part IV: Consolidation of data
Link multiple cells in a workbook.
Manage connections between workbooks.
Consolidate tables in a workbook.
Consolidate data from multiple workbooks.

Part V: Exploiting Data Lists
Tris multicriteria.
Custom sorting: Numeric, Textual and Chronological.
Extract data: advanced filters.
Delete duplicates.

Part VI: Implementing Pivot Tables / Charts
Create charts / pivot tables
Group the information by period and by slice.
Filter and sort
Segment filters
Show / hide data.
Add ratios and percentages.

Matías

4.75

(12)

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.

Yanis

4.75

(12)

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!

Amin

4.75

(12)

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.

Salah

4.75

(12)

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.

Carine

4.75

(12)

Diplômée d'un Bachelor en économie, je propose mes services pour donner des cours particuliers et aider des élèves d'école secondaire, maturité et haute école de gestion à préparer leurs examens des branches économiques, de comptabilité et de mathématique. Je suis également à l'aise avec les enfants de l'école primaire pour l'aide au devoir.

N'hésitez pas à me contacter pour savoir si je peux vous aider.

Assim

4.75

(12)

- 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

Yassine

4.75

(12)

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.

Şeyma

4.75

(12)

Hi! I am an experienced English and Turkish Tutor who has been working with students from all around the world for more than 3 years. I've been arranging Business English, Academic English, IELTS / TOEFL Exam preparation lessons as well as General Turkish classes from A1 to C1 with individuals from Asia, Europe, Australia, Africa and the Americas. I am ready to welcome my new students worldwide.

I focus on sharpening students' speaking skills in my classes. My main methodology is based on helping learners express themselves confidently and clearly in the target language. In 3 years of my teaching career, not only have I developed my own methodologies but also privatized classes and materials according to each learner's demands and needs. Besides, I support learners who face difficulties in prononcation during language acquisition with effective elocution lessons in both languages. Besides, I speak French.

Please don't hesitate to contact me for any questions.

Fatima

4.75

(12)

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

Hamed

4.75

(12)

Online Private Classes: Microsoft Word, Excel & PowerPoint
Unlock your productivity potential with personalized one-on-one training!

📘 Microsoft Word: Master document formatting, reports, and professional layouts.

📊 Microsoft Excel: Learn formulas, charts, and data analysis with ease.

🎤 Microsoft PowerPoint: Create impactful presentations that impress every audience.

👩‍🏫 Private & Flexible: Classes tailored to your level, schedule, and goals. 🌍 Online Access: Learn from anywhere, at your own pace. 🎯 Practical Skills: Focus on real-world applications for work, study, or personal projects.

👉 Start today and gain the confidence to use Microsoft Office like a pro!

Ladouceur

4.75

(12)

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.

4.75

(12)

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

Frank

4.75

(12)

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.

Sarah

4.75

(12)

As a logistics specialist with a Master's and a PhD in logistics, I possess solid expertise in logistics management, business development, and strategic planning. I teach at the university level and in online training centers, sharing my knowledge through tailored teaching approaches.