Course Outline
Basic information about the program Excel
- Data Types Excela – How Excel treats date and time
- Searching for values in a spreadsheet - Find and select
- Sheet protection
- Data correctness
- Creating a data series
- Autocorrect
- Instant filling
- Go to special
- Paste specially
- Text as columns
- Quick access bar
- Good practices for creating sheets
- Keyboard shortcuts
- Format a cell
- Conditional formatting
Creating formulas
- Inserting functions
- Edit formulas
- Logical functions
- Mathematical functions
- Search Functions
- Text functions
- Date and time functions
- Sum the contents of cells using the AutoSum button
- Adding features using the dialog box
- Estimating a formula
- Determining the location of values
- Naming the scope
- Modify named ranges
- Using named ranges in formulas
Creating a pivot table
- Basic information about pivot tables
- Overview of PivotTable report fields
Creating charts and pivot charts
- Creating pivot charts
- Changing the chart type
Requirements
Knowledge of Windows and the basics of MS Excel
Testimonials (7)
Lecturer's openness
Natalia - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
Useful keyboard shortcuts, nesting of formulas, references to possible automations in VBA.
Rafał - LKQ Polska Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
The trainer is very well prepared, specific, you can see years of experience and willingness to teach others. He is able to convey knowledge and interest in the topic. Committed, fully professional, I will definitely recommend and use him again in the future. Despite the technical problems, I admire Noble's excellent way of solving the problem. Training with material that can be used in the future. The training is planned from beginning to end, breaks are appropriately adjusted.
Grażyna
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
The host's vast knowledge and amazing voice
Krzysztof
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
The trainer's skills
Katarzyna Zarazka
Course - Microsoft Office Excel - poziom średnio zaawansowany
Dużo ćwiczeń, zwięzła teoria.
Monika
Course - Microsoft Office Excel - poziom średnio zaawansowany
Spokój i tłumaczenie materiału