Course Outline
Introduction to Solving Problems in Excel
Excel Basics
Collecting, Formatting, and Parsing Data
Using Formulas and Functions
Understanding the Spreadsheet Structure
Understanding the Logical Model Flow
Creating a Logical Model Flow
Using Charts, Pivot Tables, and Reporting
Checking, Testing, and Validating
Modeling Scenario and Sensitivity Analysis
Data Visualization and Presentation
Summary and Next Steps
Requirements
- Basic understanding of Excel
Audience
- Data Analysts
Testimonials (16)
good examples with many useful tips. All condensed and presented in easy way.
Liliana - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
A lot of possibilities shown, presented in an easy way so it was possible to learn and understand the programs even without having any previous knowledge
Patrycja - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
I liked the large number of tasks and the friendly atmosphere.
Paulina - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
Machine Translated
Very good contact with participants
Michał - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
Machine Translated
perfect adaptation of materials to the group, detailed discussion of issues, very high competence, very good contact with the group, high ability to transfer knowledge,
Malgorzata - LKQ Polska Sp. z o. o.
Course - Excel Basics
Machine Translated
Communication, method of transferring knowledge, openness
Barbara - LKQ Polska Sp. z o. o.
Course - Excel Basics
Machine Translated
Showing examples, pictorial way of translating
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
The instructor's interaction with the participants, knowledge, openness to discussion and ideas.
Paweł - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
Interesting exercises
Kacper - LKQ Polska Sp. z o. o.
Course - Excel Advanced
Trainer flexibility. Comprehensive answers to every question.
Krystyna Szpala - Sogecap SA Branch in Poland
Course - Visual Basic for Applications (VBA) for Analysts
Machine Translated
Very accurate translation, paying attention to what the students are doing. A wide range of issues related to the topic. Very useful training!
Magdalena - DataConsult S.A.
Course - Microsoft Office Excel - working effectively with the spreadsheet
Machine Translated
exhaustion of topics
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
The pace of classes is perfect, not too fast, not too slow, lots of examples and exercises. Each participant could freely perform the exercises without any pressure to answer questions. Everyone could act in their own time, and in case of a failed attempt, you could catch up when the trainer showed the solution.
Anna - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
A large number of interesting examples and exercises, learning through practice, the trainer's interest in the group, great ability to transfer knowledge
Kasia - The Boston Consulting Group sp. z o.o.
Machine Translated
Creating tables and calculating their data.
Katarzyna Ciunajcis
Machine Translated
Great pace during the training. very knowledgeable and teaching style