Maîtrisez Excel/Word & Bureautique pro. de 0 à héros

Unlock essential office skills with this comprehensive 5-in-1 course! Master Excel, Word, PowerPoint, Outlook, and Publisher – the core software suite for modern workplaces. This course is designed for beginners with no prior computer experience required.

You'll gain practical, hands-on skills using versions 2016 and above (including Office 365 and 2019). While some menu layouts may vary in older versions, the fundamental concepts remain the same. Each module is thoroughly explained, and you'll be actively involved in completing exercises.

Here's a detailed overview of what you'll learn:

• Word (5+ hours):

  • Document Management: Opening, saving, and closing files.
  • Formatting: Paragraph styles, font customization, and more.
  • Headers & Footers: Creating professional headers and footers.
  • Object Insertion: Adding images, shapes, tables, and SmartArt graphics.
  • Navigation: Table of Contents, Index creation.
  • Advanced Features: Formulaires, QuickParts, Mail Merge, and PDF export.
  • Practical Exercise: Create a professional CV and cover letter.

• Excel (8+ hours):

  • Cell Formatting: Types, alignment, colors, and borders.
  • Data Management: Inserting, deleting, hiding, and resizing rows and columns.
  • Data Manipulation: Creating lists, filters, and sorting tables.
  • Absolute Referencing: Locking cells for formula accuracy.
  • Formulas: Basic (Average, Sum, Min, Count) and Advanced (VLOOKUP, SUMIF, SUMPRODUCT, COUNTIF) functions.
  • Data Visualization: Pivot Tables, Charts, and Conditional Formatting.
  • Scenario Manager: Analyzing different possibilities.
  • Workbook Management: Handling complex multi-sheet workbooks.
  • Practical Exercise: Project Management (PMO) – create a project budget and schedule, manage notes.

• PowerPoint:

  • Presentation Creation: Building complete and engaging presentations.
  • Visual Elements: Inserting images, shapes, and SmartArt graphics.
  • Design & Formatting: Object formatting, transitions, and animations.
  • Slide Management: Slide masks and layouts.
  • Charts & Graphs: Visualizing data effectively.

• Publisher:

  • Introduction to Publisher: A user-friendly overview of the software.
  • Design Projects: Creating business cards and flyers.

• Outlook:

  • Email Setup: Configuring your email account.
  • Email Management: Standard email setup and customization.
  • Signature Creation: Designing professional email signatures.

This course provides a solid foundation in essential office software, boosting your productivity and professional skills. Get started today!