Excel 365 Basic Course E-Learning + Online book

• Target group: Beginners with some basic knowledge who want to master the basic functionalities of Excel
• Level: Basic (also available in Advanced and Expert)
• Required knowledge level: Basic computer knowledge
• Course duration: 4:10 (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.

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.

This module includes an online book for additional support.

Basic
This module offers you an interactive training, consisting of 45 learning videos, 45 assignments and
5 files with additional information.

Introduction to Excel, filling out a table

• What you need to know about: Spreadsheets
• Opening workbooks
• General work environment
• Moving around in a workbook
• What you need to know about: Entry help
• Entering data
• What you need to know about: Selecting, copying and moving
• Selecting and deleting cells
• Cancel and restore operation
• Column width/row height
• What you need to know about: Saving files
• Saving workbooks
• Modifying cell contents
• Creating a new workbook

Make your first calculations

• Entering formulas
• Sum and other simple calculations
• Calculating a percentage
• Copy to adjacent cells

Take care of formatting your data

• Simple number notations
• Apply Theme
• Character Formatting
• Font and font size
• Aligning cell contents
• Cell Color
• Cell borders

Print and set up page layouts in your worksheets

• Page Layout
• Print preview and print
• Page Break
• Print area
• What you need to know about: Header and footer
• Header and footer

Working more efficiently with Excel

• Using Excel help
• Spellcheck
• Search and Replace
• Zooming in and out
• Inserting or removing rows, columns and cells
• Moving cells
• Copy to non-adjacent cells
• Quickly copy cell formatting
• Merge cells
• Print cell contents
• Cell styles
• Sorting a table

Manage worksheets

• Worksheet name and tab color
• Inserting, deleting worksheets and setting the background
• Move, copy and hide worksheets
• Block column/row, split screen
• Print column and row titles repeatedly
• Hide worksheet items
• Grouping data in view

Office 2019: Cases
Excel, Word or PowerPoint with an Office 365 subscription
This module offers a 20-minute video.

• Creating an email message with or without an Office 365 subscription: what are the differences?
• Creating and saving Office documents to OneDrive, SharePoint Online, or Teams
• Edit a document from OneDrive, SharePoint, or Teams
• Sharing Office documents with colleagues or with people outside the organization
• Collaborating on a file

Excel 2019: Cases
This module provides you with a video that is 48 minutes in length.

• Setting up quality control
• Presentation of the user case
• Creating the statistical formulas
• Preparing the diagram
• Create a control chart
• Adjusting the display of the control chart
• Conclusion

Analyzing the library visit

• Presentation of the use case
• The graph Development of the number of visitors
• Creating the pivot tables
• Conclusion

Keeping track of the budget

• Presentation of the use case
• Creating the pivot tables
• Creating the charts
• Creating the dashboard
• Conclusion

Reducing costs

• Presentation of the use case
• Creating the formulas
• Solving the problem with the Solver
• Conclusion