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.
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.
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.
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.
For teams and organisations. If your organisation is going to work with Microsoft 365 Copilot, we also run this course in-company for a team or department, so that everyone uses Copilot in Excel in the same way and learns how to check the results. In consultation with you, we use examples from your own practice.
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:
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:
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.
The course is also suitable for roles in finance, administration, purchasing, sales and HR in which you regularly produce reports or need to clean up and analyse export files from other systems.
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.
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.
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.
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.
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.
1 training day. In order of date.
No suitable start date? Send us a date request, and we'll look at the options together.
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.
“A carefully designed course in which my learning objectives received concrete attention.”
“It was a lively, clear training course given by a young but experienced teacher who could explain everything clearly and simply to someone starting from scratch. In short, a good training course at a good location with a good teacher.”
“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.”
“Well worth attending.”
“I loved to see the possibilities what you can do with excel. Hope to be able to use everything we have learned.”
“I came from the field as a (48-year-old) engineer and had already been working with Excel for a few years, but I had only picked up a few tricks from colleagues. This course has given me an enormous foundation.”
“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.”
“A useful way to spend your time; you can work at your own pace and get exercises for all the important topics.”
"The course was useful, I enjoyed it, the trainer was great and I would certainly recommend it."
“Very good that courses are offered in this way! Useful explanation of pivot tables in Excel so you can start using them yourself as quickly as possible!”
“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.”
“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 complete course with clear exercises, given by a very experienced and pleasant trainer. Highly recommended.”
“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.”
"If you want to get acquainted with the use of macros, this is an excellent starting point. You can record and program macros. This course covers recording macros only. You learn programming during the VBA course. After completing this course you have a complete picture of how recording a macro works."
“Efficient for people who already use databases in Excel a great deal.”
“Very instructive course: recommended for anyone who works with Excel occasionally or regularly!”
“Good programme that shows all facets of Excel for the more experienced user. The course material can be followed at your own pace, so you can work through parts you already know more quickly and give more attention to the rest.”
“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.”
“Well tailored to the client's requirements”
"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!"
“I can recommend this course to every Office user. The course material and the pace can be adapted to your own situation and there is every opportunity to ask questions, which are always answered well.”
"A professional course with an expert trainer"
“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.”
“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.”
“Good course, you get a lot of practical information that you can really put to use.”
“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!”
“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!”
“Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”
“Excel 2010 Basics is a very good course if you don't yet have much experience with Excel.”
“Pleasant to be able to take part in the course at my own pace while still having plenty of room for questions and comments!”
"A. Hannink, Camposol - "Good basic and follow-up courses with a professional teacher and good course materials." - Rating: 8.3"
“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.”
“In two days you learn to apply the basic skills of Excel properly”
“Especially if you work with lists, this is a very useful advanced/expert course”
“Very concrete tips on how to apply the system, so you learn how to make the system work in your favour.”
“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.”
“For people who have done little with computers, this is an excellent course.”
“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.”
“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.”
“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.”
"Good impression. You understand the structure and set-up of VBA much better. Recommended for all editors, you now understand how it really works!"
“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.”
"Good impression. You understand the structure and set-up of VBA much better. Recommended for all editors, you now understand how it really works!"
“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.”
“LearnIt is the right place to follow a course. Everything is arranged down to the last detail, all kinds of questions can be raised and there is always a suitable answer. A great experience!”
“A practical course that you can actually do something with, and a course that does not take too long.”
“A short, clear course for someone who has worked with pivot tables little or not at all but would like to learn.”
“An enjoyable experience and an instructive programme.”
“This training will save a lot of time in future because of all the tips and trix we learned.”
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Free cancellation up to four weeks before the start, so you can secure a place now.