Excel 365 Course Basic Advanced Expert E-Learning

• Target group: Anyone with basic knowledge who wants to master the advanced features of Excel
• Level: Basic, Advanced + Expert
  
• Required knowledge level: Basic computer knowledge
• Course duration: 14:50 (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)

How does the E-learning Box work?

1. Would you like to start with your course?
   Send your code, name and e-mail to [email protected] with subject: E-learning Box.
2. You will receive a confirmation by e-mail to begin your course.
3. Follow the instructions in the confirmation email to start your course.
4. You now have 365 days to finish your course and receive your certificate of participation.

Excel training

This Excel course provides a comprehensive introduction to the Excel spreadsheet program and enables the student to master both basic and expert functionalities. By taking this course, you will be able to fully use Excel and master all the necessary basic topics such as entering and formatting data, performing simple to complex calculations, creating charts, managing large tables, creating pivot tables and using various advanced functionalities.

During the Advanced and Expert lessons, you will go even deeper into the features of Excel and will learn new and advanced functionalities and make better use of them.

This Excel e-learning course is of high quality and prepares you for the Microsoft Office Specialist (MOS) exam. It was developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. The Learning Portal (LMS) offers reports, among other things, and after passing at least 70% of the course, you will receive a certificate of attendance. SCORM is also an option for this course.

Content of the training

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

Advanced

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

Evolving into complicated tables

• Show multiple lines in cell
• An absolute reference in formula
• Copy, transpose calculation results and links
• What you need to know about: Entering functions
• System date and date format
• Simple condition
• Custom format
• Apply a conditional format
• Manage conditional formatting
• Cell Range Name
• Validation criterion
• Cell ranges in functions

Present your figures in graph form

• What you need to know about: Charts
• Create and move a chart
• Manage a chart
• Select chart elements
• Add or remove chart elements
• Formatting chart elements
• Change Chart Text Elements
• Legend and Artboard
• Print a chart and page layout

Improve the layout of your charts

• Change data labels
• Data series and chart axes
• Manage sequences
• Chart Type Options
• Manage chart templates
• Create a 2D map chart
• Create a sparkline chart
• Manage Sparklines

Beautify your tables

• Create a graphic object
• Select and delete objects
• Copy and move objects
• Determine graphic object size
• Change a text box
• Edit a shape
• Formatting drawing objects
• Insert an image
• Manage images
• Rotate and align objects
• Overlap and group objects

Take advantage of your data lists

• Calculating Subtotals
• Create and manage a data table
• Displaying and sorting data from a data table
• Add calculation to a data table
• Automatic filtering
• Custom filters
• Empty and duplicate values
• What you need to know about: Criteria ranges
• Filter by criteria range
• Filter and copy rows with criteria range
• Criteria Range Calculations

Create and use pivot tables and charts

• What you need to know about: PivotTables and Charts
• Create pivot table
• Modify a pivot table and add calculations
• Change the source of a pivot table
• Select, copy, move, and delete a pivot table
• PivotTable Structure and Printing
• Layout of a pivot table
• Filtering a pivot table
• Filtering using slicers
• Basing a PivotTable on Multiple Data Tables
• Add fields or calculated elements
• Group data
• Create a pivot chart

Expert

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

What is Excel?

Microsoft Excel is Microsoft's spreadsheet program and part of Microsoft Office. A spreadsheet is a digital spreadsheet. Microsoft Excel is available in its current form for the Microsoft Windows operating system and for macOS

10 benefits of Excel

1. Organization: Excel is a powerful organization tool that allows you to organize and analyze data in an organized way.
2. Calculations: Excel offers simple to complex calculations, saving you time and maintaining accuracy.
3. Graphs and charts: Excel includes an array of graph and chart functions that you can use to present data visually.
4. Formulas: Excel contains numerous built-in formulas that you can use to perform various calculations.
5. Database functionality: Excel can be used as a database through tables, making it an excellent tool for storing data.
6. Automate: Excel can be programmed to perform tasks automatically, saving you time and energy.
7. Data analysis: Excel includes powerful data analysis features that allow you to quickly understand your data.
8. Accessibility: Excel is widespread and easily accessible, both at work and at home.
9. Advanced features: Excel includes advanced features for working with large amounts of data, such as sorting, filtering, searching and replacing.
10. User-friendly: Excel has an intuitive interface that is easy to use, even for beginners

Why is Excel important?

• Organization of data: Excel is a powerful tool for organizing and structuring data. It provides the ability to display data in tables, graphs and charts, making it easier to understand and analyze information.

• Calculations and formulas: Excel can perform complex calculations and formulas, making it a valuable tool for financial and mathematical analysis.

• Time and task management: Excel provides the ability to keep track of schedules and task lists and can help plan and track projects.

• Business applications: Excel is widely used in business environments for financial analysis, budgeting, billing, inventory management and more.

• Data analysis: Excel offers the ability to analyze and visualize large amounts of data, making it a valuable tool for data mining and business intelligence.

In short, Excel is important because of its versatility and ability to organize, perform calculations and analyze data, making it a valuable tool for a wide range of tasks and applications.

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.