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 (10)
Pelatih benar-benar tahu Excel
karol - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
'Fakta menarik' - bagaimana mencapai hal yang sama sebaliknya.
Paulina - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
Pelatih berpengetahuan luas yang siap menjawab semua pertanyaan paling bodoh. Pelatihan ini dirancang dengan baik sesuai kebutuhan departemen kami dan pelatih fleksibel dalam subjek dan waktunya.
Katarzyna - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
fungsi yang berguna dan penerapannya pada tugas sehari-hari, kemungkinan meningkatkan penyajian berbagai nilai dengan menggunakan grafik tingkat lanjut
Alicja - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
Lecturer's openness
Natalia - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
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
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
The host's vast knowledge and amazing voice
Krzysztof
Course - Microsoft Office Excel - poziom średnio zaawansowany
The trainer's skills
Katarzyna Zarazka
Course - Microsoft Office Excel - poziom średnio zaawansowany
Dużo ćwiczeń, zwięzła teoria.