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)
Form of the training - testing all the practical knowledge that is useful in everyday work with excel.
Angelika - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
It would be so much better if the training was divided into 4 days each for 4 hours. 2 days and 8 hours each isn't efficient. There is too much knowledge and it is hard to focus.
Zuzanna - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Part about pivot table and daily trick which we can use in daily tasks.
Piotr - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
The form of it and very clear form of presenting the knowledge.
Zuza - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
the trainer was very fun and knowledgeable! the course was super interesting and useful
Kaja - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
It was really good session! I have learned a lot. The lesson was provided in really good pace. I enjoyed!
Wojciech - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Trainer really knew Excel
karol - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
'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