How do I quickly learn to work with pivot tables in Excel?

With the Excel Pivot Tables e-learning you learn to create pivot tables and pivot charts independently, at your own pace. You get videos, explanations and practical assignments on topics such as value field settings, calculated columns and refreshing data. The course can be followed online from any device with an internet connection, without travelling time and whenever it suits you.

What is the difference between a pivot table and an ordinary table in Excel?

A pivot table automatically summarises large amounts of data and groups them by category, whereas an ordinary table only shows rows and columns without any analysis. With a pivot table you drag fields into rows, columns or values and immediately see totals, averages or percentages. An ordinary table requires manual formulas for those same insights.

Do I need prior knowledge of Excel for the Pivot Tables e-learning?

You need basic knowledge of Excel to follow this e-learning. Think of entering data, working with cells and creating a simple table. Knowledge of formulas is not required, as pivot tables work without complicated calculation formulas. Can you open and edit a list of data? Then you can get started straight away.

Do you receive a certificate after the Excel Pivot Tables e-learning?

Yes, after successfully completing the Excel PivotTables e-learning you receive a certificate of participation from LearnIt. You can easily show this certificate to your employer or add it to your LinkedIn profile. You complete the course by working through all the video lessons, explanations and assignments. You work at your own pace and decide for yourself when you are finished.

How long does the Excel Pivot Tables e-learning take and when can I start?

You can start the Excel Pivot Tables e-learning immediately after registering. You follow the course entirely at your own pace, so you decide how much time you spend per session. Most participants complete the course in 3 to 5 hours, spread across several sittings. You have ample access to all the videos, explanations and exercises, so you can practise at a time that suits you.

Can you create pivot charts with the Excel Pivot Tables e-learning?

Yes, pivot charts are a standard part of this e-learning. You learn how to turn a pivot table into a visual pivot chart, so you can see trends and proportions at a glance. You also practise with calculated columns, value field settings and the search function. That way you extract exactly the right information from your data.

When do you choose an e-learning on PivotTables and when a classroom Excel course?

An e-learning course suits you well if you want to work at your own pace, independently of a fixed timetable. You can rewatch videos as often as you need and practise at times that suit you. For most people that works fine for a clearly defined subject such as pivot tables, where you mainly recognise patterns through repetition. A classroom course is a better choice if you want to ask specific questions about your own data files, or if you notice that your perseverance is lower without fixed course days. Torn between the two? The Excel Pivot Tables e-learning course was developed by trainer Roy Nieuwenhuijzen and contains videos, explanations and assignments with immediate feedback. Optionally, Excel with Microsoft 365 Copilot is also covered, so that you can combine pivot tables with AI support.

Can this e-learning also teach me how to combine pivot tables with Copilot in Excel?

Yes, the course optionally covers working with Microsoft 365 Copilot in Excel. Copilot is the AI assistant that helps within Excel to analyse data, suggest pivot tables and summarise patterns in your data. In the course you first learn to build pivot tables yourself, adjust value field settings and add calculated columns. After that, you see how Copilot can speed up this process, for example by generating a pivot table suggestion directly from a prompt. Important to know: Copilot only works if your organisation has a Microsoft 365 Copilot licence. If you do not have that licence, the rest of the e-learning remains fully usable. The Copilot sections are an addition to, not a replacement for, the basic skills.

What does this Pivot Tables e-learning course give me that I cannot get from a free YouTube tutorial?

The Excel Pivot Tables e-learning course is built up as a structured learning path with videos, written explanations and practice assignments for each subject. You work step by step through thirteen modules, from preparing data to calculated columns and the lookup function in Excel. Each piece of theory comes with an assignment and explanation, so that you apply the material straight away and receive feedback on your approach. That is the difference with individual YouTube videos: those show you a trick, but do not build a coherent skill. The course was developed by trainer Roy Nieuwenhuijzen and ties in with the practice of working with large datasets. You receive access to the course material and a certificate of participation on completion. Optionally, the use of Microsoft 365 Copilot in Excel is also covered, for those who want to combine pivot tables with AI support.

Which type of Excel user is this Pivot Tables e-learning suitable for?

This e-learning course is intended for Excel users who work with datasets on a regular basis and want to draw insights from them without building complicated formulas. Think of finance staff, business analysts, HR staff, marketers and managers who produce reports based on export files from another system. You do not need experience with functions such as VLOOKUP or IF, but a basic knowledge of Excel (entering data, sorting columns, saving a file) is assumed. Do you never work with larger lists and stick to small, manageable tables? Then a pivot table course is less useful. Do you work with hundreds or thousands of rows and want to extract totals, averages or comparisons from them quickly? Then this e-learning course fits your working situation well.

How does this Pivot Tables e-learning compare with a full Excel course for advanced users?

This e-learning focuses specifically on pivot tables and pivot charts. You learn to prepare data, build pivot tables, adjust value field settings, add calculated columns and use the search function. A broader Excel course for advanced users also covers topics such as advanced formulas (VLOOKUP, INDEX/MATCH), conditional formatting, data validation, macros and scenario analysis. Choose this e-learning if pivot tables are your main goal and you want to work at your own pace. Choose an advanced course if you want to master a broader range of analysis techniques. The two are not mutually exclusive: many participants first take the Pivot Tables e-learning and then move on to a classroom follow-up course. Excel with Microsoft 365 Copilot is also covered as an option.

How does Copilot in Excel help when working with pivot tables, and what do I learn about it in this e-learning?

Copilot is the AI assistant in Microsoft 365 that helps with analyses in Excel. You describe in plain language what you want to know ('show the turnover per region per quarter') and Copilot proposes a pivot table or summary. In this Excel Pivot Tables e-learning course we optionally pay attention to Copilot in Excel. You first learn to build pivot tables yourself, set value fields and create calculated columns. After that you see how Copilot can speed up the same actions and which prompts work well. That distinction matters: without an understanding of the pivot table structure you cannot check Copilot's output. You do need a Microsoft 365 licence with Copilot in order to practise. The basic modules work without Copilot.

Excel Pivot Tables e-learning course (1 day)

Name: Excel Pivot Tables e-learning
Price: 200.0 EUR
Availability: InStock

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.

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.

Request a quote

Education level:

This training is suitable for all levels.

Exemptions:

Exemptions do not apply to this course.

Preparation time:

No preparation time applies to this course.

Certificate:

At the end of the course, a certificate is issued as proof of participation.

The best training for you

At Learnit you will always find a course that takes you further. From (technical) IT skills to communication or personal leadership. You can also choose the training format that suits you best: a classroom course, a tailor-made course at your own office, an online course or an e-learning. We have the right course and the right format for everyone. Because learning in the way that suits you best delivers the best results.

Moving forward together

Taking a training course at Learnit means learning together. Together with your experienced trainer, together with your course group or together with your colleagues. And whether you take the training at home, at your office or at one of our training locations, we are always available to help you. To share our knowledge with you in a way that is genuinely useful to you. Getting further together through personal attention and understanding each other well; that is what we believe in.

Apply it directly in your work

Learning theory from a book that you can then hardly use in your work? Not at Learnit! Whichever training you take with us, you can put it to use at your workplace straight away. Because of the unique learning objectives you set together with the trainer at the start of the training. Because of the alternation between theory and (interactive) practical assignments. And by bringing the challenges you face in your daily work along to the training.