Excel with Copilot
A practical course in which you learn how to use Microsoft 365 Copilot in Excel for formulas, pivot tables, data analysis and cleaning up datasets.
NRTO quality mark
Free cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel with Copilot is a 1-day classroom course. It is held in Amsterdam and The Hague, in a group of no more than 8 participants. The price is EUR 675 excl. VAT per participant, including course materials, lunch on site and a certificate of attendance. We also run this course for a team or department in-company.
- Get started straight away with Copilot in your own Excel environment
- Formulas, pivot tables and visualisations in a fraction of the time
- Small groups of no more than 8 participants and personal guidance
- Workbook with exercise files and a cheat sheet of useful prompts
- You work on your own case and leave with a concrete result
Do you work in Excel every day and would you like to get results from your data faster with Microsoft 365 Copilot? In this course you learn how to use Copilot specifically for formulas, pivot tables, analyses and cleaning up datasets. You practise directly in your own Excel environment.
Description
In this course you learn how to use Microsoft 365 Copilot within Excel to do your work faster and smarter. You work in your own Excel environment and practise with realistic examples from everyday practice.
You start with the basics: what Copilot actually is, how to activate it and how to prompt effectively to get usable answers. After that you build up to more advanced applications. You have Copilot write and explain complex formulas, suggest pivot tables and charts based on your question, and clean up data by removing duplicates, normalising and filling in missing values.
You will also gain insight into what Copilot can and cannot do, which pitfalls to watch out for and how to validate the results. During the afternoon you work on a case of your own: bring a work file and apply Copilot directly to your own situation.
Afterwards you will receive a workbook with all the exercise files and a reference cheat sheet with the best Copilot prompts for Excel. The course is delivered in the classroom or online, with a maximum of 8 participants per group.
Topics
- Copilot in Excel: what it is and how it differs from macros, formulas and standalone AI tools
- Activating Copilot and preparing your data with structured tables and clean columns
- Effective prompting: from a vague question to a usable answer
- Generating summaries, adding columns and spotting trends in datasets
- Having Copilot build formulas and functions, including an explanation of why a formula works
- Having pivot tables and charts suggested automatically based on your question
- Cleaning up data with Copilot: removing duplicates, normalising and filling in missing values
- Exploring large datasets and discovering connections between columns
- Recognising the limits and pitfalls of Copilot and validating results
- Practical tips on prompts, context and common error messages
- Working with your own case and work file from practice
Result
After this course, you will use Microsoft 365 Copilot in Excel purposefully in your daily work. You will know how to activate Copilot, how to prepare your data so that Copilot can work with it properly, and how to obtain useful answers with clear prompts.
Specifically, by the end you will be able to:
- having Copilot draw up complex formulas and functions, including a clear explanation of why they work;
- have pivot tables and charts suggested automatically based on your question;
- exploring large datasets, spotting trends and discovering connections;
- cleaning up data with Copilot: removing duplicates, normalising and filling in missing values;
- critically validate Copilot's output and recognise its limits and pitfalls;
- tackling your own work files more efficiently, with a cheat sheet of useful prompts to hand.
Target audience
Do you work in Excel every day and want to achieve faster, smarter results with Microsoft 365 Copilot? Then this course is right for you.
The course is intended for:
- employees who work a lot with spreadsheets and want to save time;
- analysts and controllers who analyse data, build formulas and report;
- project leaders and managers who want to gain insight from figures quickly;
- anyone who uses Excel actively and wants to make the most of what Copilot has to offer.
You do not need any prior knowledge of AI. We do expect basic Excel skills: filtering, sorting and working with functions such as SUM, IF and VLOOKUP (or the newer XLOOKUP). Not sure about your level? Our Excel Basics course is a good preparation for this one.
For the course, you work in your own Microsoft 365 environment with a Copilot licence. Do you not have one yet? Then you can use the Learnit test environment.
Teaching method
You spend a full day working practically in your own Excel environment under the guidance of an experienced trainer. Short explanations alternate with hands-on practice: you are given a concept, apply it to realistic examples and see immediately what Copilot can and cannot do for you.
In the morning you build a solid foundation, from prompting to properly preparing your data. In the afternoon you get to work with formulas, pivot tables, visualisations and cleaning up data. You finish with your own work file, so that you apply what you have learnt directly to a question from your day-to-day practice.
The group has a maximum of 8 participants, which leaves room for personal questions and feedback. The course can be followed in the classroom or online. You receive a workbook with all the exercise files and a cheat sheet with the 50 best Copilot prompts for Excel.
Prior knowledge
You have basic Excel skills: filtering, sorting and working with functions such as SUM, IF and VLOOKUP or XLOOKUP. No prior knowledge of AI is required. During the course you work in your own Microsoft 365 environment with an active Copilot licence.
Comments
For the course you work on your own laptop with Microsoft 365 and an active Copilot licence. Feel free to bring your own work file or dataset that you want to apply Copilot to straight away.
Practical information
- Number of days
- 1 day
- Course times
- from 10 am to 5 pm
- Teaching hours
- 6 hours
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials and lunch on site
- Certificate
- At the end of the course you will receive a certificate of attendance
- Cancel
- Free up to four weeks before the start (cancellation terms)
Language
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
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.
All start dates
1 training day. In order of date.
- Wed 3 February 2027 Amsterdam · 10:00–17:00Free cancellation until 6 January Enrol
- Mon 2 August 2027 The Hague · 10:00–17:00Free cancellation until 5 July Enrol
No suitable start date? Send us a date request, and we'll look at the options together.
This course by city
- Excel in Amsterdam6 dates
- Excel in The Hague6 dates
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
What others say about this course
“An enjoyable experience and an instructive programme.”
“An enjoyable, interactive course that covers both theory and practice.”
"Useful and interesting course!"
"The PowerPivot training course gave our group a great deal of insight. Along the way you pick up plenty of tips and tricks that make your work far more efficient. For people who process or analyse a lot of data, this course is definitely recommended."
“Excellent self-study course, so you really work at it yourself....that is still the best way to learn !!”
“Good course for beginners, even if you have no affinity with computers at all. Anyone can do it!”
“I can really recommend the course. After two course days you have learnt so much that you can work well with Excel. What's more, the course material is useful as a reference work.”
“Well tailored to the client's requirements”
"I found the course very instructive, in a calm and pleasant environment and led by an expert trainer. Thank you."
“What I found pleasant is that you are in the same room with several people and one trainer, while everyone still follows their own course. Why? - you can share information with each other; - in this age of multimedia, where everyone is only concerned with themselves, you get into contact with others about, among other things, why they are taking this course; and - because there is only one trainer present, the course can be offered at an attractive price (LEAN thinking).”
"If you want to do anything with data validation, this course comes highly recommended. After this course you will have learned a great deal about validating data."
“The Excel 2007 for advanced users course that I took at Learnit was taught in a clear manner by a very knowledgeable and well-motivated trainer.”
“Professional, no-nonsense, practice-oriented course”
"A good course, a pleasant trainer, and many topics that are personally useful to me in my work."
“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.”
“It is an excellent course with clear course materials. I learned a great deal from it.”
“I am very happy I participated in this training. It was very useful and applicable to my job, I just wish I had this training years ago! I look forward to the WORD and PPoint trainings in the future.”
“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.”
“An excellent introductory course in Excel in which everything is well explained and readily applicable.”
"A good training course for broadening your knowledge and skills in Excel, with plenty of opportunity to reflect on how to apply it in the workplace."
“The course material is clear and it is pleasant to be able to work at your own pace.”
“Recommended for anyone who wants to master the basics of Excel. Excellent course material that serves well as a reference work at home and at work. Thanks to the clear and well-structured course material, this also works very well for self-study.”
“An excellent course where you can ask all your questions and get very good help.”
"A very pleasant and efficient way to master the material under expert guidance at a superb location."
“Well-organised course with a good trainer at an excellent location and a well-prepared lunch.”
"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."
“Excel is a fine program, but it is even better to discover what else you can do once you have completed the course.”
“Professional, no-nonsense, practice-oriented course”
“Learnit is a really good training organisation. What I like is that you also get the book, so you can always practise.”
"This training course comes highly recommended. Clear, well-structured explanations. They take the time for you and you get an answer to all your questions. Really a great course."
“Had two days of training in Excel Basic 2013. The enjoyable assignments in the course material achieved more than years of struggling and trying on my own. Definitely worth it!”
“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!”
“A good course that lets everyone work at their own pace and level of understanding. I took the Excel 2007 Basics and Advanced courses at Learnit and it opened up a whole new world for me. I would recommend Learnit to anyone; good course material, professional trainers and a lovely lunch. You can take the course material home with you, so you can practise with it at home as well.”
“Clear, personal training focused on your own practical situation, which makes it easy to apply in practice. The course is taught in small groups, so there is enough attention for every participant. All of this in a relaxed atmosphere – highly recommended!”
“The 'Advanced' Excel course follows on well from the basics and was still manageable for me. Now I just need to put it into practice. It was good to have a trainer there to help me with the questions I couldn't work out. You can also bring an example from your work that can be dealt with in the lesson. In the 2 courses I have now taken, several participants were helped to work through and solve a complex problem with the trainer's help and the formulas required for it.”
“I think it is a good course with plenty of practical explanation. It opens up a world of useful information for someone with limited Excel experience.”
“Very pleasant to discover that there are often alternative and easier ways to do something you were already doing.”
"I thought everything was very well organised. Good location and a good trainer. The lessons are easy to follow and if you have questions you can always turn to them. Even after the course."
“Practice-oriented, ties in seamlessly with your work.”
“If you want to take a tailor-made course where everything is well organised and well looked after, I would recommend Learnit to anyone. I have had a very good experience.”
“I certainly found the training course instructive. Getting to work yourself and going through assignments as a group is a good mix for applying the knowledge properly. The trainer is also open to you bringing in your own cases, so that you are helped directly with your work as well. Very pleasant! In short: I thought it was a successful training course in which I was able to develop myself further in an enjoyable and welcoming setting!”
“The course material is clear and it is pleasant to be able to work at your own pace.”
"I have very good impression of the content of the training and specially of the trainer"
“A very pleasant way of learning, straight from the book with support from the trainer and being able to set your own pace.”
“Even for participants with little or no experience of the subject, it is surprising how much you can learn in two days.”
“A very pleasant way of learning, straight from the book with support from the trainer and being able to set your own pace.”
“Learned a great deal in a short time, in a very clear and accessible way. A very efficient method for me!”
“The course material is clear and gives you the chance to work through the topics and practise at your own pace. There is no pressure from other participants and no one holds you up. Combined with the good instructor, this makes for an effective course.”
"A good course covering many topics in Excel. It gives you a solid introduction to using various formulas and features of Excel."
“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.”
Training formats
Classroom
1 day€ 675,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want
Frequently asked questions
Can I cancel free of charge?
Yes. Up to four weeks before the first day of the course you can cancel free of charge, without giving a reason. You then receive a credit note or, if you have already paid, a refund. If you cancel later, you pay part of the course fee: 25% between four and two weeks before the start, 75% in the two weeks before it and 100% in the final week. Moving to another start date is free of charge up to two weeks before the start, after that 50%. Sending a colleague in your place is always possible. Read the cancellation terms.
What does the Excel with Copilot course cost?
You can find the current price at the top right of this course page, along with the schedule, location and delivery format. For in-company or bespoke courses we are happy to provide a quotation on request.
What prior knowledge do you need for the Excel with Copilot course?
You need basic Excel skills: filtering, sorting and working with functions such as SUM, IF and VLOOKUP or XLOOKUP. Prior knowledge of AI or Copilot is not required. If you are unsure about your level, our Excel Basics course is a good preparation.
Who is the Excel with Copilot course intended for?
The course is intended for anyone who works in Excel on a daily basis and wants to get results with Microsoft 365 Copilot. Think of employees who work extensively with spreadsheets, analysts and controllers, and project leaders and managers who want to gain insight from figures quickly.
What will you learn during the Excel with Copilot course?
You will learn to activate Copilot, prepare your data properly and prompt effectively. You have complex formulas built for you with an explanation, generate pivot tables and charts based on your question, discover trends in datasets and clean up data by removing duplicates, normalising and filling in missing values. You will also learn to recognise the limits of Copilot and to validate the results.
Can the Excel with Copilot course also be taken online or in-company?
Yes. You can attend the course in a classroom at one of our locations or online via Microsoft Teams. For teams within an organisation we also offer in-company versions, in which we tailor the programme to your own data and working processes. Contact us to discuss the options.
Do you receive a certificate after completing the Excel with Copilot course?
Yes, after taking part you receive a certificate of attendance from Learnit. With it you can demonstrate that you have followed the course and can use Copilot in Excel purposefully in your work.
Which materials and working methods are used in the Excel with Copilot course?
You work in your own Excel environment with an active Microsoft 365 Copilot licence. Short blocks of theory alternate with hands-on exercises using realistic datasets. You receive a workbook with practice files and a cheat sheet of useful prompts, so that you can put everything to use in your daily work straight away.
Why choose this course rather than self-study through online videos?
Videos show what Copilot can do, but not how to apply it specifically to your own data and questions. In this course you practise under the guidance of an experienced trainer, receive direct feedback on your prompts and formulas and work on your own case. That way you leave with a concrete result instead of just theory.
How do you apply what you have learnt directly in your work?
In the final part of the course you work on your own file or case. This lets you bring in an issue from your day-to-day practice and apply Copilot to it directly. With the cheatsheet and practice files to hand, you can carry on building on what you have learned the next working day.
What is the difference with the Excel Advanced course or Excel for Data Analysis?
Excel Advanced and Excel for Data Analysis focus on classic Excel functionality: advanced formulas, pivot tables and analysis techniques that you build yourself. Excel with Copilot is about reaching those results faster by using Copilot in a targeted way. The courses follow on well from one another: first learn what Excel can do, then use Copilot to speed that work up.
Is the Excel with Copilot course suitable for controllers and finance staff?
Certainly. Controllers and finance staff often work with large datasets, reports and repetitive analyses. In the course you see how Copilot helps you build formulas, set up pivot tables, clean up data and spot trends. You can bring your own financial dataset to practise with straight away.
What about the reliability and privacy of Copilot in Excel?
Copilot gives quick answers, but not always the right one. In the course you learn to validate results critically and to recognise the limits of the model, so that you catch errors in formulas or interpretations. We also consider the context in which Copilot processes your company data within your Microsoft 365 environment, so that you handle sensitive information consciously.
Read our blog
Next start date: Wed 3 February 2027 in Amsterdam
Free cancellation up to four weeks before the start, so you can secure a place now.