Excel Mastery: From Basics to Advanced Applications

Àpd 58.09 $ /h

Excel is more than just a spreadsheet—it’s a powerful tool for data analysis, problem-solving, and automation. This course is designed to take you from foundational skills to advanced techniques, enabling you to harness Excel's full potential in real-world scenarios. Whether you're managing data, building models, or optimizing workflows, this hands-on course will equip you with the knowledge and practical expertise to excel (pun intended) in any professional environment.

Introduction & Foundations
- Overview of Excel’s interface and advanced formatting tools
- Key functions like LOOKUP for efficient data handling

Working with References & Logical Functions
- Mastering relative and absolute references, INDIRECT function
- Using ranges, lists, and logical/information functions

Formatting, Functions, & Shortcuts
- Conditional formatting for data insights
- Text functions and essential keyboard shortcuts

Data Import & Advanced Operations
- Importing data from external sources
- Working with dates, times, and matrices

Data Analysis Tools
- Creating and managing data tables
- Data validation and pivot tables for deep analysis

Advanced Functions & Formula Auditing
- Math, statistical, and financial functions
- Troubleshooting and auditing worksheets

Advanced Analysis & Automation
- Form controls, regression analysis, and scenario building
- Introduction to macros for automation

Informations supplémentaires

The student can either choose the full course, which will be composed of 10 classes, or a reduced syllabus based on selected modules, or even a single class on a specific topic among the ones presented above.

Lieu

En ligne depuis Luxembourg

Age

Adolescents (13-17 ans)

Adultes (18-64 ans)

Seniors (65+ ans)

Niveau du Cours

Débutant

Intermédiaire

Avancé

Durée

60 minutes

Enseigné en

anglais

italien

Compétences

Microsoft excel

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

Guitar Classes for Beginners in Luxembourg - Learn the Basics, Play with Confidence

50.83 $ /h

My beginner guitar classes are designed to help you build a solid foundation, whether you're picking up the guitar for the first time or want to revisit the basics.

What You’ll Learn:

- Basic chords and strumming patterns
- Simple songs to practice and enjoy
- Guitar tuning and maintenance tips
- How to read tablature and understand music basics

Why Choose My Classes?

- Patient, supportive teaching approach
- Customized lessons based on your pace and interests
- Flexible scheduling to fit your routine
- A fun and engaging learning environment

Whether you aspire to play for yourself, family, or friends, my goal is to make your learning experience enjoyable and rewarding. Let’s make music together!

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.

Loic

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!

Etudiante à la Haute Ecole de Gestion, je donne des cours d'appui d'informatique jusqu'au niveau secondaire II.
Mon but est de vous aider à mieux comprendre et maitriser la suite Microsoft Office en travaillant principalement sur Word, Excel et Powerpoint qui sont les logiciels phares de la suite.
Il est important d'être capable de les utiliser car ce sont des outils très importants et utiles dans le monde professionnel d'aujourd'hui.
Je peux aider les étudiants de l'école de commerce avec des révisions de leurs cours d'ICA. Mais également des étudiants dans d'autres domaines ainsi des personnes qui n'ont jamais eu de cours d'informatique et souhaitent une introduction.

Que vous souhaitiez découvrir ces programmes, améliorer vos connaissances ou encore vous préparer à un examen, n'hésitez pas à me contacter si vous avez des questions et si vous êtes intéressé par mes cours d'appui.
Idéalement, transmettez moi votre demande en mentionnant quel(s) thème(s) serait(ent) à voir en priorité pour me permettre de mieux préparer notre premier cours.

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)

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.

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.

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.