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)
'Fun facts' - how to achieve the same the other way around.
Paulina - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
The knowlegable trainer that was ready to answer all the most stupid questions, The training was well designed to our department needs and trainer was flexible with the subjects and timings.
Katarzyna - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
useful functions and their application to daily tasks, possibility of improving the presentation of various values by using advanced graphs
Alicja - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
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