Artikelnummer: 125743894

TOSA Excel Cursus E-Learning

Artikelnummer: 125743894

TOSA Excel Cursus E-Learning

129,00 156,09 Incl. btw

Bestel deze unieke E-Learning cursus TOSA Excel online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, voortgangs door rapportage en testen.

Lees meer

Merk:: Microsoft Excel

Kortingen:

Koop 2 voor €126,42 per stuk en bespaar 2%
Koop 3 voor €125,13 per stuk en bespaar 3%
Koop 4 voor €123,84 per stuk en bespaar 4%
Koop 5 voor €122,55 per stuk en bespaar 5%
Koop 10 voor €116,10 per stuk en bespaar 10%
Koop 25 voor €109,65 per stuk en bespaar 15%
Koop 50 voor €103,20 per stuk en bespaar 20%

Beschikbaarheid:: Op voorraad

Levertijd:: Voor 17:00 uur besteld! Start vandaag. Gratis Verzending.

Startdatum:

Naam Cursist (Meerdere cursisten, wij nemen contact met u op):

E-mailadres cursist:

Certificaat van deelname::

Award Winning E-learning
De laagste prijs garantie
Persoonlijke service van ons deskundige team
Betaal veilig online of op factuur
Bestel en start binnen 24 uur

TOSA Excel Cursus E-Learning

Bestel deze unieke E-Learning cursus TOSA Excel 2016 online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, voortgangsbewaking door rapportages en testen per hoofdstuk om de kennis direct te toetsen.

Verwerf de vaardigheden die nodig zijn om Microsoft Excel in een werkomgeving te gebruiken terwijl u zich voorbereidt op de TOSA Excel 2016 en TOSA Excel 365 certificerings examens.

Cursusinhoud

Excel 2016: Getting Started

Course: 20 Minutes

Inserting a chart in Excel 2016 for Windows
Labeling a chart in Excel 2016 for Windows
Formatting a chart in Excel 2016 for Windows
Customizing your charts in Excel 2016 for Windows
Customizing your chart axes in Excel 2016 for Windows
Creating a chart template in Excel 2016 for Windows
Presenting negative values in your chart in Excel 2016 for Windows
Creating a pie chart in Excel 2016 for Windows
Creating a scatter chart in Excel 2016 for Windows
Creating a bubble chart in Excel 2016 for Windows
Creating a radar chart in Excel 2016 for Windows
Combining two types of chart in Excel 2016 for Windows
Creating a comparative chart using symbols in Excel 2016 for Windows
Inserting trendlines in Excel 2016 for Windows
Customizing your trendlines in Excel 2016 for Windows

Excel 2016: Creating, Saving & Sharing Workbooks

Course: 1 Hour, 13 Minutes

Creating & opening a document with Excel 2016 (Windows)
Using document templates in Excel 2016 for Windows
Managing your worksheets in Excel 2016 for Windows
Saving a document in Excel 2016 (Windows)
Saving your document as a PDF in Excel 2016 for Windows
Returning to a previous version of your document in Excel 2016 for Windows
Inserting headers & footers in Excel 2016 for Windows
Setting your print area in Excel 2016 for Windows
Adjusting your print page layout in Excel 2016 for Windows
Printing your document in Excel 2016 for Windows
Checking for compatibility issues in Excel 2016 for Windows
Editing your document properties in Excel 2016 for Windows
Checking for personal information in your document in Excel 2016 for Windows
Creating an accessible document in Excel 2016 for Windows
Protecting your document in Excel 2016 for Windows
Sending your document via email in Excel 2016 for Windows
Sharing your document via OneDrive in Excel 2016 for Windows
Commenting on a document in Excel 2016 for Windows
Following & tracking document changes in Excel 2016 for Windows

Excel 2016: Inserting & Manipulating Data

Course: 1 Hour, 4 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
Transposing a data range
Consolidating your data

Excel 2016: Formatting Data

Course: 52 Minutes

Setting your data type in Excel 2016 for Windows
Formatting your data in Excel 2016 for Windows
Aligning your data in Excel 2016 for Windows
Using colors in Excel 2016 for Windows
Changing your cell style in Excel 2016 for Windows
Using document themes in Excel 2016 for Windows
Using formulas to modify your text case in Excel 2016 for Windows
Creating a title in Excel 2016 for Windows
Formatting a title in Excel 2016 for Windows
Creating a table in Excel 2016 for Windows
Resizing columns & rows in Excel 2016 for Windows
Inserting columns & rows in Excel 2016 for Windows
Inserting borders in Excel 2016 for Windows
Transferring format styles in Excel 2016 for Windows

Excel 2016: Illustrating Documents

Course: 28 Minutes

Inserting an image in Excel 2016 for Windows
Inserting a screenshot in Excel 2016 for Windows
Editing an image in Excel 2016 for Windows
Inserting shapes in Excel 2016 for Windows
Inserting a hyperlink in Excel 2016 for Windows
Using Smart Lookup in Excel 2016 for Windows

