Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »
113917741 SKU 113917741

Excel 2019 Course Basic Advanced Expert E-Learning

113917741 SKU 113917741

Excel 2019 Course Basic Advanced Expert E-Learning

90,00 108,90 Incl. tax

Learn everything from Excel 2019 from Basic to Expert level in this online course Excel 2019 Basic, Advanced and Expert. View the full course content for all details.

Read more
Discounts:
  • Buy 5 for €85,00 each and save 6%
  • Buy 11 for €80,00 each and save 11%
  • Buy 31 for €75,00 each and save 17%
  • Buy 61 for €70,00 each and save 22%
  • Buy 101 for €60,00 each and save 33%
  • Buy 251 for €50,00 each and save 44%
  • Buy 501 for €40,00 each and save 56%
Availability:
In stock
Delivery time:
Order before 4:00 PM and start today.
Browse our training methods: Microsoft Excel , E-learning , Courses , Course Excel 2019
  • Award Winning E-learning
  • De laagste prijs garantie
  • Persoonlijke service van ons deskundige team
  • Betaal veilig online of op factuur
  • Bestel voor 17:00 uur en start vandaag

Excel 2019 Course Basic Advanced Expert E-Learning

  • Target group: Anyone with basic knowledge who wants to master the advanced features of Excel
  • Level: Basic, Advanced + Expert
  • Required knowledge level: Basic computer knowledge
  • Course duration: 14:50 (Video clips of 2 to 5 minutes / depending on personal speed)
  • Online access: 24/7, 365 days after activation
  • Online book included
  • Certificate of Participation included (after a minimum of 70% success rate)

Get to know the spreadsheet program Excel with this Excel course and master the basic to advanced functionalities. After attending the Excel course, you will be able to make full use of Excel. All necessary basic topics will be covered such as: entering and formatting data, simple to complex calculations, charts, managing large tables, pivot tables and various advanced functionalities.

During the Advanced and Expert classes, you will go deeper and learn more about the advanced/expert features of Excel. Thanks to this course, you will learn about new functionalities and better utilize others.

Unique Excel 365 course (version 2019) in a virtual Office 365 cloud environment with practice exercises and rich interactive videos with voice and subtitles. In addition, it shows a real-time analysis of your answers and has progress monitoring through reports.

This Excel e-learning course also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Developed by MOS teachers with more than 27 years of experience. The publisher is also a Microsoft Gold Partner. The Learning Portal (LMS) includes reports and after passing at least 70% of the course you will receive a certificate of participation. SCORM is also an option for this course.

Content of the training

Basic

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

Introduction to Excel, fill in a table

  • What you need to know about: Spreadsheets
  • Open workbooks
  • General working environment
  • Move in workbook
  • What you need to know about: Input Help
  • Enter data
  • What you need to know about: Select, copy and move
  • Select and clear cells
  • Cancel and restore operation
  • Column width/row height
  • What you need to know about: Saving files
  • Save workbooks
  • Adjust cell contents
  • Create new workbook

Make your first calculations

  • Enter formulas
  • Sum and other simple calculations
  • Calculate percentage
  • Copy to adjacent cells

Take care of the formatting of your data

  • Simple number formats
  • Apply theme
  • Character format
  • Font and size
  • Align Cell Contents
  • Cell color
  • Cell borders

Print and set page layout your worksheets

  • Page layout
  • Print preview and printing
  • Page break
  • Print Range
  • What you need to know about: Header and Footer
  • Header and Footer

Work more efficiently with Excel

  • Using Excel Help
  • Spell check
  • Find and replace
  • Zoom in and out
  • Insert or delete rows, columns, and cells
  • Move cells
  • Copy to non-adjacent cells
  • Quick copy cell formatting
  • Merge cells
  • Cell contents orientation
  • Cell Styles
  • Sort a table

Manage the worksheets

  • Worksheet name and tab color
  • Insert, delete worksheets and set background
  • Move, copy, and hide worksheets
  • Block column/row, split screen
  • Print column and row titles repeatedly
  • Hide items on worksheet
  • Group data in overview

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
Online access 365 days
Lesson duration 14:50 hours
Total
9.6/10 (5 Reviews)

    "Het is af en toe wel lastig dat alle cel bereiken getypt moeten worden ipv slepen en selecteren. Verder hadden er per item wel 2 ipv 1 opdrachten mogen zijn."

    Steentjes on 03 Jun 2022

    "Ik was opzoek naar een training voor Excel en ik kwam hier terecht.
    Uitstekend uitgelegd met virtuele video's met veel praktijk opdrachten met een virtueel boek. Je krijgt meteen feedback door een video die de oplossing uitlegt. Was onder de indruk, ben erg verrast. Aanrader."

    Valentina on 21 Apr 2022

    "Tot nu toe veel uit deze cursus gehaald. Mijn dagelijkse werkzaamheden in Excel zijn veel effectiever dan voorheen! Start nu met niveau 3. De opdrachten zijn duidelijk en gebruiksvriendelijk. Ook het later kunnen hervatten van de training is ideaal. Op deze manier kan je tussen de bedrijven door de cursus doen wanneer je een drukke agenda hebt. Ik kijk uit naar het vervolg!"

    Guillaume on 17 Sep 2021

    "Super training! Echt een aanrader!"

    Wouter on 01 Mar 2021

    "Geweldige training. Super veel geleerd."

    Harold on 03 Feb 2021

Excel 2019 E-Learning + Cursusboek

  • Normally: 139,95
  • You save: (7% korting) 10,-
  • Total: 129,95
Add to cart

Reviews

Total
9.6/10 (5 Reviews)

    "Het is af en toe wel lastig dat alle cel bereiken getypt moeten worden ipv slepen en selecteren. Verder hadden er per item wel 2 ipv 1 opdrachten mogen zijn."

    Steentjes on 03 Jun 2022

    "Ik was opzoek naar een training voor Excel en ik kwam hier terecht.
    Uitstekend uitgelegd met virtuele video's met veel praktijk opdrachten met een virtueel boek. Je krijgt meteen feedback door een video die de oplossing uitlegt. Was onder de indruk, ben erg verrast. Aanrader."

    Valentina on 21 Apr 2022

    "Tot nu toe veel uit deze cursus gehaald. Mijn dagelijkse werkzaamheden in Excel zijn veel effectiever dan voorheen! Start nu met niveau 3. De opdrachten zijn duidelijk en gebruiksvriendelijk. Ook het later kunnen hervatten van de training is ideaal. Op deze manier kan je tussen de bedrijven door de cursus doen wanneer je een drukke agenda hebt. Ik kijk uit naar het vervolg!"

    Guillaume on 17 Sep 2021

    "Super training! Echt een aanrader!"

    Wouter on 01 Mar 2021

    "Geweldige training. Super veel geleerd."

    Harold on 03 Feb 2021

Microsoft Office SCORM e-Learning

Wilt u Microsoft Office e-Learning SCORM hosten in het LMS van uw organisatie? Neem contact met ons op.

Combideals

Grab a bundle and receive a discount

Excel 2019 E-Learning + Cursusboek

  • Normally: 139,95
  • You save: (7% korting) 10,-
  • Total: 129,95
Add to cart

Cursisten beoordeling

Springest: 8.8, Edubookers: 8.5

Kwaliteitsgarantie

Award Winning E-learning & Gecertificeerde Docenten

Microsoft Partner

én Certiport Partner

Niet Goed Geld Terug

én Startgarantie

Even more knowledge

Read our most recent articles

View blog