Excel skills course

Overall objective : To provide participants with the basic skills to use Microsoft Excel effectively to organize data, perform calculations, and create simple graphs and reports.

Detailed objectives :

1. Learn the basic Excel interface and how to navigate it.
2. Entering and formatting data in Excel spreadsheets.
3. Using basic functions (SUM, AVERAGE, COUNT, MAX, MIN).
4. Create simple tables and manipulate rows and columns.
5. Apply conditional formatting and basic rules for filtering and sorting.
6. Create simple charts (bar, pie, line) to visualize data.

Target audience : Administrative staff, students, anyone who wants to learn the basics of Excel or enhance their initial skills.

Number of days and hours : 3 days, 15 hours.

Training methods : intensive hands-on workshops, step-by-step practical exercises, demonstrations of Excel features, and simple problem-solving.

Assessment methods : practical tests on Excel, applied exercises, and evaluation of trainees’ performance in solving direct problems.