Why take this course
You already know the basics of Excel and want to work with data more quickly and effectively? This training will help you make better use of the program’s capabilities – from formulas and filters to charts and pivot tables. Perfect for those who prepare reports or analyze data as part of their daily work.
What you’ll learn
- Efficiently process and analyze data
- Create pivot tables and present data visually
- Apply advanced filters, sorting, and conditional formatting
- Manage workbook structure and input data
- Prepare more advanced reports and summaries
Certification & Exam
Upon completing the course, you will receive a personalized certificate confirming your intermediate-level Excel skills – including creating complex formulas, filtering data, and working with tables and charts. There is no final exam – active participation in the sessions is enough.
Who is this course for
- Individuals familiar with the basics of MS Excel
- Office staff preparing reports and analyses
- Specialists analyzing data and summaries
- Project participants who need to manage information more effectively
- Anyone looking to develop practical skills in working with data
Topics covered
- Repetition of the basics of Excel
- Formula
- Conditional Formatting
- Forms
- Tracking dependencies
- Sorting data and filters
- Subtotals
- Basic data validation (selection from drop-down lists)
- Work with charts
- Printing and its options
- Management Workbooks
- Pivot Tables and Pivot Charts
- Data Management