Excel - Excel 365 Advanced Expert - Excel voor Financials, Draaitabellen in Excel, Excel Draaitabellen, Excel basis / voor beginners, Data Analyse Excel, Draaitabellen

Type product

Excel - Excel 365 Advanced Expert - Excel voor Financials, Draaitabellen in Excel, Excel Draaitabellen, Excel basis / voor beginners, Data Analyse Excel, Draaitabellen

OEM Office Elearning Menu NL
Logo van OEM Office Elearning Menu NL
Opleiderscore: starstarstarstarstar_half 8,9 OEM Office Elearning Menu NL heeft een gemiddelde beoordeling van 8,9 (uit 180 ervaringen)

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

Beschrijving

Excel 365 Advanced Expert 

Excel 365 course E-Learning version 2019 in a virtual Office 365 cloud environment with practical assignments and rich interactive videos with speech and subtitles with real-time analysis of your answers, progress monitoring through reports. This e-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Door developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. Reports in the Learning Portal (LMS) and a certificate of participation after >70% of the course. SCORM capability.

Goal
Get to know the Excel spreadsheet program and master the basic to advanced functiona…

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: Data Analyse Excel, Draaitabellen in Excel, Excel basis / voor beginners, Excel voor Financials en Draaitabellen.

Excel 365 Advanced Expert 

Excel 365 course E-Learning version 2019 in a virtual Office 365 cloud environment with practical assignments and rich interactive videos with speech and subtitles with real-time analysis of your answers, progress monitoring through reports. This e-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Door developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. Reports in the Learning Portal (LMS) and a certificate of participation after >70% of the course. SCORM capability.

Goal
Get to know the Excel spreadsheet program and master the basic to advanced functionalities. After following this training, you can make full use of Excel. All necessary themes are covered such as: entering and formatting data, simple to complex calculations, graphs, managing large tables, pivot tables and advanced functionalities.

Target audience
Anyone who wants to (re)learn how to use the basic operations in Excel and who wants to master the advanced functionalities.

Required level
No knowledge of Excel is required. With minimal use of the program, progress will be made faster.

Expected duration for the indispensable modules
10 hours 40 minutes
(Video clips averaging 2 to 5 minutes)

Content of the training

Advanced

This module offers you an interactive training, consisting of 60 teaching videos, 60 assignments and
5 files with additional information.

Evolving into complicated tables

  • Show multiple lines in cell
  • An absolute reference in formula
  • Copy, transpose calculation results and links
  • What you need to know about: Entering functions
  • System date and date format
  • Simple condition
  • Custom format
  • Apply a conditional format
  • Manage conditional formatting
  • Cell Range Name
  • Validation criterion
  • Cell ranges in functions

Present your figures in graph form

  • What you need to know about: Charts
  • Create and move a chart
  • Manage a chart
  • Select chart elements
  • Add or remove chart elements
  • Formatting chart elements
  • Change Chart Text Elements
  • Legend and Artboard
  • Print a chart and page layout

Improve the layout of your charts

  • Change data labels
  • Data series and chart axes
  • Manage sequences
  • Chart Type Options
  • Manage chart templates
  • Create a 2D map chart
  • Create a sparkline chart
  • Manage Sparklines

Beautify your tables

  • Create a graphic object
  • Select and delete objects
  • Copy and move objects
  • Determine graphic object size
  • Change a text box
  • Edit a shape
  • Formatting drawing objects
  • Insert an image
  • Manage images
  • Rotate and align objects
  • Overlap and group objects

Take advantage of your data lists

  • Calculating Subtotals
  • Create and manage a data table
  • Displaying and sorting data from a data table
  • Add calculation to a data table
  • Automatic filtering
  • Custom filters
  • Empty and duplicate values
  • What you need to know about: Criteria ranges
  • Filter by criteria range
  • Filter and copy rows with criteria range
  • Criteria Range Calculations

Create and use pivot tables and charts

  • What you need to know about: PivotTables and Charts
  • Create pivot table
  • Modify a pivot table and add calculations
  • Change the source of a pivot table
  • Select, copy, move, and delete a pivot table
  • PivotTable Structure and Printing
  • Layout of a pivot table
  • Filtering a pivot table
  • Filtering using slicers
  • Basing a PivotTable on Multiple Data Tables
  • Add fields or calculated elements
  • Group data
  • Create a pivot chart

