Home » Excel 2019 Intermediate

Opleiding: Excel 2019 Intermediate

Bij: OEM Office Elearning Menu

 

OEM Office Elearning Menu

P.J, Oudweg 4
1314 CH ALMERE
 

Inhoud van de cursus

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

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

4 uur

Bijzonderheden

Award Winning E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Algemene informatie over de cursus

Bestel deze geweldige, bekroonde Excel 2019 Gevorderd e-learning cursus online, 1 jaar 24/7 toegang tot uitgebreide interactieve video's, toespraken, praktische taken en voortgangsbewaking. Na de cursus ontvang je een certificaat van deelname.

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

Informatie aanvragen

Gegevens aangeduid met een * zijn verplicht in te vullen.
jaar
 
resterend: tekens
 
099dB Typ de code exact over: (hoofdlettergevoelig)
 
Copyright 2009-2021 Particuliereopleidingen.nl | Algemene voorwaarden | Overzicht van onze aanbieders | Adverteren