Excel 2016: Basic Formulas

Course: 49 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 2016: Custom & Conditional Formatting

Course: 32 Minutes

Customizing your number formats in Excel 2016 for Windows
Customizing your text formats in Excel 2016 for Window
Customizing your date & time formats in Excel 2016 for Windows
Creating conditional custom formats in Excel 2016 for Windows
Using the conditional formatting tools in Excel 2016 for Windows
Using advanced conditional formatting in Excel 2016 for Windows
Applying color to the first new entry in a list in Excel 2016 for Windows

Excel 2016: Finding, Sorting & Filtering Data

Course: 46 Minutes

Using the Find tool in Excel 2016 for Windows
Using the Replace tool in Excel 2016 for Windows
Using the Find & Replace tools in a formula in Excel 2016 for Windows
Sorting your data in Excel 2016 for Windows
Filtering your data in Excel 2016 for Windows
Sorting & filtering using colors in Excel 2016 for Windows
Using slicers in tables in Excel 2016 for Windows
Using the advanced filter options in Excel 2016 for Windows
Hiding duplicate values in Excel 2016 for Windows
Freezing & unfreezing panes in Excel 2016 for Windows
Grouping items & creating an outline in Excel 2016 for Windows

Excel 2016: Referencing Data

Course: 47 Minutes

Referencing your cells in Excel 2016 for Windows
Using data across multiple worksheets in Excel 2016 for Windows
Choosing between absolute & relative cell references in Excel 2016 for Windows
Naming your data ranges in Excel 2016 for Windows
Performing calculations using constant values in Excel 2016 for Windows
Using cell references indirectly in Excel 2016 for Windows
Keeping an eye on your data in Excel 2016 for Windows
Activating automatic updates in Excel 2016 for Windows
Using formula auditing in Excel 2016 for Windows
Understanding formula errors in Excel 2016 for Windows

Excel 2016: Working with Formulas

Course: 40 Minutes

Calculating the interest on a loan in Excel 2016 for Windows
Simulating a loan in Excel 2016 for Windows
Reaching a target value in Excel 2016 for Windows
Solving a problem in Excel 2016 for Windows
Using the forecast tool in Excel 2016 for Windows
Creating automatic reports in Excel 2016 for Windows
Finding identical values in your spreadsheet in Excel 2016 for Windows
Finding duplicates in your document in Excel 2016 for Windows
Visualizing your duplicate values in Excel 2016 for Windows
Preventing duplicate values in Excel 2016 for Windows

Excel 2016: Creating Charts & Graphics

Course: 1 Hour, 7 Minutes

Inserting a chart in Excel 2016 for Windows
Labeling a chart in Excel 2016 for Windows
Formatting a chart in Excel 2016 for Windows
Customizing your charts in Excel 2016 for Windows
Customizing your chart axes in Excel 2016 for Windows
Creating a chart template in Excel 2016 for Windows
Presenting negative values in your chart in Excel 2016 for Windows
Creating a pie chart in Excel 2016 for Windows
Creating a scatter chart in Excel 2016 for Windows
Creating a bubble chart in Excel 2016 for Windows
Creating a radar chart in Excel 2016 for Windows
Combining two types of chart in Excel 2016 for Windows
Creating a comparative chart using symbols in Excel 2016 for Windows
Inserting trendlines in Excel 2016 for Windows
Customizing your trendlines in Excel 2016 for Windows

Excel 2016: Creating PivotTables & PivotCharts

Course: 1 Hour, 6 Minutes

Creating a PivotTable in Excel 2016 for Windows
Creating a PivotTable with multiple data tables in Excel 2016 for Windows
Editing your PivotTable in Excel 2016 for Windows
Formatting your PivotTable in Excel 2016 for Windows
Copying & reusing your PivotTable in Excel 2016 for Windows
Inserting a calculation in your PivotTable in Excel 2016 for Windows
Sorting data in your PivotTable in Excel 2016 for Windows
Filtering your table data in Excel 2016 for Windows
Grouping data in your PivotTable in Excel 2016 for Windows
Inserting a slicer in your PivotTable in Excel 2016 for Windows
Customizing your slicer in Excel 2016 for Windows
Comparing values in a PivotTable in Excel 2016 for Windows
Inserting a PivotChart in Excel 2016 for Windows
Modifying your PivotChart in Excel 2016 for Windows
Analyzing your database tables in a PivotChart in Excel 2016 for Windows

Excel 2016: Using Conditional Formulas

Course: 41 Minutes

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

Excel 2016: Extracting Information with Formulas

Course: 50 Minutes

