Excel 2019 Basic Course E-Learning + Online Book
Excel 2019 Basic Course E-Learning + Online Book
Take an Excel 2019 Basic course now online. You will learn how to enter formulas, copy calculation results and links, transpose and adjust notation.
Read more- Brand:
- Microsoft Excel
- Discounts:
-
- Buy 5 for €75,00 each and save 6%
- Buy 11 for €70,00 each and save 13%
- Buy 31 for €65,00 each and save 19%
- Buy 61 for €60,00 each and save 25%
- Buy 101 for €50,00 each and save 38%
- Buy 251 for €40,00 each and save 50%
- Availability:
- In stock
- Delivery time:
- Ordered before 5 p.m.! Start today.
- Award Winning E-learning
- Lowest price guarantee
- Personalized service by our expert team
- Pay safely online or by invoice
- Order and start within 24 hours
Excel 2019 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)
Excel course
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 2019 course in a virtual Office 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.
Excel 2019 - Versions 2019 and Office 365 Online Book
This module includes an online book for additional support.
Excel 2019 course content
Basic
This module offers you an interactive training, consisting of 45 lesson 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
- Moving 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
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 to 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
- Creating the pivot tables
- Conclusion
Keep track of budget Budget
- Presentation of the use case
- Creating 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
Follow Up Course:
Excel 2019 Advanced Expert E-Learning Course
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
- Data management: Excel allows users to manage large amounts of data in an organized and efficient manner.
- Calculations: Excel includes a wide range of formulas and functions that allow users to perform complex calculations.
- Charts and visualizations: Excel allows users to visualize data and create charts to identify trends and patterns in the data.
- Automation: Excel uses macros and VBA (Visual Basic for Applications) to automate processes and tasks.
- Easy to use: Excel has a user-friendly interface and is easy to learn, even for beginners.
- Efficiency: Excel allows users to organize and analyze data quickly and easily, saving time and costs.
- Collaboration: Excel can be used to share data and collaborate with colleagues and teams.
- Flexibility: Excel can be customized and tailored to meet the specific needs of users and their businesses.
- Availability: Excel is widespread and available on most computers, meaning it is easily accessible to users.
- 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.
Online access | 365 days |
---|---|
Lesson duration | 4.10 hours |
-
"ben blij eindelijk goed om te kunnen gaan met excel, bedankt!"
Lisette on 07 Jun 2022
OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'
OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.
Reviews
-
"ben blij eindelijk goed om te kunnen gaan met excel, bedankt!"
Lisette on 07 Jun 2022