Course Excel 3652019 Basic E-Classroom Pro

• Audience: The Excel Basic course is suitable for individuals who want to learn the basics of Excel and familiarize themselves with the functions and tools to create, edit and analyze spreadsheets.
• Level: Basic
  
• Required knowledge level: Basic computer knowledge
• Course duration: 4:10 (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)

With the E-Classroom Pro Excel course, you have the opportunity to experience a unique learning experience, with personal guidance from a certified teacher in a physical classroom. Additionally, you will use Microsoft gold-certified interactive e-learning modules that are specially designed to efficiently and effectively achieve your learning goals. As an additional benefit, we offer all participants who book this training a first-class return train ticket up to 50 euros, so you can enjoy a great experience from the beginning to the end of the Excel course.

After the first training, you will receive the official course book and have access to e-learning for a year, allowing you to learn at your own pace while still benefiting from the support and expertise of a professional teacher. If you are looking for a flexible way to improve your Excel skills, then E-Classroom Pro is for you. You can decide when to take the training, making it easier to combine with your work.

Thanks to personal guidance in small groups, you have more opportunities to ask questions and receive individual attention. Additionally, you can achieve your learning goals more efficiently with the help of interactive e-learning modules, allowing you to spend less time on training. You are assured of high-quality training thanks to the guidance of a certified teacher. After each session, you have the opportunity to review and repeat what you have learned, so you can master your skills even better.

Choose E-Classroom Pro and improve your Microsoft Office skills at your own pace with the help of a professional teacher. Book the Excel course now and take advantage of the first-class return train ticket up to 50 euros to enjoy a great experience from the beginning to the end of the course.

Course content Excel 365 2019 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

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