Excel 2019 Beginner E-learning Kurs
Bestellen Sie diesen großartigen Elearning-Kurs Excel 2019 Beginner online, 1 Jahr rund um die Uhr Zugriff auf umfangreiche interaktive Videos, Reden, praktische Aufgaben, Fortschrittsüberwachung durch Berichte und Tests pro Proband, um das Wissen direkt zu testen. Dieses E-Learning ist von sehr hoher Qualität. Entwickelt von zertifizierten Lehrern. Im Learning Portal (LMS) Fortschrittsberichte und nach> 70% des Kurses eine Teilnahmebescheinigung.
Kursinhalt
Overview
Excel 2019 is the spreadsheet application in the Microsoft Office 2019 suite. Explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes.
Objectives
- Finding & opening the application
- Exploring the application
- Using the zoom function
- Using the view modes
- Moving between documents
Excel 2019 for Windows: Creating & Saving Workbooks
Overview
In Excel 2019, it's easy to create and save new workbooks. Learn how to create, manage, and save documents, insert headers and footers, edit document properties, and protect your Excel workbooks from unwanted edits and use.
Objectives
- Creating & opening a document
- Using document templates
- Managing your worksheets
- Saving your document
- Saving your document as a PDF
- Recovering unsaved documents
- Inserting headers & footers
- Setting your print area
- Adjusting your print page layout
- Printing your document
- Checking for compatibility issues
- Editing your document properties
- Checking for personal information in your document
- Creating an accessible document
- Protecting your document
Excel 2019 for Windows: Inserting & Manipulating Data
Overview
Excel contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.
Objectives
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the Flash Fill feature
- Inserting dropdown menus
- Using the spell check tool
- Configuring spell check & AutoCorrect options
- Transferring data
- Copying & pasting data
- Moving data from one worksheet to another
- Using the Paste Special tools
- Transposing a data range
- Consolidating your data
Excel 2019 for Windows: Formatting Data
Overview
Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation.
Objectives
- Setting your data type
- Formatting your data
- Aligning your data
- Using colors
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Formatting a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows
- Inserting borders
- Transferring format styles
Excel 2019 for Windows: Illustrating Documents
Overview
An Excel 2019 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes, insert hyperlinks, and use the new Smart Lookup feature.
Objectives
- Inserting an image
- Inserting a screenshot
- Editing an image
- Inserting shapes
- Inserting icons
- Inserting a hyperlink
- Using Smart Lookup
Excel 2019 for Windows: Using Basic Formulas
Overview
The power of Excel 2019 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.
Objectives
- Inserting a formula using the function library
- Performing simple calculations
- Using automated formulas in a table
- Creating automated cumulative totals
- Inserting subtotals
- Counting cells in a range
- Ranking a value
- Rounding a number
- Using replacement formulas
- Converting number types
- Factorizing the results of a division
- Creating random values
Excel 2019 for Windows: Sharing & Collaborating on a Document
Overview
Excel 2019 enables you to easily share your documents via email or upload them to OneDrive and SharePoint to collaborate with your team. Stay in the loop with document comments, and the version history and track changes tools.
Objectives
- Sending your document via email
- Sharing your workbook via a link
- Managing link access & permissions
- Saving your documents to OneDrive
- Managing a workbook's version history
- Commenting on a document
- Following & tracking document changes
Lassen Sie uns helfen!
| Studiengebühr: | 5 Stunden Dauer plus Übungen (variabel) |
| Sprache: | Englisch |
| Online-Zugang: | 1 Jahr |
| Teilnahmebescheinigung: | Ja, nach 70% der erfolgreichen Einsätze |
| Fortschrittsüberwachung: | Ja |
| Geeignet für Handys: | Ja |
| Preisgekröntes E-Learning: | Ja |
Lesen oder schreiben Sie einen Kommentar
