Course Excel 365 2019 Expert E-Classroom Pro

• The target audience for someone who wants to take a Microsoft Excel expert course are individuals who want to expand their skills and knowledge in Excel and be able to perform complex tasks using advanced functions and formulas.
• Level: Expert
  
• Required knowledge level: Excel Advanced
• Course duration: 4:00 (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 Expert course, you will have the opportunity to receive personal guidance from a certified instructor in a physical classroom setting. In addition, we offer interactive e-learning modules specifically designed to achieve your learning goals in an efficient and effective manner. As an added benefit, we offer all participants who book this training a 1st class return train ticket up to 50 euros.

After the first training you will receive the official course book and have access to our e-learning for one year. This allows you to learn at your own pace while benefiting from the expertise of a professional instructor. If you are looking for a flexible way to improve your Excel skills, E-Classroom Pro is the ideal choice for you, as you can decide when to take the training and thus combine it more easily with your work.

Personal guidance and the interactive e-learning modules allow you to reach your learning goals more efficiently, reducing the amount of time you need for training. The training is delivered by a certified instructor, which ensures the quality of the training. After each session, you will have the opportunity to review and repeat what you have learned at your leisure, allowing you to 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 instructor. Book the Excel course now and take advantage of our 1st class return train ticket up to 50 Euros, ensuring you have a great experience from the beginning to the end of the course. Find out how to take your Excel skills to the next level with our excellent training.

Course Content Excel 365 2019 Expert Course

This module offers you an interactive training, consisting of 42 teaching videos, 42 assignments and
5 files with additional information.

Work even more efficiently

• Convert data
• What you need to know about: Auto-Fast Fill
• Using data series
• Custom Views
• Note to cell
• Error checking
• Evaluate Formulas
• Control window

Use advanced function calculations

• Search table and functions
• Text functions
• Calculate time
• Calculate dates
• Conditions with AND, OR, NOT
• Some conditions
• Conditional Functions
• Array Formula
• Calculations with copies
• To merge
• Financial functions
• Double Entry Table

Discover new functionalities

• Goal Seeking
• Solver
• Scenario management
• Hyperlink
• What you need to know about: Styles and Templates
• Create and customize a theme
• Create and use a template
• What you need to know about: Import, export and interoperability
• Editing and Deleting a Template
• Transfer Excel data: PDF, XPS, email and web page
• Convert Excel files
• Import data
• Update and manage imported data
• Workbook properties

Share workbooks in a safe way

• Security workbook
• Protect cells
• Share a workbook
• Track workbook changes
• Merge workbooks
• Completion of a workbook
• Digital signature
• Create a form
• Securing and using a form

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