Course objective: to teach users how to confidently work with Microsoft Excel — create tables, use basic formulas, work with data, and visualize information.
Format: online lessons + practical assignments
Duration: 10–12 lessons (1–1.5 hours each)
Level: beginner → confident user
Certificate: upon completion of the course
Course program
Module 1. Introduction to Excel
- Excel interface: ribbon, cells, rows, columns.
- Creating a new document and saving files.
- Entering data and basic sheet navigation.
Module 2. Basic data operations
- Entering and editing data in cells.
- Selecting, copying, pasting, deleting.
- Undo/Redo.
- AutoFill and quick editing functions.
Module 3. Table formatting
- Formatting text, numbers, dates.
- Configuring fonts, alignment, and cell borders.
- Using table styles and conditional formatting.
Module 4. Formulas and functions
- Basic arithmetic operations: +, -, *, /.
- Sum and average: SUM, AVERAGE.
- Minimum, maximum, count: MIN, MAX, COUNT.
- Working with absolute and relative references.
Module 5. Working with ranges and sheets
- Selecting, inserting, and deleting rows and columns.
- Renaming and copying sheets.
- References between sheets and workbooks.
Module 6. Data visualization
- Creating charts (bar charts, pie charts, line charts).
- Customizing charts: colors, captions, legends.
- Using conditional formatting to make data more visually appealing.
Module 7. Sorting and filters
- Sorting by alphabet and numbers.
- AutoFilters and custom filters.
- Quick data search and table navigation.
Module 8. Working with large tables
- Freezing rows and columns.
- Working with grouping and collapsing data.
- Finding and correcting errors.
Module 9. Analytics basics
- Using the IF function for logical checks.
- Introduction to the VLOOKUP/HLOOKUP functions.
- Simple pivot tables.
Module 10. Practice and final assignment
- Creating a table with data and calculations.
- Visualizing information through charts.
- Applying filters, sorting, and basic functions.
- Final test and issuance of certificates.
