Excel Course Advanced - English

Logo van SignOn ICT Trainingen+
Opleiderscore: starstarstarstarstar_half 9,1 SignOn ICT Trainingen+ heeft een gemiddelde beoordeling van 9,1 (uit 753 ervaringen)
Beste opleider van Nederland

Winnaar Beste opleider van Nederland 2018: #2 in Automatisering & ICT/IT.

Winnaar Beste opleider van Nederland 2017: #1 in Automatisering & ICT/IT.

Lees meer over Beste Opleider 2019.

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

Er zijn nog geen startdata bekend voor dit product.

SignOn ICT Trainingen+ biedt haar producten standaard aan in de volgende regio's: 's-Hertogenbosch, Alkmaar, Almere / Lelystad, Alphen aan den Rijn, Amersfoort, Amsterdam, Antwerpen, Apeldoorn, Arnhem, Assen, Breda, Brugge, Brussel, Delft, Den Haag, Deventer, Dordrecht, Drachten, Ede, Eindhoven, Emmen, Enschede, Gent, Gouda, Groningen, Haarlem, Haarlemmermeer, Heerenveen, Hilversum, Leeuwarden, Leiden, Luik, Maastricht, Middelburg, Nijmegen, Roermond, Rotterdam, Terneuzen, Tilburg, Utrecht, Veenendaal, Venlo, Westland, Zaanstad, Zoetermeer, Zwolle

Beschrijving

Coronabeleid
Veiligheid en gezondheid staan voorop tijdens onze trainingen. Daarom voldoen wij meer dan 100% aan de vereisten die de overheid stelt rondom het coronavirus, volledig conform de 1,5 meter norm en protocol. Per 15 oktober 2020: mondkapjesplicht op alle cursuslocaties.

  • Uitgeroepen tot Beste ICT Opleider van Nederland
  • Hoge opleiderscore 9.3/10 gebaseerd op meer dan 785 cursisten ervaringen! 
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit in Amsterdam, Utrecht, Rotterdam, Eindhoven en Zwolle
  • Incompany maatwerk trainingen in heel Nederland
  • Online trainingen via Virtual Classroom via Microsoft Teams, Zoom of Webex
  • Unieke switchgarantie

Als u zich aanmeldt met een groep van 5 of meer personen voor een cursus op uw bedrijfslocatie (incompany), dan kunnen wij u een aantrekkelijk groepstarief aanbieden. 

Advanced Excel training - English

With Microsoft© Excel you can create useful tables, calculation models, graphs and more. In this one-day "Advanced Excel

Trainingen

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.

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). Th…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Coronabeleid
Veiligheid en gezondheid staan voorop tijdens onze trainingen. Daarom voldoen wij meer dan 100% aan de vereisten die de overheid stelt rondom het coronavirus, volledig conform de 1,5 meter norm en protocol. Per 15 oktober 2020: mondkapjesplicht op alle cursuslocaties.

  • Uitgeroepen tot Beste ICT Opleider van Nederland
  • Hoge opleiderscore 9.3/10 gebaseerd op meer dan 785 cursisten ervaringen! 
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit in Amsterdam, Utrecht, Rotterdam, Eindhoven en Zwolle
  • Incompany maatwerk trainingen in heel Nederland
  • Online trainingen via Virtual Classroom via Microsoft Teams, Zoom of Webex
  • Unieke switchgarantie

Als u zich aanmeldt met een groep van 5 of meer personen voor een cursus op uw bedrijfslocatie (incompany), dan kunnen wij u een aantrekkelijk groepstarief aanbieden. 

Advanced Excel training - English

With Microsoft© Excel you can create useful tables, calculation models, graphs and more. In this one-day "Advanced Excel

Trainingen

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.

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:

  • Power BI course (in English)

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.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Vraag nu gratis en vrijblijvend informatie aan:

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
We slaan je gegevens op, en delen ze met SignOn ICT Trainingen+, om je via e-mail en evt. telefoon verder te helpen. Meer info vind je in ons privacybeleid.