MS Excel basics

Why take this course

MS Excel is one of the most widely used office tools. If you’re just starting to work with it or want to organize your knowledge – this course will help you understand the program’s basic functions and use them in your daily work quickly and efficiently.

What you’ll learn

• Navigate the Excel interface
• Enter data and perform basic cell operations
• Create simple formulas and charts
• Format data, use filters and sorting
• Apply data validation and basic error-checking functions
• Prepare spreadsheets for printing and team collaboration

Certification & Exam

Upon completion, you will receive a personalized certificate confirming your skills in basic Excel use – including data entry, working with worksheets, creating simple formulas, and building charts. There is no final exam – active participation in the sessions is sufficient.

Who is this course for

• People starting to work with MS Excel
• Office and administrative staff
• Those who want to improve their daily work with data
• Project participants who need to report and organize data
• Anyone wanting to learn practical Excel basics

Topics covered

• The interface of Excel. Entering content
• Basic operations on cells and formatting
• Working with worksheets
• Formula
• Conditional formatting (color scale)
• Naming cells and ranges
• Data sorting and filters
• Subtotals – summing up data by categories
• Basic data validation (selection from drop-down lists)
• Tracking dependencies
• Working with charts
• Printing and its options
• Managing workbooks