Course Outline
Excel basics
- Excel data types - How Excel treats date and time
- Searching for values in a spreadsheet - Find and mark
- Sheet protection
- Data accuracy
- Create a data series
- Autocorrect
- Instant Fill
- Go To Special
- Paste Special
- Text as columns
- Quick access bar
- Good sheet creation practices
- Keyboard shortcuts
- Cell formatting
- Conditional formatting
Creating formulas
- Inserting functions
- Editing formulas
- Logical functions
- Mathematical functions
- Search Functions
- Text functions
- Date and time functions
- Summing the contents of cells with a button AutoSum
- Adding functions using a dialog box
- Formula evaluation
- Specifying the location of values
- Naming the range
- Modify named ranges
- Use named ranges in formulas
Create a PivotTable
- Basic information about pivot tables
- Overview of pivot table report fields
Creating charts and pivot charts
- Create pivot charts
- Change 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