Learnit Training
Excel PowerPivot Course
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

In deze traning leer je een koppeling te leggen tussen een externe database en Excel. Hierdoor kun jede informatie uit die database via Excel analyseren en presenteren in bijvoorbeeld draaitabellen.

Yes, I want to know more

"'Is a training given by an expert trainer, and you can do it at your own pace."" - Rating: 9.0

learnit Excel sequel

Excel PowerPivot Course

Want to learn to work with Excel PowerPivot? Excel PowerPivot is designed to display data from sources other than the EXCEL worksheet in pivot tables. In this one-day training you will learn how to view data from external databases through Excel in pivot tables. During the training you learn how to make the link and of course how to optimally arrange the data for a clear presentation in pivot tables.

In addition to setting up a data model and creating a PowerPivot, Data Analysis Expressions (DAX) are also addressed. These are special Excel features that enable the creation of analysis on large groups of data.

Topics

  • Importing data
  • Linking data
  • Create relationships between data
  • Add Calculated Columns
  • Create hierarchies
  • Creating Pivot Tables and graphs
  • Add Slicers
  • Make measurements, Kpis and perspectives
  • Data Analysis Expressions (DAX)
  • Overview of DAX Formulas
  • DAX and Excel formula differences
  • DAX data type
  • Formulas and the relational model
  • Calculated fields

The Trainer

You will be accompanied by a very experienced trainer in this training. The trainer discusses at the beginning of the training what your entry level is and what you want to get out of the training, so that you can focus on subjects and exercises that are important to you..

What version? 2016, 2013, 2010

During the registration you can fill in the version you are using. Our planners will ensure that you can follow the training in the correct software version with the material that is written for this version.

Practice

If you have run into problems yourself or would like to perform certain actions more efficiently, it can be enlightening to take an example from your work environment to the training. You can still get more practice-oriented.

After

At the end of the training, you will be able to link to an external source such as a database and analyze the data with the DAZ functions of Excel. You can view the data through PowerPivot in a clear pivot table.

Prior knowledge

Knowledge about creating PivotTables and charts in Excel is recommended.

Note

This course can be followed for all versions of Excel. This training can be followed in different versions. Please indicate whether you are using Excel 2007, 2010, 2013 or 2016.

Lesvorm

This training is offered on the basis of our Open learning form-teaching method. This means that under the active supervision of our trainer, you are working independently to make your own substance. You can achieve your learning goals at your own pace without being bothered by a faster or slower pace of your fellow students. The trainer will ensure that you stay on track and achieve your learning goals. This form of learning offers space for customised work. You will have the opportunity to create examples from your own practice and IT environment that will make you more specific. more...

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 1 day 2 sessions
Price per day, excl. VAT € 400,- € 315,-
Total, incl. VAT € 484,- € 381,15

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We organiseren deze training ook online. Hiervoor maken we gebruik van Webbex of Zoom. Inloggen met Skype is ook mogelijk. Op verzoek kan deze training ook met Microsoft Teams worden georganiseerd.

The training lasts 2 sessions of 3 hours, spread over 2 weeks.

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

De cursus Excel PowerPivot is beoordeeld met een gemiddelde van 8.4.

"Good training to broaden excel's knowledge and expertise, and opportunities for good reflection of applicability in the workplace." - Rating: 7.8

S. van de Ven, Royal Peijnenburg B.V. - Excel PowerPivot

"The PowerPivot training has given our group many insights. Gradually you'll pick up a lot of tips and tricks that will make your work much more efficient. For people who process or analyze a lot of data, this training is highly recommended."

- Excel PowerPivot

"If you're looking for training to increase your chances on the job market, I'll definitely recommend one of the courses, if only to refresh your knowledge!" - Assessment: 7.4

J. Blue - Excel Macros and collaborate with other applications

"I liked everything! Perfect"

- Excel Continued

"'Is a training given by an expert trainer. And you can do it at your own pace.'" - Rating: 9.0

H. Pel, Scania Production Meppel B.V. - Excel Continued

"Getting more understanding and understanding of excel at your own pace. The group is fairly small, so the disruption is minimal. The organization and the teacher are a relief, and I'm not easily satisfied." - Rating: 8.6

R.M. van Weelden, Sew Eurodrive B.V. - Excel Continued

"This training is highly recommended. Good and clear way of explaining. They will take the time for you and you will get answers to all your questions. Really a super course." - Rating: 10.0

