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)
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
Paulina
Course - Microsoft Office Excel - poziom średnio zaawansowany
Brak prezentacji, pliki do ćwiczeń - bardzo dobrze przygotowane zadnia.
Robert Małecki - MacGregor Poland Sp. z o.o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
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.