Course Outline
Basic Information about Excel
- Data Types Excel – How Excel Handles Date and Time
- Finding and Highlighting Values in a Spreadsheet
- Protecting Worksheets
- Data Validation
- Creating Data Series
- Autocorrect
- Flash Fill
- Go To Special
- Paste Special
- Text to Columns
- Quick Access Toolbar
- Best Practices for Creating Spreadsheets
- Keyboard Shortcuts
- Cell Formatting
- Conditional Formatting
Creating Formulas
- Inserting Functions
- Editing Formulas
- Logical Functions
- Mathematical Functions
- Lookup Functions
- Text Functions
- Date and Time Functions
- Summing Cell Contents Using the Autosum Button
- Adding Functions Using a Dialog Box
- Estimating a Formula
- Determining the Location of a Value
- Naming a Range
- Modifying Named Ranges
- Using Named Ranges in Formulas
Creating a Pivot Table
- Basic Information about Pivot Tables
- Overview of Pivot Table Report Fields
Creating Charts and Pivot Charts
- Creating Pivot Charts
- Changing Chart Type
Requirements
Familiarity with the Windows system and basics of Ms Excel
Testimonials (7)
A lot of practical exercises
Olena - Alfa Laval
Course - Microsoft Office Excel - poziom średnio zaawansowany
The pace - perfect for me to learn new things
Anna - Alfa Laval
Course - Microsoft Office Excel - poziom średnio zaawansowany
good examples with many useful tips. All condensed and presented in easy way.
Liliana - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
A lot of possibilities shown, presented in an easy way so it was possible to learn and understand the programs even without having any previous knowledge
Patrycja - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
I appreciated the most the nice atmosphere, that everything was explained well. Also I really like the good training pace - perfect for me.
Dominika - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
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.