Ik ben op zoek naar

Excel Course Advanced – English

  • trainings duur 1 day
  • trainings prijs350,- excl. VAT per participant
  • max aantal deelnemers Max 10 participants
  • Including teaching material
  • Classroom training
  • Including certificate
  • Including catering
  • Unique aftercare

Excel Course Advanced – English

Advanced Excel training – English

With Microsoft© Excel you can create useful tables, calculation models, graphs and more. In this one-day “Advanced Excel Course” we go beyond the basic functions, so that you can perform certain operations even more quickly and easily later. You learn to make calculations with the advanced formulas and functions, databases, pivot tables and more. We adapt the content of the training entirely to your wishes. This way you get a maximum return on the Excel Advanced course.

Koninklijke NBA 6 PE-uur

Royal NBA 6 PE hour

Good to know: 6 PE points. The Advanced Excel course at SignOn ICT Training + is accredited by the Royal Dutch Professional Association of Accountants (NBA). The training is good for 6 PE points / PE hours.

For whom?

This Excel Advanced training is very suitable for anyone who is already familiar with the basic possibilities of Microsoft Excel and wants to learn the extensive possibilities.

Foreknowledge

For this course, command of the basic functions of Excel is required. Do you not have any experience with Microsoft Excel? Then we recommend that you first take the Excel Basic / Beginners course. Are you in doubt between the Excel Basic and the Excel Advanced course? Then do the knowledge test here to determine your starting level. Or contact us for advice.

Language

The working language during the training is English. In-company custom training we can provide the training in Dutch or English. The software can be in Dutch or English.

Training forms

You have a choice of different training forms: individual training, in-company training and open registration.

  • Individual Excel Advanced training
    An individual 1-on-1 course offers the ultimate in flexibility. At your own workplace you will learn the intricacies of the software under the guidance of an experienced teacher. The learning objectives are set in advance. In this way you know for sure that you will achieve optimum results.
  • In-company Excel training – Advanced
    Our in-company training is specifically tailored to your company. The experienced and specialized trainer (s) only treat what is relevant to your work situation. That makes our customized training courses very effective.
  • Classroom Excel course (open registration)
    We provide courses with open enrollment on fixed dates at our course locations in Amsterdam, Utrecht, Rotterdam, Eindhoven and Zwolle. Employees from different companies are present during this classroom training. As a result, you can already participate from 1 person, and still benefit from an attractive group rate. Fully catered for, including an extensive lunch. View the Data & Locations tab for locations and current data.

Exclusive aftercare

Do you run into questions after the Advanced Excel Course, in your daily work? Then you can contact your Excel trainer via support@signon.nl. You will receive an answer almost immediately with additional explanation; by telephone or e-mail. This additional aftercare service is exclusively for participants of our training courses.

Do you want to know more?

Do you have questions or want more information? Feel free to contact us via info@signon.nl, call us on 020 – 820 83 62 or use the contact form.

Related trainings

After following the “Excel Advanced” course, we recommend that you also follow these courses:

Content

Microsoft Excel – Advanced
1 day

In this course you will learn in a fast and efficient way to calculate with Excel. You will learn to make calculations through advanced features, databases and PivotTables. In addition, it will be explained how this data can be presented in an optimal way.

Formats

  • Modify Number format
  • Create and modify Cell styles
  • Create Table styles
  • Conditional formatting
  • Copy formatting

Working with databases

  • Creating and formatting Tables
  • Sort lists (or tables)
  • Filter lists (or tables)
  • Group and outlines of data
  • Using subtotals

Calculating with advanced functions

  • Working with cell names
  • Creating calculations over more worksheets and files
  • Calculate with Date and Time functions
  • Calculate with Financial functions
  • Calculate with Statistical functions
  • Calculate with Lookup functions
  • Calculate with Logical functions
  • Calculate with Database functions

Presenting data with Charts

  • Creating a chart
  • Modify a chart
  • Formatting a chart
  • Moving a chart
  • Sparklines

Introduction to Pivot Tables

  • Creating a PivotTable
  • Creating a PivotChart

Graphical objects

  • Insert a picture
  • Creating shapes
  • Formatting graphical elements
  • Changing the following order of objects
  • Grouping objects
  • Moving, duplicating and changing the size of objects
  • Using SmartArt

Modify the Excel environment

  • Creating a new workbook using a template
  • Using themes
  • Insert, create, modify and delete Custom lists
  • Inserting, modifying en removing hyperlinks

Teaching material

SignOn always provides the most up-to-date Microsoft Excel teaching material.

Official certificate

