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
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £3800 online delivery, based on a group of 2 delegates, £1200 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
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.