Expert

This module offers you an interactive training, consisting of 42 teaching videos, 42 assignments and
5 files with additional information.

Work even more efficiently

  • Convert data
  • What you need to know about: Auto-Fast Fill
  • using data series
  • Custom Views
  • Note to cell
  • error checking
  • Evaluate Formulas
  • Control window

Use advanced function calculations

  • Search table and functions
  • Text functions
  • Calculate time
  • Calculate dates
  • Conditions with AND, OR, NOT
  • some conditions
  • Conditional Functions
  • Array Formula
  • Calculations with copies
  • To merge
  • Financial functions
  • Double Entry Table

Discover new functionalities

  • Goal Seeking
  • solver
  • Scenario management
  • hyperlink
  • What you need to know about: Styles and Templates
  • Create and customize a theme
  • Create and use a template
  • What you need to know about: Import, export and interoperability
  • Editing and Deleting a Template
  • Transfer Excel data: PDF, XPS, email and web page
  • Convert Excel files
  • Import data
  • Update and manage imported data
  • Workbook properties

Share workbooks in a safe way

  • Security workbook
  • Protect cells
  • Share a workbook
  • Track workbook changes
  • Merge workbooks
  • Completion of a workbook
  • Digital signature
  • Create a form
  • Securing and using a form

To learn more about it…

  • Macro command
  • Restore versions and files
  • What you need to know about: Customizing the ribbon
  • What you need to know about: Good Spreadsheet Habits
  • What you need to know about: Collaborate on a workbook

Office 2019: Cases
Excel, Word or PowerPoint with an Office 365 subscription
This module offers you a video with a length of 20 minutes.

An e-mail message from Office with or without an Office 365 subscription: what are the differences?
Create and save Office documents on OneDrive, SharePoint Online or Teams
Edit a document from OneDrive, SharePoint, or Teams
Share Office documents with colleagues or with people outside the organization
Collaborate on a file

Excel 2019: Cases
This module offers you a video with a length of 48 minutes.
Set up a quality control

Presentation of the use case
Creating the Statistical Formulas
Prepare the chart
Create control chart
Customize control chart display
Conclusion

Analyzing library visits
Presentation of the use case
The graph Evolution of visitor numbers
Create the pivot tables
Conclusion

Keep track of budget
Presentation of the use case
Create the pivot tables
Creating the charts
Create the dashboard
Conclusion

Reduce costs
Presentation of the use case
Creating the Formulas
Solve the problem with the Solver
Conclusion

Excel 2019 – Versions 2019 and Office 365 Online Book
In this module you can consult an online book.

Verrijk Uw Carrière met OEM's 1000+ ICT Trainingen en Certificeringen

Ontdek de wereld van mogelijkheden met OEM's uitgebreide aanbod van meer dan 1000 ICT trainingen, cursussen, en certificeringen. Of u nu op zoek bent naar E-Learning, Incompany trainingen of Virtual Classroom sessies, wij hebben alles om aan uw leerbehoeften te voldoen.

Waarom voor OEM Kiezen?

  • Uitgebreide Selectie: Kies uit een breed scala aan cursussen van meer dan 200 topmerken voor uw persoonlijke en professionele groei.
  • Hoge Tevredenheid: Onze cursisten hebben ons een indrukwekkende beoordeling van 8.9 op Springest gegeven.
  • Kwaliteitsgarantie: Profiteer van onze Award Winning E-learning en leer van gecertificeerde docenten die experts zijn in hun vakgebied.

Neem Nu Actie voor Uw Professionele Ontwikkeling:

  • Bezoek onze website om het volledige aanbod te verkennen en de training te kiezen die bij u past.
  • Schrijf u vandaag nog in en begin aan uw reis naar certificering en deskundigheid in de ICT.

Wacht niet langer om uw vaardigheden te verbeteren en uw carrière naar een hoger niveau te tillen. Met OEM's uitgebreide trainingsaanbod bent u slechts één stap verwijderd van het realiseren van uw professionele doelen.

Begin vandaag nog met leren – Uw toekomst wacht!

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

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

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.