Excel Pivot Tables e-learning course
In this e-learning you learn to create pivot tables and pivot charts in Excel independently. You turn data into valuable information and optionally work with Copilot in Excel.
NRTO quality mark
- Rapid insight from raw data
- At your own pace, from any device
- Working with Copilot in Excel
- Practical exercises with every component
- Developed by an experienced Excel trainer
Your trainer: Raoul 283 evaluations in total, averaging 8.3. View the trainers
With this e-learning you work at your own pace on pivot tables and pivot charts in Excel. Through videos, explanations and assignments you quickly extract the right information from your data. Optionally, you also cover Excel with Copilot.
Description
In this e-learning you work at your own pace on PivotTables and PivotCharts in Excel. Through videos, explanations and practical assignments you learn how to turn separate data into usable information, without needing to know any formulas.
You start by preparing your data and building your first pivot table. After that you go deeper into value field settings, displaying values in different ways, calculated columns and the search function in Excel. Each section comes with assignments that let you apply what you have learned straight away.
Optionally, the course also covers Excel in combination with Microsoft 365 Copilot, so that you see how to use this AI assistant when analysing data.
You follow the course from any device with an internet connection, whenever it suits you. No travelling time, and immediate results in your own work.
Topics
- Preparing data for a PivotTable
- Creating a pivot table with the wizard
- Updating and refreshing data
- Adjusting value field settings
- Showing values as a percentage, difference or total
- Adding calculated columns
- Creating PivotCharts based on your PivotTable
- Using the search function in Excel
- Optional: working with Copilot in Excel to set up pivot tables more quickly
Result
After this e-learning you can create PivotTables and PivotCharts in Excel independently. You turn raw data into clear overviews, adjust value field settings and work with calculated columns. You also know how to refresh data and use the search function. Optionally, you will have been introduced to Copilot in Excel, so that you can use AI to gain insights from your data more quickly.
Target audience
This e-learning is intended for anyone who works in Excel with large volumes of data and wants to extract a clear overview and useful information from it quickly. Think of office staff, finance professionals, analysts, managers and self-employed professionals. You need basic knowledge of Excel, such as entering data and working with cells and columns. Knowledge of formulas is not required.
Teaching method
You follow this course entirely online, at your own pace and from any device with an internet connection. The e-learning consists of short videos, clear explanations and practical assignments with which you get started in Excel straight away.
You decide when and where you learn, with no travelling time. You can repeat sections as often as you like, so the material really sticks. Optionally, you also discover how Copilot helps you work with pivot tables in Excel.
Prior knowledge
You need basic knowledge of Excel. You know how to open a workbook, enter data into cells and carry out simple operations. Experience with formulas is not required, as pivot tables work precisely without you having to know any formulas.
Comments
No specific remarks for this course. You follow the e-learning entirely at your own pace, at a time and place that suit you.
Practical information
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials
- Certificate
- At the end of the course you will receive a certificate of attendance
In-company
Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.
Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
The trainers for this course
Ratings from participants after completing their course, across all courses by this trainer.
What others say about this course
"Practical and instructive. A quick way to get a good grasp of Excel."
"Excellent course if you want to understand the working methods and logic behind VBA/macros. It ultimately means that, in addition to recording macros, you are also able to write formulas and programs yourself. Gives you plenty to go on when exploring what is possible with VBA. I already knew something about recording macros, but this gave me insight into how VBA works and what to look out for. Great!"
“Learnit has broadened my knowledge again with the Excel course. My knowledge had slipped and now it is up to date again! On top of that, everything is explained clearly and well, the materials are excellent, and the trainer takes the time for you.”
“Very clear course, taught in a pleasant atmosphere. Definitely recommended for people who have never worked with Excel, but also well worth it for less experienced users.”
“Excel is generally used for < 20% of what it is capable of, and given the cost of the package it is advisable to find out what the full 100% of possibilities are.”
“A good, instructive, interesting course. I discovered new functions in Excel that I didn't even know existed! So I definitely learned new things!”
“An independent, person-focused course. Thanks to this, Excel has prompted me to think far more creatively about the ways I can use Excel in my work.”
“Practice-oriented, ties in seamlessly with your work.”
“An enjoyable and clear course that is easy to follow for novice "Excellers".”
“A good, instructive, interesting course. I discovered new functions in Excel that I didn't even know existed! So I definitely learned new things!”
“Well-organised course with a good trainer at an excellent location and a well-prepared lunch.”
“The course material is clear and it is pleasant to be able to work at your own pace.”
“'The first time I have attended a webinar. Definitely worth repeating. Clear explanation. Clear presentation.'”
“A clear course that is very easy to follow. Recommended for anyone working in sales.”
“Very concrete course which gives a good insight into the possibilities of Excel.”
“Well worth attending.”
“A very interesting course that provides many new insights and will ultimately save me a lot of time!”
“A revelation: the structure of the learning, the guidance and, as a result, the outcome. With a well-catered lunch – an example for anyone giving courses.”
“This Excel course was very worthwhile and well structured. The trainer explained the basic principles clearly and made sure everyone understood the material properly, whatever their level. The combination of the trainer's enthusiasm and expertise made learning both effective and inspiring. The pace was good, and the practical exercises helped to apply what we had learned straight away. An excellent course for beginners as well as for those who want to extend their skills!”
"F. Van den Berg - "Good training. Good course material. Recommended!" - Rating: 8.0"
“I found it a very pleasant way of learning. At your own pace with a course book and a trainer who can answer questions.”
"Excellent course, the open learning format turns out to suit me very well"
"Self-study, but with something extra. A good teacher with a great deal of subject knowledge, who genuinely thinks along with you about applying your objectives in your own working environment."
“I have been working with Excel for quite some time. However, I had no idea of everything you can do with it. I would recommend this course to any novice like me! Do it!!”
“The assignments are very clear and easy to follow. There is also plenty of room to put forward your own input from your own work situation, so you can also address the issues you run into on a daily basis.”
“Clear course material with plenty of exercises and personal guidance from a trainer with extensive knowledge of MS Excel. Nice to be able to work with your own data if you want, and at your own pace. Highly recommended.”
“The independent way of working really appeals to me in this course concept. You can also bring along problems from your daily practice, which then get attention.”
“My impression of this course is excellent! Nothing but praise....”
“On the course I took, I could set my own pace. That also made it possible to spend more time on certain chapters than on other parts of the course material that were less relevant to me. I found this way of following a course very pleasant.”
“The course material was very clear, and it was explained step by step how to carry out a particular action. The exercises were related to everyday situations. With an open learning format you can of course set your own pace, which suits me fine.”
“This organisation helps you gain knowledge in a playful way. So no hours of theory thrown at you, but simply doing it the way you will use it in practice.”
“Instructive”
“A pleasant way of working through the material. A book with clear instructions and a trainer in the background who answers questions!”
“Efficient for people who already use databases in Excel a great deal.”
“'Expert tailored work, highly recommended!!”
“Practice-oriented course in which you work independently on theory followed by practical assignments; a good mix of theory and practice.”
“Clear and useful course with practical topics. The trainer is enthusiastic and motivating.”
“If in doubt, do get advice from Learnit. I found these 2 days interesting, all the more so because this course was taught in an expert manner.”
“Good course, you get a lot of practical information that you can really put to use.”
“It is a very pleasant course that you can follow at your own pace. If you have questions, there is a trainer who helps you on your way straight away. Really recommended.”
“Plenty of enjoyable exercises that you can join in with and apply straight away. A good, clear trainer who gives everyone attention.”
“The content of the Excel 2003 course matched my learning objectives perfectly. The individual way of teaching, namely getting to work yourself, works very well. If you have questions, you get targeted help. The aftercare is also well arranged; you can still turn to the trainer at any time.”
“I can recommend the Excel course at Learnit to anyone. Excellent guidance from the trainer, a clear textbook and a CD with all kinds of exercises that tie in perfectly with the textbook (you can take these home after the course as practice and reference material). This course made me realise that I could have been working much more efficiently for years. Thanks to Learnit.”
“A good course for laying a structured foundation for working with and programming in VBA.”
“The training is given in an enjoyable way. You get to work on things yourself, and if you have questions, time is taken for you.”
"The Excel Basics course is an excellent course for refreshing your memory and/or making working with Excel easier and faster. Partly thanks to the relaxed atmosphere created by the trainer and the opportunity to ask plenty of questions, my fellow participants and I found the course a pleasant experience."
“The course is of good quality and is well geared to practical use.”
“Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”
“Good, clear explanations. The trainer also takes the time to answer questions along the way.”
“'Taking courses with Learnit comes highly recommended!'”