Description

Course goal: Become confident in Excel — from organizing data to creating automated reports.

Modules:

1. Basic Interface and Navigation

   • Cells, rows, columns, and sheets

   • Formatting cells and using quick styles

2. Working with Data

   • Input, edit, and organize data

   • Sorting, filters, and conditional formatting

   • Data validation (lists, restrictions)

3. Formulas and Functions

   • SUM, AVERAGE, MAX, COUNT

   • IF, VLOOKUP, CONCAT, LEN

   • Practice: business trip logs, timesheets

4. Pivot Tables and Visualization

   • Creating and adjusting pivot tables

   • Charts and graphs that explain data

   • Presenting results clearly to management

5. Automation and Security

   • Locking sheets and protecting data

   • Report templates and structure

   • Quick actions and basic macros