Office 365 Suite -- MS Excel, MS Outlook, and MS Access.

Àpd 276.06 CNY /h

Class Description: Introduction to Microsoft Office Applications

Course Title: Mastering Microsoft Office Suite: Excel, Outlook, and Access

Overview:
This comprehensive course is designed to equip participants with the essential skills and knowledge needed to proficiently navigate and utilize three key Microsoft Office applications: Excel, Outlook, and Access. Through a combination of hands-on exercises, practical examples, and interactive demonstrations, students will gain a solid foundation in spreadsheet management, email communication, and database manipulation.

Course Objectives:

Excel Fundamentals:
Understand the basic functionalities and user interface of Microsoft Excel.
Learn how to create, format, and manage worksheets and workbooks efficiently.
Master essential formulas and functions for data analysis, manipulation, and visualization.
Explore advanced Excel features, including pivot tables, data validation, and conditional formatting.

Outlook Essentials:
Navigate the Outlook interface and customize settings to suit personal preferences.
Manage email accounts, folders, and messages effectively.
Learn time-saving tips and tricks for organizing emails, contacts, and calendars.
Explore advanced Outlook features, such as rules, categories, and mail merge.

Access Basics:
Understand the purpose and benefits of using Microsoft Access as a relational database management system (RDBMS).
Learn how to design and create databases, tables, and relationships.
Master essential querying techniques to retrieve and analyze data efficiently.
Develop forms and reports to present and visualize database information effectively.
Course Duration:
This course is typically delivered over a duration of [insert duration], with [insert number] hours of instruction per week.

Target Audience:

Individuals new to Microsoft Office Suite or those seeking to enhance their proficiency in Excel, Outlook, and Access.
Professionals, students, and anyone who needs to efficiently manage data, communications, and information in a business or academic setting.

Prerequisites:
Basic computer literacy and familiarity with the Windows operating system.
No prior experience with Excel, Outlook, or Access is required.
Access to Microsoft Office Suite (Excel, Outlook, Access) installed on individual computers

Delivery Method:
Online Instructor-led training sessions with hands-on exercises and interactive discussions.

By the end of this course, participants will have the skills and confidence to leverage the full potential of Excel, Outlook, and Access to streamline workflows, increase productivity, and make informed decisions in their personal and professional endeavors.

Informations supplémentaires

Access to Microsoft Office Suite (Excel, Outlook, Access) installed on individual computers

Lieu

En ligne depuis Royaume-Uni

Age

Enfants (7-12 ans)

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

Compétences

Microsoft excel

Microsoft outlook

Microsoft access

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

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.

Yanis

4.88

(85)

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!

Anas

4.88

(85)

I will help you master all the features of Microsoft Access software.

objectives:
---------------
Acquire the essential bases of Microsoft Access software.
Structure a relational database.
Define queries.
Build forms and reports.
Create simple macros.
Acquire a methodology to design and manage a database.

Whatever your basic level, I will adapt to it in order to help you progress.

Program
-------------------
Module 1: Presentation of Access software

Familiarize yourself with Access
Find your way around the screen: toolbar, status bar, menus, ruler
Methodology for building a database
Creation of a database and DBMS
Importing data from Excel into Access

***

Module 2: Design and organize your database

Organize and distribute your data between different tables
Create tables, define fields
Identify the index primary key
Define relationships, ensure referential integrity
Import, export and link data.

***

Module 3: Relationships

Link tables
The different types of relationships (one to one, one to many)
Referential integrity
Join types
Create a drop-down list
Complex relational schemas: relay tables, star schemas, etc.

***

Module 4: Query your database with queries

Selection queries: choice of fields, sort order, definition of selection criteria
Extract data by setting criteria
Grouping on a field, on an expression
Multitable and cross-analysis queries
Action requests: update, add, delete, create a table.

***

Module 5: Calculated queries

Column calculations
Online calculations: formula syntax, use the expression generator
Some calculation functions: (True false, Extraction of strings, Upper case, Lower case)

***

Module 6: Creating Forms and Entering Data

Create an instant form
Create an instant table form
Manage data: add, delete, modify, search, filter records
Modify the form
Subforms: creation, integration into a form
Editable drop-down lists.

***

Module 7: Creating Reports

Create a label report
Create a report using the wizard
Change state
Creation of column or tabular reports
Sorting and grouping
Direct mail report. Printing a report.

***

Module 8: Creating Complex Forms

Hierarchical organization of forms
Create a form and a subform
Insert action buttons: search list, command buttons
Insert calculations

Amin

