Microsoft Excel Excel 2019 Basis Gevorderd Expert E-Learning Kurs
Excel 2019 Basis Gevorderd Expert E-Learning Kurs
€176,28
Microsoft Excel

Excel 2019 Basis Gevorderd Expert E-Learning Kurs

EUR 176,28 exkl. MwSt.

Das beste E-Learning-Training Excel 2019 Basic Advanced Expert-Kurs mit praktischen Übungen, Fortschrittsbericht, Tests und Teilnahmebescheinigung. Heute anfangen.

  • E-Learning - Online-Zugang: 365 Tage
  • Englische Sprache
  • Teilnahmeurkunde
Auf Lager
Menge
- +
Produktbeschreibung

Excel 2019 Basis Gevorderd Expert E-Learning Kurs

Bestellen Sie diesen großartigen, preisgekrönten E-Learning-Kurs für Excel 2019 Basic Advanced Expert online, 1 Jahr rund um die Uhr Zugriff auf umfangreiche interaktive Videos, Reden, praktische Aufgaben und Fortschrittsüberwachung. Nach dem Kurs erhalten Sie eine Teilnahmebescheinigung.

Kursinhalt

Excel 2019 for Windows: Getting Started

Course: 22 Minutes

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

Course: 1 Hour, 4 Minutes

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

Course: 1 Hour, 3 Minutes

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

Course: 49 Minutes

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

Course: 31 Minutes

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

Course: 52 Minutes

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

Course: 26 Minutes

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

Excel 2019: Custom & Conditional Formatting

Course: 47 Minutes

Customizing your number formats
Customizing your text formats
Customizing your date & time formats
Using color in custom formats
Creating conditional custom formats
Creating conditional formatting rules
Calling out data with conditional formatting tools
Analyzing data ranges with conditional formatting tools
Using advanced conditional formatting
Controlling conditional formatting rules

Excel 2019: Finding & Grouping Data

Course: 35 Minutes

Finding items in a worksheet
Using the advanced Find tools
Using the Selection tools
Using the Replace tool
Using the Find & Replace tools with formulas
Freezing & unfreezing panes
Grouping items
Creating outlines

Excel 2019: Sorting & Filtering Data

Course: 38 Minutes

Sorting your data
Using the advanced sorting tools
Applying multiple sort levels
Using custom sort lists
Filtering your data
Applying multiple filters
Building filter arguments
Sorting & filtering using colors
Using the advanced filter options
Hiding duplicate values

Excel 2019: Referencing Data

Course: 44 Minutes

Referencing your cells
Using data across multiple worksheets
Choosing between absolute & relative cell references
Naming your data ranges
Managing named ranges
Performing calculations using contant values
Using cell references indirectly
Keeping an eye on your data
Activating automatic updates
Using formula auditing

Excel 2019: Forecasting & Solving Problems

Course: 33 Minutes

Understanding formula errors
Reviewing & debugging formula errors
Calculating the interest on a loan
Reaching a target value
Solving a problem
Using the forecast tool
Using data tables

Excel 2019: Creating Charts & Graphics

Course: 35 Minutes

Inserting a chart
Labeling a chart
Formatting a chart
Customizing your charts
Customizing your chart axes
Creating a chart template
Presenting negative values in your chart
Inserting trendlines
Customizing your trendlines

Excel 2019: Working with Different Chart Styles

Course: 24 Minutes

Creating a pie chart
Creating a scatter chart
Creating a bubble chart
Creating a radar chart
Combining two types of chart
Creating a Map chart

Excel 2019: Working with Excel Tables

Course: 19 Minutes

Creating a table
Manipulating data in a table
Using table styles
Configuring a table
Using slicers in tables
Formatting slicers

Excel 2019: Inserting PivotTables

Course: 32 Minutes

Creating a PivotTable
Editing your PivotTable
Formatting your PivotTable
Copying & reusing your PivotTable
Sorting data in your PivotTable
Filtering your table data
Using label & value filters
Grouping data in your PivotTable
Inserting a slicer in your PivotTable
Customizing your slicer
Using the Timeline

Excel 2019: Working with Data in PivotTables

Course: 29 Minutes

Analyzing data in a PivotTable
Working with multiple data tables in a PivotTable
Analyzing your database tables in a PivotTable
Using calculations in your PivotTable
Comparing values in a PivotTable
Inserting a PivotChart
Modifying your PivotChart
Configuring your PivotTable

Excel 2019: Using Conditional Formulas

Course: 39 Minutes

Inserting a conditional sum formula
Inserting a conditional message formula
Performing complex conditional formulas
Creating multiple conditions
Using IF & OR in conditional formulas
Using conditional formulas to count up value occurrences
Using reference positions in conditional formulas
Keeping your table up to date with conditional formulas

Excel 2019: Finding & Analyzing Information with Formulas

Course: 35 Minutes

Retrieving information with dates
Finding a date automatically
Finding the largest & smallest values in a list
Separating data into multiple cells
Combining data values in a single cell
Creating automatic reports
Cross-referencing data with formulas
Performing a search across two tables
Inserting data automatically with formulas

Excel 2019: Configuring Options & Settings

Course: 32 Minutes

Retrieving information with dates  
Finding a date automatically  
Finding the largest & smallest values in a list  
Separating data into multiple cells  
Combining data values in a single cell  
Creating automatic reports  
Cross-referencing data with formulas  
Performing a search across two tables  
Inserting data automatically with formulas

Excel 2019: Managing Data

Course: 43 Minutes

Managing your account & connected services
Installing & managing add-ins
Creating & managing custom templates
Configuring user & input behavior
Configuring your default formula options
Customizing your document default settings
Customizing your save options
Customizing your interface
Customizing the Quick Access Toolbar
Customizing the ribbon

Excel 2019: Getting to Know Macros in Excel

Course: 34 Minutes

Recording a macro
Saving a workbook with macros
Discovering Excel macro tools
Navigating the VBA Editor
Running macros
Managing macros
Editing a macro
Enabling macros in a workbook
Managing macros security options
Using macros in different workbooks

Eigenschaften
Unterrichtsdauer 12 Stunde
Sprache Englisch
Online-Zugang 365 Tage
Teilnahmeurkunde Ja
Preisgekröntes Online-Training Ja
Was unsere Kunden sagen

Durchschnitt von 0 Bewertungen

Kein Bewertungen
Lesen oder schreiben Sie einen Kommentar
* Wir werden Ihre E-Mail-Adresse niemals an Dritte weitergeben.
Fragen?
Wir helfen Ihnen gerne weiter. Bieten Sie unseren Kundenservice an
Mein Konto
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Ihr Warenkorb
Ihr Warenkorb ist leer
Menu
Suchen
Search suggestions
Keine Produkte gefunden...
Wir benutzen Cookies nur für interne Zwecke um den Webshop zu verbessern. Ist das in Ordnung? Ja Nein Für weitere Informationen beachten Sie bitte unsere Datenschutzerklärung. »