Excel 2019 Intermediate (English)

Type product
Niveau
Logo van OEM Office Elearning Menu NL
Opleiderscore: starstarstarstarstar_half 8,7 OEM Office Elearning Menu NL heeft een gemiddelde beoordeling van 8,7 (uit 111 ervaringen)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

10
Gemiddeld cijfer voor Excel 2019 Intermediate (English)
Gebaseerd op 1 ervaring Lees alle ervaringenchevron_right
starstarstarstarstar
William H
10
Excel 2019 Intermediate (English)

"Very good! Good explanation, clear language. It was very nice to do this e-learning, so for others who want to do an e-learning it is highly recommended!

I'll give it a 10." - 01-03-2021 12:24

"Very good! Good explanation, clear language. It was very nice to do this e-learning, so for others who want to do an e-learning it is highly… alles lezen - 01-03-2021 12:24

Beschrijving

Bestel deze geweldige Elearning cursus Excel 2019 gevorderd online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Deze e-Learning bereid u ook voor op het Microsoft Office Specialist (MOS) examen dankzij de hoge kwaliteit. Door ontwikkelt door MOS docenten met méér dan 27 jaar ervaring en de uitgever is een Microsoft Gold Partner. In het Leerportaal (LMS) o.a. rapportages en na >70% van de cursus een certificaat van deelname.

Excel 2019: Custom & Conditional Formatting

Course:  47 Minutes Expertise Level:  Intermediate

Objectives

  • format currency, percentage and…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Excel, Draaitabellen, Microsoft Office, Excel voor Financials en Excel VBA.

Bestel deze geweldige Elearning cursus Excel 2019 gevorderd online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Deze e-Learning bereid u ook voor op het Microsoft Office Specialist (MOS) examen dankzij de hoge kwaliteit. Door ontwikkelt door MOS docenten met méér dan 27 jaar ervaring en de uitgever is een Microsoft Gold Partner. In het Leerportaal (LMS) o.a. rapportages en na >70% van de cursus een certificaat van deelname.

Excel 2019: Custom & Conditional Formatting

Course:  47 Minutes Expertise Level:  Intermediate

Objectives

  • format currency, percentage and phone numbers with data values
  • change your text format by adding or modifying a text elements appearance
  • custom format dates or times with worksheet data
  • create custom color formatting for data entries
  • apply conditional custom formatting to data values
  • create conditional format rules to enhance your data values display
  • use conditional formatting to highlight data in cells, rows and columns
  • use conditional formatting tools to analyze your data further
  • use advanced conditional formatting tools to find duplicate values or hide values
  • organize conditional formatting rules applied to a worksheet

Excel 2019: Finding & Grouping Data

Course:  35 Minutes Expertise Level:  Intermediate

Overview

Excel 2019 includes a number of methods for locating, displaying and manipulating data entries. Learn how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools.

Objectives

  • use the Find tools to jump to locations in a worksheet and find items with basic search queries
  • use the advanced Find tools to customize and refine search queries
  • use the Selection tools to locate and select graphical objects in a worksheet
  • use the Replace tools to replace cell contents and formats
  • use the Find and Replace tools when working specifically with formulas
  • use the Freeze tools to change the view settings within a worksheet
  • group rows and columns in a worksheet and control their display
  • use the Group tools to create Outlines in a worksheet

Excel 2019: Sorting & Filtering Data

Course:  38 Minutes Expertise Level:  Intermediate

Overview

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.

Objectives

  • sort data in a worksheet according to a specific data type
  • customize sort options when sorting data in a worksheet
  • sort data using multiple criteria and sort levels
  • create and use custom sort lists to sort data
  • use column filters to filter data in a worksheet
  • use column filters to apply multiple filters to data in a worksheet
  • create filter arguments using text and number data types
  • sort and filter data using colors applied to data
  • use the advanced filter tools to filter and extract data
  • use filter tools to hide duplicate values in a data range

Excel 2019: Referencing Data

Course:  44 Minutes Expertise Level:  Intermediate

Overview

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.

Objectives

  • reference cells in your Excel worksheet
  • use data across multiple worksheets to reference data for formulas
  • define absolute and relative cell references
  • name data ranges to refer to date and facilitate calculations
  • use the Name Manager to visualize, edit, and delete existing named ranges
  • perform calculations using constant values
  • use cell references indirectly
  • monitor data entries for changes and errors
  • activate and configure automatic updates
  • use formula auditing tools to track data

Excel 2019: Forecasting & Solving Problems

Course:  33 Minutes Expertise Level:  Intermediate

Overview

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.

Objectives

  • identify formula errors
  • check for and evaluate formulas in a workbook
  • use formulas to estimate loan-related costs
  • use the Goal Seek tool to modify a data variable and reach a target value
  • use the Solver add-in to analyze constraints and variables and optimize data values
  • insert a Forecast worksheet to display trends and predictions based on available historic data
  • use Data Tables to create what if, variable-based scenarios

Excel 2019: Creating Charts & Graphics

Course:  35 Minutes Expertise Level:  Intermediate

Overview

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.

Objectives

  • insert, edit and remove charts
  • customize chart labels
  • format a chart
  • customize chart elements
  • customize chart axes
  • create a chart template
  • present negative values in a chart
  • insert trendlines
  • customize trendlines

