Excel 2019 Advanced Incompany Training Course

For an Excel 2019 Advanced Course Incompany Training we offer a complete solution. Our in-company trainer will be happy to help you identify your needs and requirements and our mission is to ensure that you get as much out of the training as possible. This is why we also create customized training courses that fit your exact needs.

Incompany meaning is really nothing more than that a training is given at the location of your company. This way you, or your colleagues, do not have to leave the office to be trained by one of our certified trainers. This saves time and money. You can arrange an Incompany course quickly and easily via OEM Office Elearning Menu. You choose the Incompany course, indicate how many students you want, when you want the training on location and you will receive an appropriate quote within one working day.

Excel 2019 Advanced Incompany Training Course Objectives:

1. That the students, after attending the Incompany course, will have a good understanding of Microsoft Excel 2019.
2. That the students, after following the Incompany course, find their way around Microsoft Excel 2019 without any problems.
3. That the course participants are able to perform daily tasks using Microsoft Excel 2019.
4. That the trainees are motivated to use Microsoft Excel 2019 more efficiently.

Excel 2019 Incompany course:

• Group of up to 12 people.
• Fixed contact person
• Different options:
• Day parts (afternoon, morning or full day).
• Divide groups
• Language: Dutch or English
• Customization
• Online baseline: In advance we offer a free telephone consultation with our Microsoft certified
• trainer (MCT) who is also a Microsoft Office Specialist (MOS) Master to determine level and discuss
• objectives with expert advice.
• Intake interview / consultation with instructor (customized)
• Instructors (in-company trainer) are scheduled based on industry experience
• Trainers (in-company trainer) are scheduled based on their affinity with the target group(s).
• MOS certified instructor gives the training
• Free course advice from the in-company trainer
• Training from practice, not from a standard course book
• Logical structure of the course material
• Practical exercises
• Free handouts
• Online evaluation
• Certificate of participation
• Course books (at additional cost)
• Laptop rental (at additional cost)
• Aftercare:
• Students can ask the instructor questions about the content of the Incompany training by e-mail during a period of 3 months.

What does an Incompany training cost?

The price for an Incompany course depends on your specific requirements. There is a standard fee for half a day, without course books or rental of laptops. This is for a group of up to 12 people. If you have specific requirements or would like additional additions to your Incompany training, we would be happy to prepare a no-obligation quote for you.

Why OEM Office Elearning Menu?

OEM is the only Incompany training course offered by certified instructors with all the necessary practical experience.

Prior to the training the instructor will contact you by telephone for an intake interview.
In this conversation, the following points are determined:

• Current knowledge and skills
• Practical application of the software application(s)
• Expectations about the training
• Objectives of the training

The outcome is a customized training content. This ensures that the training is tailored exactly to the needs of the users. The actual learning needs are addressed in the training and other non-less relevant issues do not receive attention.

We offer ample opportunities for online knowledge measurement prior to the In-company training. We call this a so-called baseline measurement. The results of this baseline measurement are always analyzed by a Microsoft Office certified instructor. This analysis results in a recommendation regarding the approach and content of the training and, if necessary, the composition of the group.

Duration

1 day, 6 hours of lessons. Training times from 9:30 am to 4:30 pm or otherwise as required.

Course content Excel 2019 Advanced Course

Setting up calculations

• Functions and formulas
• Commonly used functions, SUM, MEDIUM, MIN and MAX, NUMBER
• Relative and absolute addresses
• Logical functions, ALS, ALS.CONDITIONS, combining functions
• Delete redundant decimals
• MEDIUMDEA, MAXA and MINA
• Search functions: VERT.SEARCH, X-SEARCH
• Date and time functions
• Financial and text functions
• Worksheet checking, cell relationships, error messages
• Naming, defining and applying cells
• 3D calculation over spreadsheets
• Target search

Tables / databases

• Table creation, sorting and filtering
• Add or remove table rows and columns
• Adding total rows
• Create, sort and filter database
• Slicer, Timeline
• Database functions: SUM.AS, NUMBER.AS
• Pivot tables and charts

Excel Incompany Training Request or would you like Incompany advice?

Contact us or request a quote here.

What is Excel?

Excel is a powerful software application developed by Microsoft that is primarily used to create and manage spreadsheets. It allows users to enter, organize and analyze data using a grid of cells arranged in rows and columns.

Excel provides a range of functions and formulas to perform calculations, create graphs and visualize data. It is commonly used in various industries and for various tasks, such as financial planning, budgeting, data analysis and reporting.

10 benefits of Excel

1. Data management: Excel allows users to manage large amounts of data in an organized and efficient manner.
2. Calculations: Excel includes a wide range of formulas and functions that allow users to perform complex calculations.
3. Charts and visualizations: Excel allows users to visualize data and create charts to identify trends and patterns in the data.
4. Automation: Excel uses macros and VBA (Visual Basic for Applications) to automate processes and tasks.
5. Easy to use: Excel has a user-friendly interface and is easy to learn, even for beginners.
6. Efficiency: Excel allows users to organize and analyze data quickly and easily, saving time and costs.
7. Collaboration: Excel can be used to share data and collaborate with colleagues and teams.
8. Flexibility: Excel can be customized and tailored to meet the specific needs of users and their businesses.
9. Availability: Excel is widespread and available on most computers, meaning it is easily accessible to users.
10. Integration: Excel can be integrated with other software applications, allowing users to import and export data and work seamlessly with other programs.

Why is Excel imoprtant?

Excel is important because it is a powerful tool for managing data, making calculations and visualizing information. It allows users to organize and analyze large amounts of data in a structured and efficient manner.

This can help make informed decisions and improve business performance.

Excel is also easy to use and adapt to a company's specific needs, making it a valuable tool for professionals in various industries and functions.

Moreover, Excel is widely used in businesses and organizations, making it an essential part of daily work for many people.

Why OEM Office Elearning Menu?

OEM Office Elearning Menu has years of experience in providing online courses and training. From Excel, Word and Outlook to high professional ICT training for Cisco, AWS, CompTIA and more. 

OEM is an official Microsoft Partner, CertiPort Partner and EC-Council Partner. With over 1000 courses from more than 200 brands, our offer is suitable for every PC user. Whether you are a first time PC user starting up Word for the first time, or an ICT professional wanting to know more about Data Security; OEM has the right course or training for you. Missing a training? Let us know and we will gladly look at the options together.

Each completed course provides you with an official certificate of participation. This is personal and specifically addressed to the student. Every Incompany training course automatically delivers a certificate of participation. For each E-learning course you need to have completed at least 70% of the practical assignments to receive a certificate of participation.

OEM - Learn to Work

Choose from 1000+ training courses from 200+ brands for your personal and business development. 

An Excel course, Word course or even a full Office course always comes in handy. We deal with Microsoft programs on a daily basis and it will save you a lot of time to master them properly.

We also have training courses for ICT professionals at OEM Office Elearning Menu. For example, you will learn to deal with databases, servers, learn programming or even become a certified ethical hacker. Learn everything online through E-learning, through course books, walk-in trainings or through Incompany trainings within the company you work for.