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
“This course is a logical follow-up to the basics course. It is set up in such a way that people with somewhat less experience of Excel can also follow it well. With a bit of practice you can automate all kinds of tasks in Excel.”
“The training course was manageable within the time set. I learned what I came for.”
"Recommended, excellent course material and a good trainer."
“I found the training very clear, a patient trainer, a pleasant atmosphere and working environment.”
“Very clear explanations. Definitely recommended for anyone who works with Excel and has never started with the basics. You learn a great deal about how Excel can be applied as a program and what it can do.”
“An enjoyable, interactive course that covers both theory and practice.”
"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."
“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.”
“The course material is clear and it is pleasant to be able to work at your own pace.”
“Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”
“A very worthwhile course. And certainly well looked after at Learnit! The trainer was very knowledgeable and gave good support.”
"A good interactive course, with room to learn how to resolve situations from practice."
“The general impression of the course as a whole is good. You clearly get something out of this course and you can apply it at work straight away. The trainer has plenty of expertise and listens carefully to the participants.”
“Well organised, clear and focused. Nice to be able to work through the course material at your own pace.”
"An enthusiastic trainer who explains Excel very clearly with good examples. The assignments tie in with this very well. The Utrecht location is a pleasant place to attend the course and is easy to reach by public transport."
“I sincerely recommend it, training at a good level with very carefully prepared materials.”
“A short course in which you can clearly indicate what your points of attention are, so that these can be covered in more detail. Clear course material, and the exercises are presented simply and clearly.”
“I very much enjoyed taking the Excel 2010 course and received a good reference work, so that I can practise some topics again at home.”
“A plus point is that the teaching is not classroom-based, so you can work at your own pace. Two days is exactly enough.”
“Even if you only have basic knowledge and experience, you can learn a great deal from this course. Learning tricks that can make your work easier and give you a better overview.”
"Excellent trainer, very patient and willing to help. You can also bring your own practical examples to the lesson, to look at them together with the trainer and practise how to apply them. He is even willing to answer your questions by email after the course. Great service!"
“I loved to see the possibilities what you can do with excel. Hope to be able to use everything we have learned.”
“Quality of the course materials, exercises and professionalism of the trainer: a solid pass!!”
“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.”
"Good, comprehensive course, clear materials, highly recommended!"
“Very professional, good explanations, easy to follow from your own workstation via the internet.”
“A complete course with clear exercises, given by a very experienced and pleasant trainer. Highly recommended.”
“Good course. The material ties in well with the Excel advanced course. The instruction book is clearly structured. A calm atmosphere in which working on your own is easy to do.”
“A great introduction to getting more out of yourself and Excel.”
“It was an instructive course and you could learn everything calmly at your own pace.”
"The teaching method is very pleasant. You can discuss the problems you encounter at work at length during the course and arrive at a solution together with the trainer. Learnit informed me quickly and clearly about the course. I am very satisfied. I have also recommended you to my colleagues, several of whom are going to take a course."
"Good course, in which you work independently a great deal. Good course material and a pleasant trainer, who helps immediately with questions and explains things very clearly."
“An excellent way to extend your Excel knowledge. Your learning question and your Excel problems take centre stage. If you bring your own material, you solve your own issues during the course.”
"A solid course in terms of content, delivered at a good pace, in which plenty of examples from business practice help participants make rapid progress in the world of Excel."
"'webinars are very handy for quickly picking up knowledge of specific parts within a particular program such as Excel, Crystal Reports etc etc'"
“The instruction/explanation is very clear; you can get started yourself straight away, with the convenience of support where needed.”
“Excel is a fine program, but it is even better to discover what else you can do once you have completed the course.”
“It was a very successful training course. Learned a lot in an enjoyable and entertaining way.”
"This training course is excellent for those who have a good grounding in Excel and want to improve further. The trainer was very professional and helpful. The right way to run this kind of course."
"An enthusiastic trainer who explains Excel very clearly with good examples. The assignments tie in with this very well. The Utrecht location is a pleasant place to attend the course and is easy to reach by public transport."
“The course book clearly sets out what you have to do and can do. The trainer is very willing to explain things further. There is plenty of scope to work with your own examples and files.”
“Although I consider myself a quite advanced user, the course-instructor managed to teach me some new advanced options within excel which will make my life easier in the future.”
“'Highly instructive. Directly applicable in practice. An enthusiastic trainer with clear and personal explanations.'”
“For a quick introduction to macros, this is a fine training course for learning the basics.”
“Clear and straightforward course book, the level is good, a pleasant trainer who explains things clearly and anticipates at the right moments. The pace of the lessons is good, a very professional trainer. Instructive, in other words!”
“The Excel training is excellent, with good course material. Excellent trainer, certainly enthusiastic, and it is also geared towards practice.”
“I took the Excel 2007 pivot tables course for advanced users and I thought it was a good course, with a highly capable trainer. Questions are answered well and the trainer's knowledge can only be described as very good. Highly recommended!”
"A.E. van Wezel - "A very practical course designed above all to make the most of the standard functions" - Rating: 8.6"
“Excel 2007 was a refresher course for me. Just to get to grips again with how everything works. I got a lot out of it and can now make full use of Excel in my current role again.”
“I attended the two-day Office Basics Excel 2003 course. First of all, it was very easy to reach (less than a 10-minute walk from Amsterdam Rai station). The course went well. There was a pleasant atmosphere and the trainers' explanations were excellent! What is nice is that if you have skills that are not covered in the course, you can mention this to the trainer, who will then find the assignments for you so that you can learn those as well. All in all I had an excellent experience and learned a great deal!”