Grootste online IT opleider

Beste klantenservice

Veel e-learning in prijs verlaagd

Na betaling, direct starten

Training: Excel 2019 for Windows

€ 129,00
€ 156,09 Incl. BTW

Bestellen namens een bedrijf?

Duur: 23 uur |

Taal: Engels (US) |

Online toegang: 180 dagen |

In Onbeperkt Leren

Gegevens

Nieuw de Excel 2019 voor Windows. Excel 2019 is ook wel de spreadsheet van de Microsoft Office 2019 suite. Ontdek de nieuwe interface en functies, maak kennis met de manier van het ontwikkelen van nieuwe workbooks, het manipuleren van data en de opmaak van gegevens.

Leer meer over het toevoegen en aanpassen van afbeeldingen, hyperlinks en de nieuwe Smart lookup functie, leer gebruik te maken van de basis formules en de makkelijke manier voor het delen van documenten via de e-mail of hoe je deze kunt uploaden binnen OneDrive en Sharepoint.

Resultaat

Na succesvolle afronding ben jij bekend met de nieuwe functionaliteiten van Excel 2019 voor Windows.



Voorkennis

Er is geen specifieke voorkennis vereist.

Doelgroep

Office gebruikers

Inhoud

Excel 2019 for Windows

23 uur

Excel 2019 for Windows: Getting Started

Excel 2019 is the spreadsheet

Excel 2019 for Windows: Creating & Saving Workbooks

In Excel 2019, it

Excel 2019 for Windows: Inserting & Manipulating Data

Excel contains a number of features

Excel 2019 for Windows: Formatting Data

Formatting data makes it easier to

Excel 2019 for Windows: Illustrating Documents

An Excel 2019 worksheet can contain

Excel 2019 for Windows: Using Basic Formulas

The power of Excel 2019 is the

Excel 2019 for Windows: Sharing & Collaborating on a Document

Excel 2019 enables you to easily

Excel 2019: Custom & Conditional Formatting

To customize data, you can use the built-in formats in Excel 2019, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.

Excel 2019: Finding & Grouping Data

Excel 2019 includes a number of

Excel 2019: Sorting & Filtering Data

  • The first step in analyzing the data in a worksheet is often

  • with Excel's sorting and filtering tools. These tools help you to
  • control what is displayed in your data range, and how the values
  • are organized. See how to perform basic and more advanced sort
  • operations, filter data using the Filter and column header tools,
  • and manage color-tagged and duplicate entries.

Excel 2019: Referencing Data

Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, and formula auditing in Excel 2019.

Excel 2019: Forecasting & Solving Problems

Go further with you Excel document through understanding potential formula errors, use intelligent data types, set goals to reach targets as well as problem solve with the solver and Forecast tools offered by Excel 2019.

Excel 2019: Creating Charts & Graphics

Analyze and present your data in a visually attractive manner in Excel 2019. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.

Excel 2019: Working with Different Chart Styles

Excel offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts.

Excel 2019: Working with Excel Tables

Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data as well as change its appearance and formatting.

Excel 2019: Inserting PivotTables

Excel includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables, sort, filter, and group data, and work with slicers and timelines.

Excel 2019: Working with Data in PivotTables

Once your Excel PivotTables have been created you'll need to know how to manage and work with the data contained within. See how to analyze, calculate, collaborate and more with Excel PivotTables.

Excel 2019: Using Conditional Formulas

Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.

Excel 2019: Finding & Analyzing Information with Formulas

There is a wide variety of tools that can be used to retrieve, return, and calculate data in Excel. See how to retrieve date information and rank values, retrieve, combine and separate data that is already available, and automate and simplify calculations using look-up tools and SUMPRODUCT.

Excel 2019: Configuring Options & Settings

Get more out of Excel by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar.

Excel 2019: Managing Data

Excel offers a set of tools that allows you explore more in detail data analysis and complex formulae. If you need to work with data from other sources, you can import and edit data from a text and a .csv file.