4.88

(85)

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.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.

Azzedine

4.88

(85)

Boost your productivity and unleash your creativity with Microsoft Office: unleash your potential at every step!

If you're looking for a solution to optimize your efficiency, boost your creativity, and increase your daily productivity, look no further than Microsoft Office.

Why choose Microsoft Office?

Express your creativity: With Word, Excel, PowerPoint, and more, you have 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 clever features.

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

Join the Microsoft Office revolution!

Don't let everyday obstacles stand in the way of 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—beginner, intermediate, or advanced.

Carine

4.88

(85)

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.88

(85)

- 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

Farass

4.88

(85)

Online Private Classes in Excel for Beginners

Master Excel from the comfort of your home with personalized, one-on-one training!

Why Choose Our Excel Classes?
✅ Tailored for Beginners – No prior experience needed!
✅ Flexible Scheduling – Learn at your own pace.
✅ Hands-On Training – Practical exercises & real-world examples.
✅ Certification – Get a completion certificate to boost your resume.

What You’ll Learn:
📊 Basic spreadsheet navigation & formatting
🔢 Essential formulas & functions (SUM, AVERAGE, IF, VLOOKUP)
📈 Creating charts & graphs
📑 Data sorting, filtering & basic analysis
💡 Time-saving tips & tricks

How It Works:
1️⃣ Book a Session – Choose a convenient time.
2️⃣ 1-on-1 Live Training – Interactive lessons via Zoom/Teams.
3️⃣ Practice & Improve – Get assignments & expert feedback.

Who Should Join?
🔹 Students 🔹 Professionals 🔹 Job Seekers 🔹 Small Business Owners

📩 Enroll Now! Limited slots available.

Fatima

4.88

(85)

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.88

(85)

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.88

(85)

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.88

(85)

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.88

(85)

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.

Laroussi

4.88

(85)

1. Microsoft Word : Le Traitement de Texte
L'objectif est d'apprendre à créer, mettre en forme et finaliser un document professionnel (lettre, rapport ou CV).

L’interface : Découverte du ruban, des onglets et de la barre d’outils.

Saisie et modification : Apprendre à taper du texte, sélectionner, copier/coller et corriger les fautes d'orthographe.

Mise en forme : Modifier la police, la taille, la couleur, et gérer l'alignement des paragraphes.

Mise en page : Régler les marges, l'orientation (portrait/paysage) et insérer des numéros de page.

Insertion : Ajouter des images, des formes simples ou des tableaux.

2. Microsoft Excel : Le Tableur
L'objectif est de comprendre la structure d'un tableau et d'automatiser des calculs simples.

Structure de base : Comprendre le concept de cellules, colonnes, lignes et feuilles de calcul.

Saisie de données : Entrer du texte, des nombres et des dates dans les cellules.

Calculs élémentaires : Utiliser les opérateurs de base (+, −, ∗, /).

Fonctions automatiques : Apprendre à utiliser la Somme automatique et la Moyenne.

Mise en forme de tableau : Créer des bordures, fusionner des cellules et trier des listes par ordre alphabétique.

Graphiques : Transformer un tableau de données en un graphique simple (courbe ou secteurs).

3. Microsoft PowerPoint : La Présentation
L'objectif est de concevoir un support visuel dynamique pour accompagner une présentation orale.

Conception de diapositives : Créer de nouvelles diapositives et choisir une disposition (titre, contenu, image).

Thèmes et Design : Appliquer une charte graphique cohérente à l'ensemble du diaporama.

Contenu visuel : Insérer des zones de texte, des icônes, des photos et des vidéos.

Animations et Transitions : Ajouter des effets de passage entre les diapositives pour rendre la présentation fluide.

Mode Diaporama : Apprendre à projeter la présentation et à utiliser les outils de navigation.

Points clés de la formation
Prérequis : Savoir utiliser un clavier et une souris.
Méthode : Alternance entre théorie et exercices pratiques.
Finalité : Autonomie sur les tâches administratives et scolaires de base.
Note importante : Une bonne initiation doit également inclure la gestion des fichiers : savoir "Enregistrer sous", organiser ses dossiers et exporter ses documents au format PDF.

Pour qui ?
Étudiants souhaitant soigner leurs dossiers et exposés.

Particuliers voulant mieux organiser leur quotidien ou leurs documents administratifs.

Toute personne préparant une insertion ou une reconversion professionnelle.

Bonus : À la fin de chaque séance, je vous fournis des fiches mémos pour retenir les raccourcis clavier essentiels et les manipulations clés.