Excel 2021 Basic Course E-Learning + Online Book

Experience our comprehensive Excel 2021 Basic 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: Learn and master the basics of Excel, including data entry, formatting, simple calculations, charts, and table management.
• Target Audience: Beginners with some basic knowledge who want to master the basic functionalities of Excel.
• Level: Basic
• Prerequisite Knowledge: Basic computer skills
• Course Duration: 5 hours and 22 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 Basic Course E-Learning + Online Book

Course Content:

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

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

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.