Excel 2019: Working with Different Chart Styles

Course:  24 Minutes Expertise Level:  Intermediate

Overview

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.

Objectives

  • insert and edit a Pie chart
  • create and edit a Scatter chart
  • create and edit a bubble chart
  • create and edit a radar chart
  • combine two types of chart using the Combo chart
  • create and edit a Map chart

Excel 2019: Working with Excel Tables

Course:  19 Minutes Expertise Level:  Intermediate

Overview

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.

Objectives

  • convert a data range into an Excel table and edits its contents
  • perform calculations and manipulate data in an Excel table
  • use the formatting tools and styles to change the appearance of a table
  • customize the table settings and tools
  • use slicers to filter data in an Excel table
  • resize and format a slicer

Excel 2019: Inserting PivotTables

Course:  32 Minutes Expertise Level:  Intermediate

Overview

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.

Objectives

  • insert a PivotTable
  • edit the source data and field setup in a PivotTable
  • use predefined styles and formatting tools to change the appearance of a PivotTable
  • copy and move a PivotTable within a workbook
  • use sort tools to change the display of data in a PivotTable
  • use filter tools to show and hide data in a PivotTable
  • use label and value filters to analyze data in a PivotTable
  • use group tools to sort and analyze related data in a PivotTable
  • use a Slicer to filter data in a PivotTable
  • customize the behavior and appearance of a Slicer
  • customize the behavior and appearance of a Slicer

Excel 2019: Using Conditional Formulas

Course:  39 Minutes Expertise Level:  Intermediate

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.

Objectives

  • 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 Expertise Level:  Intermediate

Overview

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.

Objectives

Excel 2019: Finding & Analyzing Information with Formulas

  • extract date values and perform calculations using dates
  • retrieve information relating to dates in the past, present, and future
  • use ranking formulas to find smallest and largest values in a list
  • extract data and separate values into separate cells in Excel
  • combine existing data values in a single cell in Excel
  • analyze complex tables with multiple arrays to obtain a summarized result
  • use the VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values
  • use conditional formulas to perform a search across multiple tables and automatically insert data
  • use the VLOOKUP formula to cross-reference data lists and retrieve corresponding values

Excel 2019: Configuring Options & Settings

Course:  32 Minutes Expertise Level:  Intermediate

Overview

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.

Algemene eigenschappen
Duur: 5:11 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja

Nieuw! 3x Supervoordelige Onbeperkt E-Learning abonnementen

ICT Trainingen & Cursussen abonnement
E-Learning abonnement met onbeperkte toegang tot meer dan 4.000 uur award winning 1000+ ICT trainingen, Virtuele Labs E-Books Proefexamen en testen met ter afsluiting een certificaat van deelname en digitale badges.

https://www.springest.nl/oem-office-elearning-menu/onbeperkt-it-e-leren-abonnement

Applicatie Trainingen & Cursussen abonnement
Onbeperkte toegang tot meer dan 250 award winning Applicatie E-Learning Trainingen & Cursussen met Aspire Journey's (van basis tot expert), Audio-samenvattingen, Audioboeken, E-Books, Samenvattingen, Kanalen, Virtuele Praktijk omgevingen, Proefexamens, Video's en altijd ter afsluiting een certificaat van deelname.

https://www.springest.nl/oem-office-elearning-menu/onbeperkt-applicatie-cursussen-training-abonnement

Zakelijke Vaardigheden & benodigdheden Trainingen & Cursussen abonnement
E-Learning abonnement met onbeperkte toegang tot meer dan 150 award winning zakelijke vaardigheden & benodigdheden trainingen & cursussen met Aspire Journey's (van basis tot expert), audio-samenvattingen, audioboeken, e-books, samenvattingen, kanalen, oefeningen, proefexamens, video's en altijd een certificaat van deelname.

https://www.springest.nl/oem-office-elearning-menu/onbeperkt-zakelijke-vaardigheden-training-abonnement#beschrijving

Online Demo?
Bestel direct online of maak een afspraak voor een online demo via de website van OEM Office Elearning Menu via ons contactformulier of neem telefonisch contact op.

Betalen in 3 termijnen 0% rente en zonder BKR?
Particulieren betalen in 3 termijnen, 0% rente en zonder BKR registratie met in3 op de website van OEM Office Elearning Menu.

Bekijk alle voordelen op de website van OEM Office Elearning Menu

10
Gemiddeld cijfer voor Excel 2019 Intermediate (English)
Gebaseerd op 1 ervaring
starstarstarstarstar
William H
10
Excel 2019 Intermediate (English)

"Very good! Good explanation, clear language. It was very nice to do this e-learning, so for others who want to do an e-learning it is highly recommended!

I'll give it a 10." - 01-03-2021 12:24

"Very good! Good explanation, clear language. It was very nice to do this e-learning, so for others who want to do an e-learning it is highly… alles lezen - 01-03-2021 12:24

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Vraag nu gratis en vrijblijvend informatie aan:

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
infoEr is een telefoonnummer vereist om deze informatieaanvraag in behandeling te nemen. (optioneel)
We slaan je gegevens op, en delen ze met OEM Office Elearning Menu NL, om je via e-mail en evt. telefoon verder te helpen. Meer info vind je in ons privacybeleid.