Microsoft Excel 365 Course Basic Advanced Expert E-learning
€108,90€90,00
€95,59€79,00Incl. taxExcl. tax
In stock
Take an Excel 365 Basic, Advanced and Expert course now online. You will learn how to enter formulas, copy calculation results and links, transpose and adjust notation.
Read more.
Bulk discount
No discount
1 Piece
€95,59€79,00
-8% Discount
5 Pieces
€102,85€85,00/ Piece
-1% Discount
11 Pieces
€96,80€80,00/ Piece
5% Discount
31 Pieces
€90,75€75,00/ Piece
11% Discount
60 Pieces
€84,70€70,00/ Piece
24% Discount
101 Pieces
€72,60€60,00/ Piece
37% Discount
251 Pieces
€60,50€50,00/ Piece
49% Discount
501 Pieces
€48,40€40,00/ Piece
Make a choice
Officieel examen Online of fysiek
Start nu – bekroonde e-learning Inclusief proefexamens & 24/7
ISO 9001 & 27001 werkwijze 1000+ organisaties gingen u voor
Maatwerk & gratis intake Inclusief nulmeting bij training
Product description
Excel 365 Course Basic Advanced Expert E-Learning
Target group: Anyone with basic knowledge who wants to master the advanced features of Excel
Course duration: 14:50 (Video clips of 2 to 5 minutes / depending on personal speed)
Online access: 24/7, 365 days after activation
Online book included
Certificate of Participation included(after a minimum of 70% success rate)
Get to know the spreadsheet program Excel with this Excel course and master the basic to advanced functionalities. After attending the Excel course, you will be able to make full use of Excel. All necessary basic topics will be covered such as: entering and formatting data, simple to complex calculations, charts, managing large tables, pivot tables and various advanced functionalities.
During the Advanced and Expert classes, you will go deeper and learn more about the advanced/expert features of Excel. Thanks to this course, you will learn about new functionalities and better utilize others.
Unique Excel 365 course (version 2019) in a virtual Office 365 cloud environment with practice exercises and rich interactive videos with voice and subtitles. In addition, it shows a real-time analysis of your answers and has progress monitoring through reports.
This Excel e-learning course also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Developed by MOS teachers with more than 27 years of experience. The publisher is also a Microsoft Gold Partner. The Learning Portal (LMS) includes reports and after passing at least 70% of the course you will receive a certificate of participation. SCORM is also an option for this course.
Demo Excel 365 Cursus Basis Gevorderd Expert E-learning
Content of the training
Basic
This module offers you an interactive training, consisting of 45 teaching videos, 45 assignments and 5 files with additional information.
Introduction to Excel, fill in a table
What you need to know about: Spreadsheets
Open workbooks
General working environment
Move in workbook
What you need to know about: Input Help
Enter data
What you need to know about: Select, copy and move
Select and clear cells
Cancel and restore operation
Column width/row height
What you need to know about: Saving files
Save workbooks
Adjust cell contents
Create new workbook
Make your first calculations
Enter formulas
Sum and other simple calculations
Calculate percentage
Copy to adjacent cells
Take care of the formatting of your data
Simple number formats
Apply theme
Character format
Font and size
Align Cell Contents
Cell color
Cell borders
Print and set page layout your worksheets
Page layout
Print preview and printing
Page break
Print Range
What you need to know about: Header and Footer
Header and Footer
Work more efficiently with Excel
Using Excel Help
Spell check
Find and replace
Zoom in and out
Insert or delete rows, columns, and cells
Move cells
Copy to non-adjacent cells
Quick copy cell formatting
Merge cells
Cell contents orientation
Cell Styles
Sort a table
Manage the worksheets
Worksheet name and tab color
Insert, delete worksheets and set background
Move, copy, and hide worksheets
Block column/row, split screen
Print column and row titles repeatedly
Hide items on worksheet
Group data in overview
Advanced
This module offers you an interactive training, consisting of 60 teaching videos, 60 assignments and 5 files with additional information.
Evolving into complicated tables
Show multiple lines in cell
An absolute reference in formula
Copy, transpose calculation results and links
What you need to know about: Entering functions
System date and date format
Simple condition
Custom format
Apply a conditional format
Manage conditional formatting
Cell Range Name
Validation criterion
Cell ranges in functions
Present your figures in graph form
What you need to know about: Charts
Create and move a chart
Manage a chart
Select chart elements
Add or remove chart elements
Formatting chart elements
Change Chart Text Elements
Legend and Artboard
Print a chart and page layout
Improve the layout of your charts
Change data labels
Data series and chart axes
Manage sequences
Chart Type Options
Manage chart templates
Create a 2D map chart
Create a sparkline chart
Manage Sparklines
Beautify your tables
Create a graphic object
Select and delete objects
Copy and move objects
Determine graphic object size
Change a text box
Edit a shape
Formatting drawing objects
Insert an image
Manage images
Rotate and align objects
Overlap and group objects
Take advantage of your data lists
Calculating Subtotals
Create and manage a data table
Displaying and sorting data from a data table
Add calculation to a data table
Automatic filtering
Custom filters
Empty and duplicate values
What you need to know about: Criteria ranges
Filter by criteria range
Filter and copy rows with criteria range
Criteria Range Calculations
Create and use pivot tables and charts
What you need to know about: PivotTables and Charts
Create pivot table
Modify a pivot table and add calculations
Change the source of a pivot table
Select, copy, move, and delete a pivot table
PivotTable Structure and Printing
Layout of a pivot table
Filtering a pivot table
Filtering using slicers
Basing a PivotTable on Multiple Data Tables
Add fields or calculated elements
Group data
Create a pivot chart
Expert
This module offers you an interactive training, consisting of 42 teaching videos, 42 assignments and 5 files with additional information.
Work even more efficiently
Convert data
What you need to know about: Auto-Fast Fill
Using data series
Custom Views
Note to cell
Error checking
Evaluate Formulas
Control window
Use advanced function calculations
Search table and functions
Text functions
Calculate time
Calculate dates
Conditions with AND, OR, NOT
Some conditions
Conditional Functions
Array Formula
Calculations with copies
To merge
Financial functions
Double Entry Table
Discover new functionalities
Goal Seeking
Solver
Scenario management
Hyperlink
What you need to know about: Styles and Templates
Create and customize a theme
Create and use a template
What you need to know about: Import, export and interoperability
Editing and Deleting a Template
Transfer Excel data: PDF, XPS, email and web page
Convert Excel files
Import data
Update and manage imported data
Workbook properties
Share workbooks in a safe way
Security workbook
Protect cells
Share a workbook
Track workbook changes
Merge workbooks
Completion of a workbook
Digital signature
Create a form
Securing and using a form
To learn more about it…
Macro command
Restore versions and files
What you need to know about: Customizing the ribbon
What you need to know about: Good Spreadsheet Habits
What you need to know about: Collaborate on a workbook
Office 2019: Cases Excel, Word or PowerPoint with an Office 365 subscription This module offers you a video with a length of 20 minutes.
An e-mail message from Office with or without an Office 365 subscription: what are the differences?
Create and save Office documents on OneDrive, SharePoint Online or Teams
Edit a document from OneDrive, SharePoint, or Teams
Share Office documents with colleagues or with people outside the organization
Collaborate on a file
Excel 2019: Cases This module offers you a video with a length of 48 minutes.
Set up a quality control
Presentation of the use case
Creating the Statistical Formulas
Prepare the chart
Create control chart
Customize control chart display
Conclusion
Analyzing library visits
Presentation of the use case
The graph Evolution of visitor numbers
Create the pivot tables
Conclusion
Keep track of budget
Presentation of the use case
Create the pivot tables
Creating the charts
Create the dashboard
Conclusion
Reduce costs
Presentation of the use case
Creating the Formulas
Solve the problem with the Solver
Conclusion
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
Data management: Excel allows users to manage large amounts of data in an organized and efficient manner.
Calculations: Excel includes a wide range of formulas and functions that allow users to perform complex calculations.
Charts and visualizations: Excel allows users to visualize data and create charts to identify trends and patterns in the data.
Automation: Excel uses macros and VBA (Visual Basic for Applications) to automate processes and tasks.
Easy to use: Excel has a user-friendly interface and is easy to learn, even for beginners.
Efficiency: Excel allows users to organize and analyze data quickly and easily, saving time and costs.
Collaboration: Excel can be used to share data and collaborate with colleagues and teams.
Flexibility: Excel can be customized and tailored to meet the specific needs of users and their businesses.
Availability: Excel is widespread and available on most computers, meaning it is easily accessible to users.
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.
Hele uitgebreide training Excel. In de cursus ga je heel Excel door via korte filmpjes en daarna steeds een oefening die je uit kan voeren op een virtuele server. Je hoeft dus zelf niet Excel 2019 te hebben. Je kan het helemaal in je eigen tempo doen en hebt een jaar lang toegang tot de cursusomgeving. Ook bevat de cursus een Excel handboek, waarin je online kan zoeken om de onderwerpen net op een andere manier nog eens na te lezen (heel fijn). De filmpjes bevatten zowel spraak als ondertiteling, dus ook heel duidelijk te volgen als je even veel omgevingsgeluiden hebt. Ook heel fijn vond ik de 5 praktijkgerichte filmpjes met Excel-cases, waarin een praktische praktijkvraag in Excel wordt opgelost met duidelijke video's. Hierbij zitten dan geen oefeningen, maar je kan de opdrachten zelf nog eens uitvoeren m.b.v. de oefenbestanden die je kan downloaden. Ook de service vanuit Office Elearning Menu vond ik fijn: bij vragen werd ik goed geholpen. Het enige minpuntje is dat de oefeningen soms heel basic zijn t.o.v. de stof, maar ik loste dat op door dan zelf in Excel ook nog de stof uit het filmpje toe te passen als ik het gevoel had niet genoeg geoefend te hebben. Na het uitvoeren van de opdracht probeerde ik dan nog wat functies uit, voordat ik naar de volgende opdracht ging. Samenvattend vond ik deze training een superfijne cursus en kan ik het iedereen aanraden die Excel op een diepgaand niveau wil leren kennen en leren toepassen.
Valentina
Posted on 21 April 2022 at 11:48
Ik was opzoek naar een training voor Excel en ik kwam hier terecht.
Uitstekend uitgelegd met virtuele video's met veel praktijk opdrachten met een virtueel boek. Je krijgt meteen feedback door een video die de oplossing uitlegt. Was onder de indruk, ben erg verrast. Aanrader.
Vragen over dit product?
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019
Hele uitgebreide training Excel. In de cursus ga je heel Excel door via korte filmpjes en daarna steeds een oefening die je uit kan voeren op een virtuele server. Je hoeft dus zelf niet Excel 2019 te hebben. Je kan het helemaal in je eigen tempo doen en hebt een jaar lang toegang tot de cursusomgeving. Ook bevat de cursus een Excel handboek, waarin je online kan zoeken om de onderwerpen net op een andere manier nog eens na te lezen (heel fijn). De filmpjes bevatten zowel spraak als ondertiteling, dus ook heel duidelijk te volgen als je even veel omgevingsgeluiden hebt. Ook heel fijn vond ik de 5 praktijkgerichte filmpjes met Excel-cases, waarin een praktische praktijkvraag in Excel wordt opgelost met duidelijke video's. Hierbij zitten dan geen oefeningen, maar je kan de opdrachten zelf nog eens uitvoeren m.b.v. de oefenbestanden die je kan downloaden. Ook de service vanuit Office Elearning Menu vond ik fijn: bij vragen werd ik goed geholpen. Het enige minpuntje is dat de oefeningen soms heel basic zijn t.o.v. de stof, maar ik loste dat op door dan zelf in Excel ook nog de stof uit het filmpje toe te passen als ik het gevoel had niet genoeg geoefend te hebben. Na het uitvoeren van de opdracht probeerde ik dan nog wat functies uit, voordat ik naar de volgende opdracht ging. Samenvattend vond ik deze training een superfijne cursus en kan ik het iedereen aanraden die Excel op een diepgaand niveau wil leren kennen en leren toepassen.
Valentina
Posted on 21 April 2022 at 11:48
Ik was opzoek naar een training voor Excel en ik kwam hier terecht.
Uitstekend uitgelegd met virtuele video's met veel praktijk opdrachten met een virtueel boek. Je krijgt meteen feedback door een video die de oplossing uitlegt. Was onder de indruk, ben erg verrast. Aanrader.
Wij gebruiken functionele en analytische cookies om onze website goed te laten werken en het gebruik ervan te meten met Google Analytics. Er worden geen persoonsgegevens gedeeld voor advertentiedoeleinden. Door op "Accepteren" te klikken, geeft u toestemming voor het plaatsen van deze cookies.
Manage cookies