Excel Basics + Advanced e-learning course
In this e-learning course you learn to work with Excel: from data entry, formulas and formatting to charts, filters and pivot tables. Optionally, you are introduced to Copilot in Excel.
NRTO quality mark
- You master Excel at your own pace
- From basics to pivot tables in one bundle
- Optional attention to Copilot in Excel
- Directly applicable in your daily work
- Six months' access, anytime and anywhere
Your trainer: Raoul 283 evaluations in total, averaging 8.3. View the trainers
With this Excel Basics + Advanced e-learning you become proficient in formulas, tables, charts and pivot tables at your own pace. You work at home or in the office, with 6 months' access. Optionally, you can also cover Excel with Copilot.
Description
In this e-learning you get to know Excel at your own pace and build up your knowledge step by step to an advanced level. You work with two modules full of instructional videos, exercises and additional files, so that you actively master the material. The course also optionally covers working with Copilot in Excel.
You start with the basics: entering data, building formulas, formatting tables and preparing your worksheets neatly for printing. After that you move on to absolute cell references, conditional formatting, charts, filters and pivot tables. This is how you learn to make large amounts of data clear and to analyse them.
You have six months' access to the online platform and can pause and resume the course at any time. Your progress is saved automatically, so you always continue where you left off.
Topics
In this e-learning you will come across the following topics, among others:
- Discovering Excel and working with workbooks
- Entering, selecting, copying and pasting data
- Building formulas and functions
- Formatting cells and data
- Page setup and printing
- Sorting tables and grouping data
- Absolute cell references and more advanced functions
- Conditional formatting
- Creating charts and presenting them attractively
- Inserting drawing objects and images
- Working with data lists and subtotals
- Creating and applying filters
- Building pivot tables and carrying out analyses
- Optional: using Excel in combination with Microsoft 365 Copilot
Result
After this e-learning you will work independently with Excel. You enter data and formulas, format tables and charts, and set up the page layout for printing. You manage large tables using sorting and filtering options, and analyse data with pivot tables and subtotals.
You work with absolute cell references, conditional formatting and advanced functions. Optionally, you will also know how to use Microsoft 365 Copilot as an AI assistant in Excel, for example to analyse data or generate formulas.
Target audience
This course is intended for beginners who want to master the basic functions of Excel. Do you already have some basic knowledge? That is a bonus, but not a requirement. You learn to work with formulas, tables, charts and pivot tables at your own pace. Would you also like to discover how Copilot can support you in Excel? You can optionally cover this during the course.
Teaching method
You follow this course entirely online via an e-learning platform. The material consists of short instructional videos, exercises and additional files per topic. You work at your own pace and can rewatch a video as often as you like.
After each topic you complete exercises to test your knowledge. Only once you have sufficient command of a section do you move on to the next. This way you build a solid foundation step by step.
You have 6 months' access to the platform and can pause at any time and continue later. Your progress is saved automatically. You can log in from anywhere with a laptop and an internet connection, without having to install Excel locally.
Prior knowledge
You don't need any prior knowledge of Excel. If you can use a computer and know how to open a program, you can get started straight away. We start with the basics and build things up step by step, so you can progress at your own pace.
Comments
You follow this e-learning entirely at your own pace. Once you have started, you have six months' access to the platform, so you decide when and where you learn. A laptop with an internet connection is all you need.
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, comprehensive training course with a good trainer. I can go through everything again at home at my leisure. Definitely recommended.”
“The training course is focused, well structured and easy to follow and complete at your own pace within the time provided.”
“If you are looking for a programme to improve your chances on the job market, I would certainly recommend one of the courses, if only to refresh your knowledge!”
“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.”
“Macros are very applicable to your own working situation. A very good course that fits your personal needs well.”
“A practical course that you can actually do something with, and a course that does not take too long.”
“An interesting and instructive course with plenty of variety”
“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!”
“Learned a great deal in a short time, in a very clear and accessible way. A very efficient method for me!”
“A good training course for non-computer specialists too, and you're sure to learn a great deal from it.”
“An enjoyable and clear course that is easy to follow for novice "Excellers".”
"Good, comprehensive course, clear materials, highly recommended!"
“An excellent course for people who use Excel daily or weekly and want to simplify its practical application.”
"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."
“Very suitable for anyone who has worked with Excel before, but would still like to go through the fundamentals of the package once in order to build up solid basic knowledge.”
“Well-organised teamwork with a professional trainer.”
“Instructive”
“It is enjoyable and very instructive, definitely recommended. I learned a great deal from it and it will be of much use to me in the future.”
“The Excel 2007 Intermediate course is very well set up; interesting topics and applications that can be used at work straight away after practising.”
"A good interactive course, with room to learn how to resolve situations from practice."
“The trainer's enthusiasm was infectious! She had no trouble at all switching between the different levels of the participants and/or between the different applications.”
“It's good to be able to work through the course at your own pace. If you have questions, you can turn to the trainer.”
“I sincerely recommend it, training at a good level with very carefully prepared materials.”
“A good, practical course that you can do at your own pace. There is plenty of room to ask questions while still working at your own pace.”
“Excellent training. You work at your own pace. The guidance is very good and takes your own issues into account. Recommended for all levels.”
“Very educational course with a good individual approach that matches the participant.”
“Clear and useful course with practical topics. The trainer is enthusiastic and motivating.”
“Very useful to get to grips with your own topics at your own pace. Guidance was perfect.”
“The open learning format is well worth recommending if you like working independently at your own pace. The trainer answers your questions when needed and is happy to give advice and extra useful information suited to your level. The course material is clear and lets you practise new skills several times so that you really master them.”
“An engaged, enthusiastic and experienced trainer, which makes the course accessible to everyone.”
“Enjoyable and very practice-oriented training”
“The trainer was highly driven and motivated. Excellent explanations and good interaction with me as the knowledge recipient. Sufficient depth, excellent course.”
“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.”
“Enjoyable course, learnt a lot and everything at my own pace.”
“Excellent course thanks to good guidance and clearly structured assignments that allowed the newly acquired knowledge to be applied straight away.”
“Very useful training course! You take home a good reference manual in which you can look things up. The trainer has a great deal of knowledge and explains things well. Recommended!”
“The content is surprising and you can put a lot of the material into practice.”
"A good, practice-oriented course that allows you to get started quickly yourself and to improve your daily working methods and make them more efficient."
“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.”
"A good, committed trainer who tries to offer knowledge that matches the level and the questions of the participants"
“Excellent training. You work at your own pace. The guidance is very good and takes your own issues into account. Recommended for all levels.”
“A plus point is that the teaching is not classroom-based, so you can work at your own pace. Two days is exactly enough.”
“Very good training course, clear explanations. The atmosphere is good because the groups are not too large. The trainer is highly knowledgeable and takes all the time needed when there are questions. Very handy and usable in practice. Learned a lot that I can put to good use.”
“Good, clear explanations. The trainer also takes the time to answer questions along the way.”
"The advantage, I found, was that you work individually, so that everyone can work at his or her own pace."
“A pleasant way of picking out from the complete set of course materials only those subjects you are interested in, without being worn out by matters you have no interest in.”
“Efficient for people who already use databases in Excel a great deal.”
“Every single participant was enthusiastic. They all took something away from it. Nice that the course can be given at the office.”
"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!"
“The course is given by a trainer with a great deal of knowledge and a passion for Excel, which is contagious. The readers used are very clear and contain exercises you can work through yourself. Together, the readers from the basics and follow-up courses form a well-organised reference work for the workplace.”