- Automation & ICT / IT
- Microsoft Excel
- Excel Advanced / Experts
- Excel Gevorderd
Excel Gevorderd
IT Randsteden (CLP)
Features
- 1 day
- MBO
- Certificaat
€ 408,38 All-in-price
- Customers reward us with a 9,8
- Free cancellation >4 weeks before start course
- Best price guarantee
Book this course
- Customers reward us with a 9,8
- Free cancellation >4 weeks before start course
- Best price guarantee
€ 408,38 All-in-price
Book this course
€ 408,38 All-in-price
- Dit is gegarandeerd de beste prijs
About this course
The spreadsheet program Excel can work even better for you if you delve into the more advanced possibilities of, for example, calculations, formulas, tables and graphs. Pivot tables, logical functions, search functions, conditional formatting and dealing with data lists are important components in this advanced training. After our advanced training you will clearly create pivot tables in no time, analyze data, set up spreadsheets and create tables without any problems.
Prior knowledge
A recommendation is that you have knowledge of our Excel basic training. Feel free to contact us for study advice.
Target audience
This advanced Excel training is a follow-up to our basic Excel training and a “must” for anyone who works intensively with calculations, formulas, functions or pivot tables and graphs in Excel.
Results
After our training you will know more about the advanced possibilities that Excel has to offer. For example, calculations, formulas, graphs, pivot tables, logical functions and search functions such as horizontal search are important parts of our advanced training. Of course, our experienced trainers are happy to share practical tips and tricks during the training.
Program
Education level
Experienced level
Inclusive
Certificate
Course material
3 months of online reference work
Course duration
1 day
Training location
AMERSFOORT
Prior knowledge
A recommendation is that you have knowledge of our Excel basic training. Feel free to contact us for study advice.
Target audience
This advanced Excel training is a follow-up to our basic Excel training and a “must” for anyone who works intensively with calculations, formulas, functions or pivot tables and graphs in Excel.
Results
After our training you will know more about the advanced possibilities that Excel has to offer. For example, calculations, formulas, graphs, pivot tables, logical functions and search functions such as horizontal search are important parts of our advanced training. Of course, our experienced trainers are happy to share practical tips and tricks during the training.
Program
- Customize Interface: Quick Access Toolbar
- Customize Interface: The Ribbon
- Formatting – Cell Styles
- Conditional formatting
- Data Validation and Multiple Choice Lists
- Absolute and relative cell references
- Error checking options
- Some general features
- Logical functions
- The COUNTIF, SUMIF, OR, AND functions
- TO SEARCH
- Use function within another function
- Working with multiple worksheets
- Calculations across multiple worksheets
- A neat 3D formula
- Detach sheets, link files
- Editing: Using Comments
- Securing data
- Tables and data lists (working with data)
- The advanced or extended filter
- Subtotals
- Tables
- Pivot Tables
- Pivot Charts
- Advanced chart options
- Using trendline
- Sparklines
- Macros
Education level
Experienced level
Inclusive
Certificate
Course material
3 months of online reference work
Course duration
1 day
Training location
AMERSFOORT
Book this course
- Customers reward us with a 9,8
- Free cancellation >4 weeks before start course
- Best price guarantee
€ 408,38 All-in-price
About the training institute
Welcome to IT Randsteden!
We have been providing a large number of (ICT) training courses for end users and teachers for many years.
Together we ensure that employee productivity is increased.
Working more effectively, faster and smarter is the goal we want to achieve together.
Locations:
Amersfoort, Eindhoven, Rotterdam, Amsterdam, Zwolle and Online. We also provide training at your location, much is possible. Feel free to contact us to discuss the possibilities.
Teaching method:
We have an open schedule for the Office training courses where everyone can register individually for a training course.
We also offer many trainings virtually, where you receive our course material at home and have live contact with the trainer. It is not for nothing that we call this "Wherever you learn, you are in the classroom".
Each student can decide from which location he/she wants to follow the training. With our online training courses you have the same possibilities for interaction as with a training on location, for example, to raise your hand when you have a question or to share your screen. Our experienced trainers are trained in providing online training courses in which participants do not lose their attention by finding an optimal balance between duration, content and structure in advance.
At IT Randsteden it's all about you or your organization.
A single point of contact who can advise you on all our training courses and provide support for tailor-made courses.
Looking for an in-company training for your employees? Contact us for a free quote. We provide training throughout the Netherlands and can also provide a mobile classroom if desired.
We have been providing a large number of (ICT) training courses for end users and teachers for many years.
Together we ensure that employee productivity is increased.
Working more effectively, faster and smarter is the goal we want to achieve together.
Locations:
Amersfoort, Eindhoven, Rotterdam, Amsterdam, Zwolle and Online. We also provide training at your location, much is possible. Feel free to contact us to discuss the possibilities.
Teaching method:
We have an open schedule for the Office training courses where everyone can register individually for a training course.
We also offer many trainings virtually, where you receive our course material at home and have live contact with the trainer. It is not for nothing that we call this "Wherever you learn, you are in the classroom".
Each student can decide from which location he/she wants to follow the training. With our online training courses you have the same possibilities for interaction as with a training on location, for example, to raise your hand when you have a question or to share your screen. Our experienced trainers are trained in providing online training courses in which participants do not lose their attention by finding an optimal balance between duration, content and structure in advance.
At IT Randsteden it's all about you or your organization.
A single point of contact who can advise you on all our training courses and provide support for tailor-made courses.
Looking for an in-company training for your employees? Contact us for a free quote. We provide training throughout the Netherlands and can also provide a mobile classroom if desired.
Check availability
Tue. 1 December 2026
−10%
€ 408,38 All-in-price Course
| Startdate | Tue. 1 December 2026 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Netwerklaan 42 , 3821 AG Amersfoort
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 337,50 |
|---|---|
| 21% VAT | € 70,88 |
| € 408,38 (21% VAT) | |
Thu. 10 December 2026
−10%
€ 408,38 All-in-price Course
| Startdate | Thu. 10 December 2026 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Nader te bepalen 0 , 1234 AA Zwolle
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 337,50 |
|---|---|
| 21% VAT | € 70,88 |
| € 408,38 (21% VAT) | |
Mon. 14 December 2026
−10%
€ 408,38 All-in-price Course
| Startdate | Mon. 14 December 2026 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Nader te bepalen undefined , 1234 AA Eindhoven
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 337,50 |
|---|---|
| 21% VAT | € 70,88 |
| € 408,38 (21% VAT) | |
Thu. 17 December 2026
−10%
€ 408,38 All-in-price Course
| Startdate | Thu. 17 December 2026 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Netwerklaan 42 , 3821 AG Amersfoort
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 337,50 |
|---|---|
| 21% VAT | € 70,88 |
| € 408,38 (21% VAT) | |
Tue. 12 January 2027
€ 453,75 All-in-price
Course
| Startdate | Tue. 12 January 2027 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Netwerklaan 42 , 3821 AG Amersfoort
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 375,00 |
|---|---|
| 21% VAT | € 78,75 |
| € 453,75 (21% VAT) | |
Mon. 18 January 2027
€ 453,75 All-in-price
Course
| Startdate | Mon. 18 January 2027 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Nader te bepalen 0 , 1234 AA Zwolle
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 375,00 |
|---|---|
| 21% VAT | € 78,75 |
| € 453,75 (21% VAT) | |
Thu. 21 January 2027
€ 453,75 All-in-price
Course
| Startdate | Thu. 21 January 2027 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Nader te bepalen undefined , 1234 AA Eindhoven
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 375,00 |
|---|---|
| 21% VAT | € 78,75 |
| € 453,75 (21% VAT) | |
Mon. 15 February 2027
€ 453,75 All-in-price
Course
| Startdate | Mon. 15 February 2027 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Netwerklaan 42 , 3821 AG Amersfoort
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 375,00 |
|---|---|
| 21% VAT | € 78,75 |
| € 453,75 (21% VAT) | |
Mon. 22 February 2027
€ 453,75 All-in-price
Course
| Startdate | Mon. 22 February 2027 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Nader te bepalen 0 , 1234 AA Rotterdam
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 375,00 |
|---|---|
| 21% VAT | € 78,75 |
| € 453,75 (21% VAT) | |
Mon. 1 March 2027
€ 453,75 All-in-price
Course
| Startdate | Mon. 1 March 2027 | 08:30 ‐ 17:00 |
|---|
- Lead time
- 6 hours
- Location
- Nader te bepalen undefined , 1234 AA Eindhoven
Google maps
Features
- Institute
- IT Randsteden (CLP)
- Certificate This is the certificate you will receive after completing the course or exam.
- Certificaat
- Level This is solely an indication of the required knowledge level.
- MBO
- Quality mark
- NRTO
- Contact hours
- Ochtend en middag
Book now
| 1× original price | € 375,00 |
|---|---|
| 21% VAT | € 78,75 |
| € 453,75 (21% VAT) | |