Excel 2016 Basic Course E-Learning 

• 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:15 (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)

Excel course

Order this unique Excel 2016 Basic E-Learning course online and get 1 year of 24/7 access to a virtual Office Cloud environment with rich interactive videos, voice, subtitles and practice assignments. Your answers are analyzed in real-time and progress is tracked through reports. This E-Learning course also prepares for the Microsoft Office Specialist MOS exam thanks to its high quality. It is developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal LMS you will find reports and receive the course, among other things. A SCORM option is also available.

Course content

Basic

• You need to know: About your spreadsheet application
• Opening a workbook
• Overview of the environment
• Moving around a workbook
• You need to know: Text made easy
• Entering data
• You need to know: Selecting, copying, moving
• Selecting and deleting cells
• Undoing and redoing an action
• Column width/row height
• You need to know: Saving files
• Saving a workbook
• Modifying the contents of a cell
• Creating a new workbook
• Entering a calculation formula
• Calculating a sum and other basic functions
• Calculating a percentage
• Reproducing data in adjacent cells
• Simple numerical formats
• Applying a theme
• You need to know: Formatting characters
• Formatting characters
• Character font and size
• Aligning cell content
• Cell colour
• Cell borders
• Page layout
• Print preview and printing
• Page breaks
• Print areas
• You need to know: Headers and footers
• Headers and footers
• Using Microsoft Excel Help
• Checking spelling
• Find and replace
• Zoom
• Inserting/deleting rows, columns and cells
• Moving cells
• Copying to non-adjacent cells
• Copying cell format quickly
• Merging cells
• Orientation of cell content
• Cell styles
• Sorting data
• Sheet name, tab colour
• Inserting and deleting sheets, sheet background
• Moving, copying, hiding sheets
• Splitting the window, freezing a column/row
• Repeating rows/columns on printed pages
• Hiding elements of a sheet
• Summarising data with an outline

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.

Why is Excel imoprtant?

Excel is important because it is a powerful tool for managing data, making calculations and visualizing information. It allows users to organize and analyze large amounts of data in a structured and efficient manner.

This can help make informed decisions and improve business performance.

Excel is also easy to use and adapt to a company's specific needs, making it a valuable tool for professionals in various industries and functions.

Moreover, Excel is widely used in businesses and organizations, making it an essential part of daily work for many people.

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.