T. Heijdra, Unipat B.V. - Excel 2003 Turning tables, formulas and functions

"Total weather with Excel thanks to Learnit traning." - Rating: 10.0

K. Ettalhaoui, FNV KIEM - Excel Basic

"Worth following." - Review: 8.9

Hans Chip, Coty Prestige B.V. - Excel 2002 Basic

"Even for participants who have little or no experience with the subject matter, it's surprising how much one can learn in two days." - Review: 7.8

B. Forest, Valspar B.V. - Excel Basic

"I experienced the training as very instructive in a quiet pleasant environment and led by an expert teacher. Thank you." - Rating: 8.0

R. Terlouw, Zegro Centre Rotterdam - Excel 2003 Continued

"Hands on training that helps you in your day-to-day work." - Assessment: 7.3

Dave van Lierop, Hamilton Bright - Excel Continued

"Interesting training, although I already have knowledge of Excel, I have learned how to work faster and more efficiently. Everyone gets the attention they need. There is a relaxed atmosphere, where you work well and learn a lot". - Assessment: 8.4

Richard Kemna, Coty Prestige - Excel 2002 Basic

"Total weather with Excel thanks to Learnit traning." - Rating: 10.0

K. Ettalhaoui, FNV KIEM - Excel Basic

"I thought it was a very nice way of learning. At your own pace with a course book with a teacher who can answer questions." - Rating: 8.9

L. van den Berg-van Heusden, Meyra Holding BV - Excel 2003 Continued

"M. Koeken, Continuous B.V. - i> Well-designed training with a competent trainer. - Rating: 8.8"

- Excel Expert

"Fine medium. No travel time. Good to follow. Good and to the point. Recommended." - Review: 7.6

P. Gret, Rotterdam University - Free webinar Turning Tables in Excel 2010 and 2013

"I thought it was a very nice way of learning. At your own pace with a course book with a teacher who can answer questions." - Rating: 8.9

L. van den Berg-van Heusden, Meyra Holding BV - Excel 2003 Continued

"Very good training! everything is perfectly arranged and it is definitely recommended to follow a course at Learnit." - Rating: 9.0

Luciano Felida, New Neopharm - Excel Basic

"At work I did a lot with Excel but never took a course for it. I found the experience of starting from the beginning with all functional meanings very instructive, I also found the learning system very pleasant". - Assessment: 9.5

J. Nieraeth, Rabobank - Excel Basic

"It's nice to take part in the course at your own pace, but with plenty of room for questions and comments! - Review: 7.9

H.G.G. Houx, Rabobank Netherlands - Excel Continued

"It's a simple way of explaining how excel works, very open to people who aren't familiar with excel." - Review: 7.8

M. van der Laan, Zwanenberg Food Group - Excel Continued

"The training has given me a good tool to do my job better and make it easier for me." - Assessment: 8.4

P. Coert, Cofely - Excel Basic

"It was an exhilarating, clear training given by a young but experienced teacher who could explain everything clearly and simply to someone starting from zero. In short, good training in a good location with a good teacher." - Assessment: 8.1

W. Prince - Excel Basic

"Excellent course by good guidance and clear assignments with which the newly acquired knowledge could be applied immediately". - Rating: 8.0

A. van der Gragt, Hamilton Bright - Excel 2013

"Good way to master the basics of Excel." - Assessment: 8.4

R. Helt, PC Hooft Group - Excel Basic

"Had two days of training in Excel Basic 2013. The fun assignments from the teaching materials have brought more than years of toiling and trying. Definitely worth it!" - Assessment: 9.2

J. Spoelder, BOAL B.V. - Excel Basic

"Top, you're gonna realize it's badly needed to take excel courses." - Rating: 7.0

Mr. R. Kunis, The Greenhouse - Excel Basic

"'Followed a webinar for the first time. Definitely worth repeating. Clear explanation. Clear presentation.'" - Rating: 9.0

C. Leenders, Academic Hospital Maastricht - Free webinar Turning Tables in Excel 2010 and 2013

"Good full course, clear material, recommended!" - Rating: 8.6

J. Mols, Meulenhoff Bookery - Excel Revolving tables, formulas and functions

"Nice training, lots of learning and everything at your own pace." - Rating: 10.0

W. Weaver, Scania Production Meppel B.V. - Excel Continued

"I have very good impression of the content of the training and specially of the trainer"

- Excel Expert

