Excel - Excel 365 Basic - Excel voor Financials, Draaitabellen in Excel, Excel Draaitabellen, Excel basis / voor beginners, Data Analyse Excel, Draaitabellen

Excel 365 Basic

Excel 365 course E-Learning version 2019 in a virtual Office 365 cloud environment with practical assignments and rich interactive videos with speech and subtitles with real-time analysis of your answers, progress monitoring through reports. This e-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Door developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. Reports in the Learning Portal (LMS) and a certificate of participation after >70% of the course. SCORM capability.

Goal
Get to know the Excel spreadsheet program and master the basic to advanced functionalities. After following this training, you can make full use 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 how to use the basic operations in Excel and who wants 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
4 hours 10 minutes
(Video clips averaging 2 to 5 minutes)

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

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