1. Training Overview

Excel is used in almost every industry: administration, accounting, sales, human resources, project management, inventory tracking, invoicing, budgeting, and reporting.

This training takes you from basic Excel usage to professional-level proficiency. You will work on real-world documents such as monthly budgets, expense trackers, inventory sheets, sales reports, attendance registers, payroll calculations, invoices, customer databases, and dashboards.

Each session focuses on producing practical Excel files. You will learn how to organize information, avoid calculation errors, present data clearly, and simplify business monitoring.

2. Practical Information, Schedule & Fees

Duration & Organization

The training includes:

• Two weeks of practical classes covering Excel's essential features and professional workflows.
• Exercises and assignments to complete between sessions.
• Guided corrections and instructor feedback.
• A final practical project bringing together all the skills acquired into a professional Excel workbook.

Training fees

3. What You Will Learn

During the training, you will learn how to:

• Create and properly save an Excel workbook.
• Organize data into professional spreadsheets.
• Format headings, columns, rows, amounts, dates, and percentages.
• Use basic formulas including addition, subtraction, multiplication, division, and percentages.
• Use essential Excel functions such as SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, and IF.
• Create tracking spreadsheets for expenses, revenue, sales, inventory, and attendance.
• Sort, filter, and quickly search data.
• Highlight important information using conditional formatting.
• Create drop-down lists and reduce data entry errors.
• Create clear and meaningful charts.
• Build a monitoring dashboard.
• Format, print, and export professional Excel files to PDF.
• Verify calculations and protect important spreadsheet data.

4. Final Practical Project

At the end of the training, each learner creates a professional Excel workbook based on a real-world business need.

Depending on their profile or professional field, learners may create:

• A personal or business budget management spreadsheet.
• A sales and revenue tracking workbook.
• An inventory management sheet with incoming, outgoing, and alert features.
• An employee or student attendance tracker.
• A customer and payment tracking workbook.
• A project expense calculation spreadsheet.
• A simple dashboard with charts and performance indicators.

The final project is reviewed, corrected, and presented so that each learner leaves with a professional document they can actually use or include in their portfolio.

5. Registration & Contact

Join Samedi-Informatique and develop an essential skill for education, employment, administration, and entrepreneurship.