“'In het webinar draaitabellen wordt goed en duidelijk uitgelegd wat je met draaitabellen kunt doen. Als je nog nooit een draaitabel gemaakt hebt, dan heb je veel aan deze webinar. Het is ook fijn dat je rechtstreeks vragen kunt stellen, die vervolgens meteen behandeld worden.'” - Be­oor­de­ling: 9.0

N. Albers, Multisol Raambekleding - Gratis webinar Draaitabellen in Excel 2010 en 2013

“Goeie interactieve cursus, waar de ruimte is om praktijk situaties te leren oplossen.” - Be­oor­de­ling: 8.0

J. van Hal - Excel Expert

"This organization will help you gain knowledge in a playful manner. So no hours of theoretical stuff that you get around your ears, but just do how you're going to use it in practice". - Assessment: 8.1

R. M. F. van Aalten, Rabobank - Excel Basic

"Fulfilled my expectations perfectly, a world opened up for me. A very quiet teacher, who took all the time for you and explained everything clearly so that you also understand what you are doing. - Rating: 8.0

Mr. van de Greijn, Besam Nederland B.V. - Excel Basic

"What I have experienced as pleasant is that you are with several people in the same room with one instructor and yet everyone follows their own course. Why is that? - you can share information with each other; - In this time of multimedia where everyone is only busy with themselves, you get in touch with others about why they follow this course and other things. - because there is only one teacher present, the course can be offered in a financially attractive way (LEAN thought)." - Rating: 8.0

C. van der Heijden, SNL Systems B.V. - Excel Revolving tables, formulas and functions

"Good impression. Trainer expert and patient" - Rating: 8.0

Toos Wijk, Unica Installatietechniek B.V. - Excel 2010

"Excel 2010 Basic is a very good course if you don't have a lot of experience with Excel." - Rating: 8.0

Marina Dannis - Excel Basic

"Great training! At your own pace and with answers to your questions you can master the Excel training. Very enlightening. I thought I knew a lot about Excel..." - Rating: 9.0

H. Warnier, Servatius Housing & Real Estate - Excel 2003 Continued

"Learned a lot in a fine way in a short time." - Assessment: 9.4

D. Corbel, Nuon - Excel Continued

"Expert lecturer who can move quickly in practical situations." - Assessment: 8.1

I. Beuving - Excel Basic

"Good training. Lesson material fits well with Excel follow-up course. The instruction book is clear. Quiet atmosphere in which you can work well yourself". - Rating: 8.0

L. Breeder, GGD Kennemerland - Excel 2003 Continued

"Great training for people who want to achieve their own learning goals at their own pace." - Assessment: 8.4

G.E. Verweij - Excel Basic

"Professional training, given by a very knowledgeable teacher, who was very well able to pass on his knowledge in a pleasant and clear way. The content of the training was very thorough. The teaching material really started from the basics. I really enjoyed the fact that I was able to determine the pace of the lessons myself. The teaching material and the setup were professional and there was a lot of variation in the assignments/exercises". - Review: 9.9

C. Niehaus- van den IJssel - Excel Basic

"Well cared for and clearly explained!" - Assessment: 9.1

A. Mr. Prorokova, Nieuwe Borg B.V. - Excel Basic

"I think it's very nice that you can go through the classroom at your own pace." - Rating: 8.0

M. Scant, Delta schools - Excel Basic

"Used Learnit for the first time and was pleasantly surprised with the concept. Small group and a lot of individual attention. There were plenty of training methods through the extensive teaching material". - Assessment: 8.4

M. Dikken, Ministry of Defence - Excel Continued

“'In het webinar draaitabellen wordt goed en duidelijk uitgelegd wat je met draaitabellen kunt doen. Als je nog nooit een draaitabel gemaakt hebt, dan heb je veel aan deze webinar. Het is ook fijn dat je rechtstreeks vragen kunt stellen, die vervolgens meteen behandeld worden.'” - Be­oor­de­ling: 9.0

N. Albers, Multisol Raambekleding - Gratis webinar Draaitabellen in Excel 2010 en 2013

"The course is taught by a teacher with a lot of knowledge and passion for Excell, this is contagious. The Readers that are used are very clear and contain assignments that you can work with yourself. Together, the Readers of the basic and follow-up course are a clear reference work for on the work floor". - Rating: 8.6

J. Weimar, Troostwijk Waardering en Advies B.V. - Excel Continuation