Excel Basics + Advanced + Expert e-learning course
In this e-learning you will learn Excel from basics to expert level: formulas, pivot tables, charts, macros and advanced functions. There is optional attention for Excel with Copilot.
NRTO quality mark
- From basics to expert in a single bundle
- Complete flexibility: learn wherever and whenever you want
- Practical assignments with every instructional video
- Working with Copilot in Excel
- Nine months' access at your own pace
Your trainer: Raoul 283 evaluations in total, averaging 8.3. View the trainers
With this complete e-learning course you master Excel from basic to expert level. You work at your own pace on formulas, pivot tables, macros and advanced functions. Optionally, you also cover Excel with Copilot.
Description
In this e-learning course you work on Excel at your own pace, from the basics to expert level. You receive three modules with a total of 147 instructional videos, 147 assignments and 15 files containing additional information.
You start by entering and formatting data, simple formulas and managing workbooks. After that you move on to absolute cell references, conditional formatting, charts, filters and PivotTables. In the final module you delve into advanced functions, nested conditions, array formulas, financial functions, goal seek, scenario manager and macros.
The course optionally also covers working with Microsoft 365 Copilot in Excel, so you can see how AI can support you with analyses and formulas.
You can follow the e-learning from any location with a laptop and internet connection. After the start you have nine months' access to the platform, and you should allow around seven hours per module. You can stop along the way and continue later at any time, as your progress is saved automatically.
Topics
- Discovering Excel and working with workbooks
- Entering, selecting, copying and pasting data
- Creating formulas and first calculations
- Formatting data and page setup for printing
- Sorting tables and managing worksheets
- Absolute cell references and conditional formatting
- Creating charts and improving the appearance of tables
- Inserting drawing objects and images
- Data lists, subtotals and filters
- Creating and analysing pivot tables
- Advanced functions: text, date, array and conditions
- Nested conditions with AND, OR and NOT
- Financial functions, goal seek and scenario manager
- Importing, exporting and converting data
- Sharing, protecting and co-editing workbooks
- Discovering macros
- Optional: combining Excel with Microsoft 365 Copilot
Result
After this e-learning course you will work independently with Excel at basic, advanced and expert level. You enter data quickly, build simple to complex formulas and apply conditional formatting. You manage large tables with filters, subtotals and pivot tables, and create clear charts. Nested functions, array formulas, financial calculations, goal seek and scenarios also come easily to you. You know how to share, protect and co-edit workbooks, and you have been introduced to macros. Have you opted for the optional Copilot component? Then you will also use Microsoft 365 Copilot to analyse data and generate formulas more quickly.
Target audience
This e-learning is intended for anyone who wants to master Excel from A to Z. Whether you are just starting out or want to extend your knowledge to advanced level, you work through the basic, advanced and expert material at your own pace. Useful for professionals who work with spreadsheets every day, students who want to strengthen their digital skills and employees who want to handle data, formulas and pivot tables more efficiently.
Teaching method
You take this course entirely as e-learning. You work through interactive lesson videos at your own pace and complete assignments after each topic to check whether you have mastered the material. Only once you have sufficiently mastered a section do you move on to the next. This way you build up your knowledge step by step.
You have 9 months' access to the online platform and can start, pause and continue again at any time. Your progress is saved automatically. You can log in from anywhere with a laptop and an internet connection, because the course runs in the cloud. So there is nothing to install.
Optionally, we also give attention to working with Microsoft 365 Copilot in Excel, so that you learn how AI can help you with analyses and formulas.
Prior knowledge
You need no prior knowledge of Excel. Can you work with a computer and do you have a laptop with internet access? Then you can start right away. The course begins with the basics and builds up step by step to the more advanced functions.
Comments
You work at your own pace and have 9 months' access to the platform. Each module takes approximately 7 hours to complete. For large groups of employees a volume discount is possible; please contact us about this.
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
“A good course for laying a structured foundation for working with and programming in VBA.”
“Practical training course with good personal guidance in an excellent environment.”
“The course is very clear, you work at your own pace and get support straight away when you have questions. I think it is very accessible for everyone, including people with exam nerves, because there is no set amount of material you have to get through. Of course the idea is that you cover as much of the material as possible, but there is no pressure while you still take everything in.”
“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.”
"I thought it was a good and worthwhile course. I learned a great deal from it. The trainer gave clear explanations and has extensive knowledge of Excel."
“Clear and suitable for everyone. The book is described very clearly with plenty of examples and assignments. Nice that you receive both the book and the CD-ROM with all the exercises, so that you can keep practising after the course and maintain your knowledge.”
“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.”
“During the two-day course I learned about the many possibilities and applications, which has made working with Excel far more appealing.”
“Well organised, clear and focused. Nice to be able to work through the course material at your own pace.”
“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.”
"The course was very well organised, the materials were in good condition and the content was very good too."
“This is a very good course for the beginning Excel user. The course material is sufficient to master all the basics, explained in a straightforward way. Certainly in combination with the trainer, who is clearly enthusiastic and knowledgeable and knows how to get that across.”
"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 pivot tables webinar explains clearly and effectively what you can do with pivot tables. If you have never made a pivot table before, this webinar will be very useful. It's also good that you can ask questions directly, which are then dealt with straight away.'”
“Well-organised teamwork with a professional trainer.”
“The first impression/introduction was and is good.”
"Excellent, professional training course with plenty of 'tips & tricks' for every starting level."
“I learnt a lot from it and in an enjoyable way. Thanks Dirk.”
"Excellent course, the open learning format turns out to suit me very well"
"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."
“An enjoyable experience and an instructive programme.”
“Everything was interesting and useful.”
“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.”
“Good course, delivered by a professional organisation and highly applicable in practice.”
“An organisation that has everything well arranged, responds quickly and thinks along with you.”
“'Expert tailored work, highly recommended!!”
“Practice-oriented, ties in seamlessly with your work.”
“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!”
"I thought everything was good! Perfect"
“The trainer takes the time and explains things well.”
“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.”
“In two days you learn to apply the basic skills of Excel properly”
“An enjoyable experience and an instructive programme.”
“Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”
“Interesting course. Even though I already had some knowledge of Excel, I learned how to work faster and more efficiently. Everyone got the attention they needed. There is a relaxed atmosphere in which a lot of work is done and a lot is learned.”
“Good training, learnt a lot, very usable in practice!”
“Very good course! Everything is perfectly organised and I would certainly recommend taking a course at Learnit.”
“A very interesting course that provides many new insights and will ultimately save me a lot of time!”
“I really enjoyed the course. Working through the material at my own pace, and whenever I didn't quite understand something, a teacher who could explain it to me immediately and clearly. Every moment of the two days was put to good use. Excellent!”
“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.”
“Good impression. Knowledgeable and patient trainer”
“Excellent training, fits my role well, certainly if you have no experience with Excel. The guidance is excellent too.”
“Enjoyable course, learnt a lot and everything at my own pace.”
“Enjoyable, inspiring course, I learnt things and picked up ideas I didn't know were possible with Excel and VBA. Even though I normally use Excel a lot in my daily work as a tool.”
"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."
“Good course, I learned a great deal from it and will certainly get a lot of use out of it at work.”
“The first impression/introduction was and is good.”
"'I thought I was already fairly handy with Excel, but I still learned a few new things in this webinar.'"
"It shows how Excel works in a simple way, very accessible for people who are not familiar with Excel."
“The course was well tailored to the participants' wishes and learning objectives, thanks to good contact with the trainer beforehand.”