Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Excel Basics
- Understanding the Excel interface
- Entering and editing data
- Basic formatting tools
Foundational Spreadsheet Skills
- Working with rows, columns, and worksheets
- Simple formulas and calculations
- Copying, filling, and auto-completing entries
Data Visualization Essentials
- Creating basic charts
- Customizing chart elements
- Selecting the right chart for your data
Intermediate Formulas and Functions
- Using logical functions
- Working with text and date functions
- Understanding absolute and relative references
Data Management and Analysis
- Sorting and filtering data
- Working with tables
- Applying conditional formatting
Advanced Excel Features
- PivotTables for data summarization
- PivotCharts for visual analysis
- Advanced lookup functions
Automation and Productivity Tools
- Creating and using macros
- Recording repetitive tasks
- Exploring basic VBA concepts
Professional Reporting Techniques
- Designing structured worksheets
- Building reusable templates
- Best practices for data presentation
Summary and Next Steps
Requirements
- An understanding of general computer use
- Experience with basic office productivity tasks
- Interest in learning spreadsheet skills
Audience
- Business professionals
- Administrative staff
- Anyone needing spreadsheet skills for daily work
10 Hours
Testimonials (5)
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
I generally enjoyed the practical examples.
Marika Agius
Course - Visual Basic for Applications (VBA) for Analysts
I was recently struggling with some pivot table issues and the course gave me the knowledge to work with pivot tables quicker, smarter and more efficiently.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
The training was really useful. I liked the most the parts related to the pivot tables, filtering, lockup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.
