Start an online Excel 2021 Custom course now. You start the course with a practical (pre-test) beforehand, the result of this test is imported into your course so that you have a tailor-made course.
Read more.
Bulk discount
No discount
1 Piece
€121,00€100,00
5% Discount
5 Pieces
€114,95€95,00/ Piece
10% Discount
11 Pieces
€108,90€90,00/ Piece
15% Discount
31 Pieces
€102,85€85,00/ Piece
20% Discount
61 Pieces
€96,80€80,00/ Piece
30% Discount
101 Pieces
€84,70€70,00/ Piece
40% Discount
251 Pieces
€72,60€60,00/ Piece
50% Discount
501 Pieces
€60,50€50,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 2021 Custom E-Learning Course
Experience our comprehensive Excel 2021 Custom E-Learning course in a virtual Office 365 cloud environment. This training includes practical assignments and interactive videos with voice and subtitles, preceded by a practical pre-test. The results of this test are imported into your course, providing you with a customized training experience. Your answers are analyzed in real-time, and your progress is tracked through detailed reports. This course, developed by experienced MOS instructors and published by a Microsoft Gold Partner, prepares you for the MOS exam. You will receive a certificate of completion after finishing more than 70% of the course. The content is SCORM-compliant.
Objective: Master Excel at your own pace and level, including data entry, formatting, simple and complex calculations, charts, managing large tables, pivot tables, and advanced functions. The pre-test results allow you to focus only on what you need to learn.
Target Audience: Users who want a tailored learning experience to master the functionalities of Excel at their own pace.
Level: Customizable to Basic, Advanced, and Expert levels
Prerequisite Knowledge: Basic computer skills
Course Duration: 14 hours and 50 minutes (Video clips averaging 2-5 minutes, depending on personal speed)
Language: Dutch or English
Online Access: 24/7, 365 days after activation
Includes: Online book and Certificate of Completion
Demo Excel 2021 Course Custom E-Learning
Course Content
Tailored to your learning needs and goals in Excel, with progress reports indicating areas for improvement and efficiency.
Basics
Introduction to Excel, filling in a table
What you need to know about: Spreadsheets
Opening workbooks
General work environment
Moving within a workbook
What you need to know about: Data entry assistance
Entering data
What you need to know about: Selecting, copying, and moving
Selecting and deleting cells
Undoing and redoing actions
Column width and row height
What you need to know about: Saving files
Saving workbooks
Adjusting cell content
Creating a new workbook
Make your first calculations
Entering formulas
Sum and other simple calculations
Calculating percentages
Copying to adjacent cells
Simple number formats
Applying a theme
Text formatting
Font and font size
Aligning cell content
Cell color
Cell borders
Print and set up page layout for your worksheets
Page layout
Print preview and printing
Page breaks
Print area
What you need to know about: Headers and footers
Headers and footers
Work more efficiently with Excel
Using Excel help
Spell check
Find and replace
Zoom in and out
Inserting or deleting rows, columns, and cells
Moving cells
Copying to non-adjacent cells
Quickly copying cell formatting
Merging cells
Printing cell content orientation
Cell styles
Sorting a table
Worksheet name and tab color
Inserting, deleting, and setting the background of worksheets
Moving, copying, and hiding worksheets
Freezing columns/rows, splitting the screen
Repeating column and row titles
Hiding items on the worksheet
Grouping data in an outline
Advanced
Transition to complex tables
Displaying multiple lines in a cell
Absolute references in a formula
Copying and transposing calculation results and links
What you need to know about: Entering functions
System date and date format
Simple conditions
Custom formats
Applying conditional formatting
Managing conditional formatting
Naming a cell range
Validation criteria
Cell ranges in functions
Present your data in chart form
What you need to know about: Charts
Creating and moving a chart
Managing a chart
Selecting chart elements
Adding or removing chart elements
Formatting chart elements
Changing chart text elements
Legend and plot area
Printing a chart and page layout
Improve the appearance of your charts
Changing data labels
Data series and chart axes
Managing series
Chart type options
Managing chart templates
Creating a 2D map chart
Creating a sparkline chart
Managing sparklines
Enhance your tables
Creating a graphic object
Selecting and deleting objects
Copying and moving objects
Resizing a graphic object
Modifying a text box
Editing a shape
Formatting drawing objects
Inserting an image
Managing images
Rotating and aligning objects
Overlapping and grouping objects
Utilize your data
What you need to know about: Flash Fill
Calculating subtotals
Creating and managing a data table
Formatting and sorting a data table
Adding calculations to a data table
Auto filter
Custom filters
Empty and duplicate values
What you need to know about: Criteria ranges
Filtering with criteria range
Filtering and copying rows with criteria range
Calculations with criteria range
Sorting and filter functions
Create and use pivot tables and charts
What you need to know about: Pivot tables and charts
Creating a pivot table
Modifying a pivot table and adding calculations
Changing pivot table source
Selecting, copying, moving, and deleting a pivot table
Structuring and printing a pivot table
Formatting a pivot table
Filtering a pivot table
Filtering with slicers
Basing a pivot table on multiple data tables
Adding fields or calculated elements
Grouping pivot table data
Creating a pivot chart
Excel 2021: Cases
This module offers a 48-minute video.
Set up a quality control
Presentation of the use case
Creating statistical formulas
Preparing the chart
Creating a control chart
Adjusting the control chart display
Conclusion
Analyze library visits
Presentation of the use case
Creating the Development of Visitor Numbers chart
Creating pivot tables
Conclusion
Track budget
Presentation of the use case
Creating pivot tables
Creating charts
Creating the dashboard
Conclusion
Reduce costs
Presentation of the use case
Creating formulas
Solving the problem with Solver
Conclusion
Office 2021: Cases
Excel, Word, or PowerPoint with an Office 365 subscription
This module offers a 20-minute video.
Creating an email with or without an Office 365 subscription: what are the differences?
Creating and saving Office documents in OneDrive, SharePoint Online, or Teams
Editing a document from OneDrive, SharePoint, or Teams
Sharing Office documents with colleagues or external persons
Collaborating on a file
Expert
Excel 2021: The Reference Work
This comprehensive reference work provides a detailed overview of all the functions of the widely used spreadsheet program Microsoft® Excel, version 2021. It is intended for anyone who wants to learn to use this program or expand their knowledge about it.
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.
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