At the end of the course you will receive the official certificate “Excel Advanced” from SignOn.

Choose a start date: Excel Course Advanced – English

Start Location
Start date: Di. 28-04-2020
in: Amsterdam
schedule
sign up
Days and times:
  • di 28 april 2020 09:00 - 16:00
Location: Aristo Amsterdam
Teleportboulevard 100
1043 EJ Amsterdam
Start date: Do. 14-05-2020
in: Utrecht
schedule
sign up
Days and times:
  • do 14 mei 2020 09:00 - 16:00
Location: Aristo Utrecht
Brennerbaan 150
3524 BN Utrecht
Start date: Di. 25-08-2020
in: Utrecht
schedule
sign up
Days and times:
  • di 25 augustus 2020 09:00 - 16:00
Location: Aristo Utrecht
Brennerbaan 150
3524 BN Utrecht
Start date: Do. 17-09-2020
in: Amsterdam
schedule
sign up
Days and times:
  • do 17 september 2020 09:00 - 16:00
Location: Aristo Amsterdam
Teleportboulevard 100
1043 EJ Amsterdam
Start date: Di. 10-11-2020
in: Amsterdam
schedule
sign up
Days and times:
  • di 10 november 2020 09:00 - 16:00
Location: Aristo Amsterdam
Teleportboulevard 100
1043 EJ Amsterdam
Start date: Do. 10-12-2020
in: Utrecht
schedule
sign up
Days and times:
  • do 10 december 2020 09:00 - 16:00
Location: Aristo Utrecht
Brennerbaan 150
3524 BN Utrecht

Cost

Costs Excel course advanced

The training costs € 350 per participant. This includes all current teaching materials, a reference work (pdf) and the official SignOn certificate. In addition, course participants who have followed a course with us can use our exclusive aftercare service. So, there are no additional costs afterwards. The price of the training does not include 21% VAT. The VAT number is stated on the invoice.

In-company group rate

If you sign up with a group of five or more people for a Power BI course at the company location (in-company), we can offer an attractive group rate. For information about our group rates you can contact us and request a quote via this link or by telephone via 020-8208362.

Good to know

Tax-deductible

The government stimulates knowledge and skills in the Netherlands. That is why SignOn’s courses are (partially) tax deductible. How much you can deduct depends on your situation. Do you want to know more? Check the website of the Tax Authorities.

Employers

As an employer you can deduct the full training costs for employees as operating costs. This applies to the training itself, but also to other costs such as books, registration fees, administration costs, the certificate or extra supervision. At SignOn all these costs are already included in the price.

Individuals

If you follow a course at your own expense, it is often deductible for income tax purposes. This way, continuing to study is affordable. The education or course must be relevant to your current or future work. If you spend more than € 250 on mandatory costs for a relevant course or course, you can deduct a maximum of € 15,000. Check the website of the Tax Authorities.

Knowing more?

Do you have questions or want more information? Feel free to contact us via info@signon.nl or call us on 020 – 820 83 62.

Incompany-training

SignOn is specialized in customized trainings. We can change the content for the training to your wishes. You"ll get an practice-oriented customized training. See this page for more information about our incompany trainings. Inform without obligation.

Request quote - Excel Course Advanced – English






At your business location throughout the Netherlands

Alkmaar, Almere, Alphen aan den Rijn, Amersfoort, Amstelveen, Amsterdam, Apeldoorn, Arnhem, Assen, Breda, Delft, Den Bosch, Den Haag, Deventer, Dordrecht, Drachten, Ede, Eindhoven, Emmen, Enschede, Gouda, Groningen, Haarlem, Haarlemmermeer, Heerenveen, Heerlen, Hilversum, Hoorn, Kerkrade, Leeuwarden, Leiden, Lelystad, Maastricht, Middelburg, Nieuwegein, Nijmegen, Roermond, Rotterdam, Terneuzen, Tilburg, Utrecht, Veenendaal, Venlo, Westland, Zaanstad, Zoetermeer, Zwolle

beste opleider van Nederland
  • SignOn check Uitgeroepen tot beste opleider
  • SignOn check De beste trainers
  • SignOn check Inclusief digitaal naslagwerk
  • SignOn check Inclusief certificaat
  • SignOn check Unieke nazorg
  • SignOn check We request your data to process your registration.
  • SignOn check Your information will not be provided to third parties.
  • Read our privacy statement for more information.
Run 4 School

When taking a training you give children in South Africa a chance to learn. For every enrollment we donate € 2,50 per participant to Run4Schools.

Read more about Run4Schools

Meer informatie nodig?

We helpen u graag verder