De Meest Voordelige Opleider van Nederland
Award winning E-Learning & Gecertificeerde Trainers
Upgrade uw cv met een certificaat van deelname van OEM
SpringestMicrosoft PartnerEC-CouncilOfferte Aanvragen
0

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Microsoft Excel Excel 2019 Basic E-Learning

Product description
E-Learning Course Excel 2019 Basic Online Take these unique E-Learning course from Microsoft Excel 2019 on a basic online, 1 year 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, speech, subtitling, practical assignments with real -time analysis of your answers, progress monitoring through reports to prepare you fo...

E-Learning Course Excel 2019 Basic Online

Take these unique E-Learning course from Microsoft Excel 2019 on a basic online, 1 year 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, speech, subtitling, practical assignments with real -time analysis of your answers, progress monitoring through reports to prepare you for the Microsoft Office Specialist (MOS) exam thanks to high quality. Door developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) including reports and after> 70% of the course a certificate of participation.

Target

Get to know the Excel spreadsheet program and master the basic to advanced functionalities. After following this training, full use can be made of Excel. All necessary themes are covered such as: entering and formatting data, simple to complex calculations, graphs, managing large tables, pivot tables and advanced functionalities.

Target audience

Anyone who wants to (re) learn to use the basic operations in Excel and to master the advanced functionalities.

Required level

No knowledge of Excel is required. With minimal use of the program, progress will be made faster.

Expected duration for the indispensable modules

14 hours 50 min.
(Video clips averaging 2 to 5 minutes)

Content of the training

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

Excel 2019 – Versions 2019 and Office 365 Online Book
In this module you can consult an online book.

Excel 2019 – Level 1: Essential basic knowledge
This module offers you an interactive training, consisting of 45 teaching videos, 45 assignments and 5 files with additional information.

Product specifications

Online access
365 days
Lesson duration
9:30 hours

Reviews

0 / 5Based on 0 reviews

There are no reviews written yet about this product..

Create your own review

Eerder bekeken door jou

Microsoft Excel Excel 2019 Basic E-Learning
Microsoft ExcelExcel 2019 Basic E-Learning

Take an Excel 2019 Basic course now online. You will learn how to enter formulas, copy calculation results and links, transpose and adjust notation.

€80,00 Excl. tax
Please accept cookies to help us improve this website Is this OK? YesNoMore on cookies »