Excel Advanced - English

Type product
Tijdsduur
Logo van SignOn ICT Trainingen+
Opleiderscore: starstarstarstarstar_half 9,2 SignOn ICT Trainingen+ heeft een gemiddelde beoordeling van 9,2 (uit 822 ervaringen)
Beste opleider van Nederland

Winnaar Beste opleider van Nederland 2020: #2 in Automatisering & ICT/IT en #3 beste grote opleider.

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 van Nederland 2020.

Tip: incompany training nodig? Vraag een offerte aan bij meerdere aanbieders!

10
Gemiddeld cijfer voor Excel Advanced - English
Gebaseerd op 2 ervaringen Lees alle ervaringenchevron_right
starstarstarstarstar
Liam
10
Excel Advanced - English

"My learning goal was advance Excel skills. Well I never thought an Excel course could be fun, but Freddy made it! He was knowledgeable and made us all feel really comfortable. An excellent trainer! I recommend this training" - 12-03-2021 12:07

"My learning goal was advance Excel skills. Well I never thought an Excel course could be fun, but Freddy made it! He was knowledgeable and m… alles lezen - 12-03-2021 12:07

Beschrijving

SignOn ICT Trainingen+ verzorgt al ruim 18 jaar ICT trainingen en consultancy in heel Nederland.

  • Beste ICT Opleider van Nederland 2017, 2018 en 2020
  • Hoge opleiderscore 9.4/10
  • Microsoft Partner Silver Data Analytics
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit
  • Klassikaal op locatie | Klassikaal online | In-company / Maatwerk | Individeel | E-Learning
  • Unieke switchgarantie
  • Unieke nazorg en consultancy 

Onze cursuslocaties zijn vanaf 1 maart  2021 weer geopend voor essentiele trainingen. Neem voor meer informatie contact met ons op.

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…

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.

SignOn ICT Trainingen+ verzorgt al ruim 18 jaar ICT trainingen en consultancy in heel Nederland.

  • Beste ICT Opleider van Nederland 2017, 2018 en 2020
  • Hoge opleiderscore 9.4/10
  • Microsoft Partner Silver Data Analytics
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit
  • Klassikaal op locatie | Klassikaal online | In-company / Maatwerk | Individeel | E-Learning
  • Unieke switchgarantie
  • Unieke nazorg en consultancy 

Onze cursuslocaties zijn vanaf 1 maart  2021 weer geopend voor essentiele trainingen. Neem voor meer informatie contact met ons op.

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.

10
Gemiddeld cijfer voor Excel Advanced - English
Gebaseerd op 2 ervaringen
starstarstarstarstar
Liam
10
Excel Advanced - English

"My learning goal was advance Excel skills. Well I never thought an Excel course could be fun, but Freddy made it! He was knowledgeable and made us all feel really comfortable. An excellent trainer! I recommend this training" - 12-03-2021 12:07

"My learning goal was advance Excel skills. Well I never thought an Excel course could be fun, but Freddy made it! He was knowledgeable and m… alles lezen - 12-03-2021 12:07

starstarstarstarstar
Lara
10
Excel Advanced - English

"Our company chosed for this training. Great trainer, would have never thought that so many hours of Excel can be entertaining but Freddy made it work :-))
I recommend this training " - 12-03-2021 11:45

"Our company chosed for this training. Great trainer, would have never thought that so many hours of Excel can be entertaining but Freddy mad… alles lezen - 12-03-2021 11:45

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