In this course you'll see how to use different formulae to make calculations when you have multiple conditions imposed. You'll also be able to forecast data using the NPER function.

With complex formulae you can run calculations to discover the average numbers or the smallest or largest values depending on a settle of conditions, for example.

Excel 2019 for Windows: Getting to Know Macros in Excel

  • If you have tasks in Excel 2019 that you do repeatedly, you can

  • record a macro to automate those tasks. When you create a macro,
  • you are recording your mouse clicks and keystrokes. After you
  • create a macro, you can edit it to make minor changes to the way it
  • works. Key concepts covered in this 10-video course include how to
  • record macros and perform actions that can be implemented in Excel
  • workbooks, how to save a workbook with macros and an Excel
  • macro-enabled workbook, how to find and use macro tools that are
  • available in multiple locations, and how to add macro recording to
  • your status bar for easy access. Then learn how to navigate the VBA
  • Editor interface, an application easily accessible via Excel, to
  • manage your macros and workbook VBA code; how to manage macros,
  • edit macros, and enable macros in a workbook; and how to access
  • macro security settings and manage macro security options. Finally,
  • you will observe how to use macros across multiple workbooks.

Excel 2019 for Windows: Creating & Editing Macros

In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document.

In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.

Excel 2019 for Windows: Working with Macros in Excel

If you are using your Excel worksheet to input data, you can create form to fill out you worksheets more easily. With the VBA editor you can insert, edit and customize your forms to make inputting data easier for your users.

Excel 2019 also gives you the possibility to use macros within formulas. You can use macros in formulas to format text, perform calculations and even export charts to easily share or present to others.

Opties bij cursus

Wij bieden, naast de training, in sommige gevallen ook diverse extra leermiddelen aan. Wanneer u zich gaat voorbereiden op een officieel examen dan raden wij aan om ook de extra leermiddelen te gebruiken die beschikbaar zijn bij deze training. Het kan voorkomen dat bij sommige cursussen alleen een examentraining en/of LiveLab beschikbaar is.

Examentraining (proefexamens)

In aanvulling op deze training kunt u een speciale examentraining aanschaffen. De examentraining bevat verschillende proefexamens die het echte examen dicht benaderen. Zowel qua vorm als qua inhoud. Dit is de ultieme manier om te testen of u klaar bent voor het examen. 

LiveLab

Als extra mogelijkheid bij deze training kunt u een LiveLab toevoegen. U voert de opdrachten uit op de echte hardware en/of software die van toepassing zijn op uw Lab. De LiveLabs worden volledig door ons gehost in de cloud. U heeft zelf dus alleen een browser nodig om gebruik te maken van de LiveLabs. In de LiveLab omgeving vindt u de opdrachten waarmee u direct kunt starten. De labomgevingen bestaan uit complete netwerken met bijvoorbeeld clients, servers, routers etc. Dit is de ultieme manier om uitgebreide praktijkervaring op te doen.

Waarom Icttrainingen.nl?

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Bestelproces

Zodra wij uw order en betaling hebben verwerkt, zetten wij uw trainingen klaar en kunt u aan de slag. Heeft u toch nog vragen over ons orderproces kunt u onderstaande button raadplegen.

lees meer over het orderproces

hoe werkt aanvragen met STAP

Wat is inbegrepen?

Certificaat van deelname ja
Voortgangsbewaking ja
Award Winning E-learning ja
Geschikt voor mobiel ja
Kennis delen Onbeperkte toegang tot onze community met IT professionals
Studieadvies Onze consultants zijn beschikbaar om je te voorzien van studieadvies
Studiemateriaal Gecertificeerde docenten met uitgebreide kennis over de onderwerpen
Service Service via chat, telefoon, e-mail (razendsnel)

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Meerdere cursussen volgen? Misschien is ons Life Long Learning concept wel wat voor u

lees meer

Neem contact op

Studieadvies nodig? Neem contact op!


Contact