Excel Advanced + Expert e-learning course
In this e-learning course you will explore advanced Excel functions, pivot tables, formulas and collaborating in workbooks. Copilot in Excel is optionally covered as well.
NRTO quality mark
- Master advanced Excel functions
- Pivot tables and formulas in detail
- Working with Copilot in Excel
- Take the e-learning wherever and whenever you want
- Six months' access to the learning platform
Your trainer: Raoul 283 evaluations in total, averaging 8.3. View the trainers
Want to go beyond the basics of Excel? In this e-learning you dive into pivot tables, advanced formulas, macros and sharing workbooks. You work at your own pace, from anywhere. Optionally, you also cover Excel with Copilot.
Description
In this e-learning you build on your basic knowledge of Excel and work towards expert level. You get to know advanced functionality and go into more depth on formulas, pivot tables, conditional formatting, charts and protecting and sharing workbooks. Topics such as advanced function calculations, scenario management, macros and collaborating on workbooks are also covered.
The course optionally also covers working with Microsoft 365 Copilot in Excel, so that you can experience how AI supports you with analyses and calculations.
You take the course entirely online, at a time and place that suits you. Through instructional videos, assignments and additional files you work through the material at your own pace. Once you have started, you have six months' access to the platform.
Topics
- Absolute cell references and advanced functions
- Applying conditional formatting
- Working with charts and enhancing tables
- Inserting drawing objects and images
- Data lists, subtotals and filters
- Creating and using pivot tables
- Converting data and creating data series
- Checking and evaluating formulas
- Advanced function calculations with text, date, array and conditions
- Conditions with AND, OR, NOT and nested conditions
- Array formulas and financial functions
- Goal Seek and Scenario Manager
- Importing and exporting data and converting files
- Sharing, protecting and collaborating on workbooks
- Restoring versions and files
- First introduction to macros
- Optional: working with Copilot in Excel
Result
After this e-learning course you will work confidently with advanced Excel functions. You will build formulas with conditions, nested functions and array calculations. You will create pivot tables, filters and subtotals to analyse large volumes of data. You will protect workbooks, share them with colleagues and work together on the same file. You will also use goal seek, scenario manager and macros to organise your work more efficiently. Optionally, you will learn how to use Microsoft 365 Copilot in Excel to set up analyses and formulas more quickly.
Target audience
This e-learning is intended for anyone who has mastered the basics of Excel and wants to learn how to make the most of the programme's advanced possibilities. Think of staff who regularly work with figures, lists or reports and want to tackle their work more efficiently with formulas, pivot tables and smart functions. Anyone curious about the optional use of Copilot in Excel will also find this course a good starting point.
Teaching method
You follow this course entirely as e-learning. You work independently through a series of lesson videos, assignments and additional files. After each topic you check your knowledge with an assignment. Only once you have sufficient command of the material do you move on to the next part. In this way you build up your skills step by step.
You log in via an online platform, so there is nothing to install. You can follow the course wherever and whenever it suits you, as long as you have a laptop and internet access. You can always stop part-way through and continue later, as your progress is saved automatically.
You have 6 months' access to the platform and each module takes around 7 hours. Within that period you can review the material as often as you like. Optionally, the course also covers working with Copilot in Excel.
Prior knowledge
You have a command of the basic operations in Excel, such as entering data, using simple formulas and formatting cells. No other specific prior knowledge is needed. A laptop with internet access is all you need to get started.
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 can plan at your leisure when to work through the material. Optionally, you can also cover Excel in combination with Copilot.
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
“Clear and useful course with practical topics. The trainer is enthusiastic and motivating.”
"Clear training that has been very useful for my work. Highly recommended."
“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).”
“The one-day Excel PivotTables, formulas and functions course is suitable for anyone who wants to get to know the anatomy of the PivotTable in a short time and master the basics.”
“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.”
“The Excel 2010 Basics course gives you a good picture of what the new Excel has to offer. You'll be amazed by the new possibilities with charts. 180 pages won't make you a guru, but you will become a good deal more capable.”
“Highly recommended; good level, professional guidance and good materials. I particularly enjoy the keyboard shortcuts and knowing new, quick solutions.”
“A good, comprehensive training course with a good trainer. I can go through everything again at home at my leisure. Definitely recommended.”
“Another good course with plenty of content that can be put into practice well; we were also given extra exercises by the excellent trainer Sjoerd Jellema.”
“Excellent course material, a teacher with good knowledge of Excel.”
“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.”
“Over the past 2 days I followed the Excel Basics course and it has made me a good deal more skilled with Excel.”
“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.”
“It completely met my expectations; a whole new world opened up for me. A very calm trainer who took all the time you needed and explained everything clearly, so that you also understand what you are doing.”
“The training course is focused, well structured and easy to follow and complete at your own pace within the time provided.”
“Even for participants with little or no experience of the subject, it is surprising how much you can learn in two days.”
“Well-organised teamwork with a professional trainer.”
“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.”
“A clear and complete course, given by a highly competent trainer who conveys the course material in a clear and structured way.”
“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!”
"Learned a lot in a short time, and in a pleasant way"
“Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”
“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.”
“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!”
“The location of the course is perfect. The course material is clearly presented, which makes it easy to work through the subject matter.”
"An expert trainer who can quickly put himself in the position of real-life situations."
“Used Learnit for the first time and was pleasantly surprised by the concept. Small group and plenty of individual attention. There were enough training methods available through the extensive course materials.”
"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."
“'Expert tailored work, highly recommended!!”
“The course material is clear and it is pleasant to be able to work at your own pace.”
“Clear and well-structured Excel course! You go home with far more knowledge and ways to apply it”
“Excellent course! I thought I knew Excel, but I still learned nice new things that I can apply on a daily basis.”
"Self-study, but with something extra. A good teacher with a great deal of subject knowledge, who genuinely thinks along with you about applying your objectives in your own working environment."
"A course at your own level where you get support as soon as you need it. This means you can learn efficiently at your own pace!"
“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!”
“The Excel 2010 VBA course is a good introduction to macros and how to program them!”
“I found it an enjoyable and instructive course, with plenty of handy tips and facts about Excel, and I also learned a lot more about functions, pivot tables and VLOOKUP.”
“This course is a good introduction to VBA/macros. It is a mix of theory and practice.”
"Hans gives you as a course participant the feeling that you can learn Excel perfectly well, even if you are more visually inclined or more of an arts than a science person; that is extremely pleasant."
“The general impression of the course as a whole is good. You clearly get something out of this course and you can apply it at work straight away. The trainer has plenty of expertise and listens carefully to the participants.”
"A good course, a pleasant trainer, and many topics that are personally useful to me in my work."
“Professional training, given by a highly knowledgeable trainer who was very well able to pass on his knowledge in a pleasant and clear way. The content of the training was very sound. The course material really did start from the basics. I found it very pleasant that I could set the pace myself. The course material and the set-up were professional and there was plenty of variety in the assignments/exercises.”
“Excellent, you come to realise how necessary it is to take Excel courses.”
“An instructive, practically applicable Excel basics training that gives plenty of insight into everything Excel 2010 has to offer.”
“A practical course that you can actually do something with, and a course that does not take too long.”
“Well-organised course with a good trainer at an excellent location and a well-prepared lunch.”
"The Excel Pivot Tables, Functions and Formulas course gave me a great deal of inspiration for applying things in my work. Highly recommended. At the end of the day I went home enthusiastic, with a head full of new ideas and plenty of energy. That is how it should be!"
“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.”
“The Excel training course was good. We also received good materials to practise with on our own afterwards. The trainer passed on his knowledge to us in an interesting way.”
“Completely up to speed with Excel again thanks to Learnit training.”