Excel Course Advanced – English

Average score 9.4
out 1147 reviews

1 day
Per student: € 395,00 excl. VAT
Max 10 students

Free Switch Guarantee
Microsoft Certified Trainers
Incl. certificate
Reviews: 9,4/10

Show schedule and training Locations

Brochure Request quotation

Excel Course Advanced – English

Advanced Excel training course – in 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 will learn to make calculations with the advanced formulas and functions, databases, pivot tables and more.

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 unsure whether this training suits your knowledge and skills? Then contact us for advice or call us on 020-820 83 62.

Excel training in English

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.

Excel Courseware

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

Certificate of completion

At the end of the course you will receive a certificate.

Follow-up course

Do you want to follow a follow-up course after this Excel training course? Then the Power BI Basic course (in English) course is highly recommended. We are happy to have you as a loyal student. That is why you automatically receive a 5% loyalty discount on your invoice on almost all our training courses, when you register for the next training.

Exclusive aftercare

Questions after this Excel course? Please contact your Excel trainer at [email protected]. You will receive an answer almost immediately with extra explanation; by phone or e-mail. This unique aftercare service is exclusively for participants of our training courses.

Microsoft Excel Advanced – Training programm

The following topics are covered during this 1-day training Excel Course Advanced:

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

Start dates Location

Start date: 25 Aug 2023

Show timetable

Online via Microsoft Teams / Taal: EN

Start guarantee

Days and times:

Fr 25 Aug 2023 09:00 - 16:00

Location: Via Microsoft Teams / Taal: EN
Online via Microsoft Teams / Taal: EN

Start date: 16 Nov 2023

Show timetable

Online via Microsoft Teams / Taal: EN Register

Days and times:

Th 16 Nov 2023 09:00 - 16:00

Location: Via Microsoft Teams / Taal: EN
Online via Microsoft Teams / Taal: EN

Costs Excel course advanced

Cost per participant € 395,00 excl. BTW
Max. participants: 10

The training costs € 375 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

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.

Want to know more?

Do you have questions or want more information? Feel free to contact us via [email protected] or call us on 020 – 820 83 62.

Delivery formats

Choose a delivery format that suits you best. The following delivery formats are available for this course:

Classroom live

A face-to-face training on a location in the Netherlands. Employees from different companies are present during this classroom training. Fully catered for, including an extensive lunch.
Virtual classroom

Attend a the virtual classroom course from any location (workplace or home). You learn from a live instructor and are in contact with other participants. The instructor has the possibility to look at your screen (if necessary) to answer all your questions. This training will take place via Microsoft Teams (free of use).
In-company course

Our in-company training is tailored to your company. The specialized trainer only deals with what is important for your company and work situation. That makes our tailor-made training very effective. We provide these training courses in Dutch, English and German. The choice for an in-company training provides an attractive discount. Depending on the number of participants, the discount can be as much as 50% compared to participation in an open training. More information or request a quote.

8

This course helps with a whole variety of problems/ challenges with Excel. It’s very personal and the course can be adjusted to the student’s needs, which is an extra plus! Based on feedback of a colleague, I have chosen for this course. Very nice, personal and interactive way to go through the various world of Excel.

- Tom Cramer
10

My learning objective was to learn to match the data from different sheets and to make a clear data list with functions. It is nice to have all the files/ references so that I can look up and practice myself as well. I recommend this training.

- Anonymous
10

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

- Liam
10

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

- Lara

View all reviews on springest.nl

Wij gebruiken cookies om onze website en onze service te optimaliseren.

Ik ben op zoek naar