Retrieving information with dates in Excel 2016 for Windows
Finding a date automatically in Excel 2016 for Windows
Finding the largest & smallest values in a list in Excel 2016 for Windows
Separating data into multiple cells in Excel 2016 for Windows
Combining data values in a single cell in Excel 2016 for Windows
Retrieving information on a cell in Excel 2016 for Windows
Retrieving information on your text in Excel 2016 for Windows
Cross referencing two data lists in Excel 2016 for Windows
Inserting data automatically in Excel 2016 for Windows
Finding a value in a double entry table in Excel 2016 for Windows
Performing a search across two tables in Excel 2016 for Windows
Finding data in a database in Excel 2016 for Windows
Performing calculations using your database in Excel 2016 for Windows

Excel 2016: Configuring Options & Settings

Course: 29 Minutes

Managing your account & connected services in Excel 2016 for Windows
Installing & managing add-ins in Excel 2016 for Windows
Configuring your input options in Excel 2016 for Windows
Configuring your default formula options in Excel 2016 for Windows
Customizing your document default settings in Excel 2016 for Windows
Customizing your interface in Excel 2016 for Windows
Customizing the Quick Access toolbar in Excel 2016 for Windows
Customizing the ribbon in Excel 2016 for Windows

Excel 2016: Using the Power View Add-in

Course: 1 Hour, 6 Minutes

Activating Power View in Excel 2016 for Windows
Creating a new report in Excel 2016 for Windows
Managing your report tables in Excel 2016 for Windows
Grouping data with tiles in Excel 2016 for Windows
Creating relationships between tables in Excel 2016 for Windows
Illustrating your Power View report in Excel 2016 for Windows
Formatting your Power View report in Excel 2016 for Windows
Organizing your Power View report in Excel 2016 for Windows
Filtering the data in your report in Excel 2016 for Windows
Using the advanced filter options in your Power View report in Excel 2016 for Windows
Reusing a table in Excel 2016 for Windows
Using a Matrix Table to visualize your data in Excel 2016 for Windows
Using bar & column charts to visualize your data in Excel 2016 for Windows
Using line charts to visualize your data in Excel 2016 for Windows
Using scatter charts to visualize your data in Excel 2016 for Windows
Using pie charts to visualize your data in Excel 2016 for Windows
Visualizing your data in map form in Excel 2016 for Windows

Excel 2016: Using the Power Pivot Add-in

Course: 58 Minutes

Activating Power Pivot in Excel 2016 for Windows
Using the view settings in Power Pivot in Excel 2016 for Windows
Importing your database in Excel 2016 for Windows
Creating Power Pivot relationships in Excel 2016 for Windows
Customizing your Power Pivot tables in Excel 2016 for Windows
Applying data formats in Power Pivot tables in Excel 2016 for Windows
Sorting the data in your Power Pivot table in Excel 2016 for Windows
Filtering data in your Power Pivot table in Excel 2016 for Windows
Creating a calculated field in your Power Pivot table in Excel 2016 for Windows
Creating custom views in your Power Pivot table in Excel 2016 for Windows
Updating your Power Pivot tables in Excel 2016 for Windows
Creating an advanced PivotTable in Excel 2016 for Windows
Creating an advanced PivotChart in Excel 2016 for Windows
Creating a dashboard in Excel 2016 for Windows

Excel 2016: Basic Formulas

Course: 48 Minutes

Inserting a formula using the function library in Excel 2016 for Windows
Performing simple calculations in Excel 2016 for Windows
Using automated formulas in a table in Excel 2016 for Windows
Creating automated cumulative totals in Excel 2016 for Windows
Inserting subtotals in Excel 2016 for Windows
Counting cells in a range in Excel 2016 for Windows
Ranking a value in Excel 2016 for Windows
Rounding a number in Excel 2016 for Windows
Using replacement formulas in Excel 2016 for Windows
Converting number types in Excel 2016 for Windows
Factorizing the results of a division in Excel 2016 for Windows
Creating random values in Excel 2016 for Windows

Taal	Engels
Kwalificaties van de Instructeur	Gecertificeerd
Cursusformaat en Lengte	Lesvideo's met ondertiteling, interactieve elementen en opdrachten en testen
Lesduur	14:20 uur
Voortgangsbewaking	Ja
Toegang tot Materiaal	365 dagen
Technische Vereisten	Computer of mobiel apparaat, Stabiele internetverbindingen Webbrowserzoals Chrome, Firefox, Safari of Edge.
Support of Ondersteuning	Helpdesk en online kennisbank 24/7
Certificering	Certificaat van deelname in PDF formaat
Prijs en Kosten	Cursusprijs zonder extra kosten
Annuleringsbeleid en Geld-Terug-Garantie	Wij beoordelen dit per situatie
Award Winning E-learning	Ja
Tip!	Zorg voor een rustige leeromgeving, tijd en motivatie, audioapparatuur zoals een koptelefoon of luidsprekers voor audio, accountinformatie zoals inloggegevens voor toegang tot het e-learning platform.

Er zijn nog geen reviews geschreven over dit product.

OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'

OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.