Excel 2021 Advanced and Expert E-Learning Course

Experience our comprehensive Excel 2021 Advanced and Expert E-Learning course in a virtual Office 365 cloud environment. This training includes practical assignments and interactive videos with voice and subtitles. 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 the advanced and expert functions of Excel, including advanced calculations, pivot tables, complex charts, and managing large datasets.
• Target Audience: Users who already have a grasp of basic Excel functionalities and wish to expand their knowledge to advanced and expert levels.
• Level: Advanced and Expert
• Prerequisite Knowledge: Basic Excel 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

Course Content:

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

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.