
Excel 2016 Advanced E-Learning
- Buy 3 for €77,60 each and save 3%
- Buy 5 for €76,00 each and save 5%
- Buy 10 for €72,00 each and save 10%
- Buy 25 for €68,00 each and save 15%
- Buy 50 for €70,00 each and save 13%
- Buy 150 for €65,00 each and save 19%
- Buy 300 for €60,00 each and save 25%
Take an online Excel 2016 Advanced course now. You learn, among other things, how to select and delete objects, filter and copy rows with the criterion range and make pivot charts.
- E-Learning - Online toegang: 365 dagen
- Taal: Nederlands of Engels
- Certificaat van deelname
- Ordered before 23:00, delivered tomorrow
- Certificaat van deelname
- Bedrijven bestellen op factuur
- Betaal in 3x geen extra kosten 0% rente en zonder BKR met in3
- More information? Contact us about this product
E-Learning Course Excel 2016 Advanced
Take these unique E-Learning course from Microsoft Excel 2016 on a advanced level online, 1 year 24/7 access to a virtual Office Cloud environment with rich interactive videos, speech, subtitling, practical assignments with real -time analysis of your answers, progress monitoring through reports to prepare you for the Microsoft Office Specialist MOS exam thanks to high quality. Door developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal LMS including reports and after 70% of the course a certificate of participation.
Course content:
Advanced:
Allocated time : 04:50:00
Displaying several lines of data in one cell
Absolute reference in a formula
Copying values, copying with a link, transposing
You need to know: Calculating with functions
Control date, date formats
Simple conditions
Custom formats
Applying a conditional format
Managing conditional formats
Naming a range of cells
Validation rules
Multiple cell ranges and calculations in functions
You need to know: Charts
Creating and positioning a chart
Managing a chart
Selecting items in a chart
Adding and removing items
Formatting chart items
Modifying a chart's text items
Legend and plot area
Printing and page layout of a chart
Modifying data labels
Data series and chart axes
Managing series
Chart type options
Managing chart templates
Creating a sparkline
Managing sparklines
Creating a drawing object
Selecting and deleting objects
Copying and moving objects
Resizing a drawing object
Modifying a text box
Modifying a drawing
Formatting drawing objects
Inserting a picture
Managing pictures
Rotating and aligning objects
Stacking and grouping objects
Subtotal rows
Creating and managing a table
Presenting and sorting data in a table
Automatic calculations in a table
Automatic filtering
Custom filters
Blank cells and duplicates
You need to know: Advanced filtering with a criteria range
Criteria ranges
Copying rows filtered using a criteria range
Statistics with a criteria range
You need to know: Flash Fill
You need to know: Pivot tables and pivot charts
Creating a pivot table
Modifying a pivot table
Selecting, copying, moving or deleting in a pivot table
Defining the layout and the presentation of a pivot table
Filtering and searching for data in a pivot table
Pivot charts
Brand | Microsoft Excel |
EAN | 8,71932E+12 |
Online access | |
Lesson duration | |
Study load | |
Certificate of participation | |
Learning methods | |
Operating systems | |
Included services | |
Supported browsers | |
MOS Exam |
average of 3 review(s)
Cursus is helder en erg leerzaam. Video uitleg wordt stap voor stap gegeven en als je de vraag niet goed hebt beantwoord, wordt er in de uitleg heel duidelijk aangegeven wat je moet doen.
Zeker een aanrader voor mensen die iets meer willen deep diven in hun Excel skills.
Leerzame training. Soms is de vraagstelling een beetje onduidelijk
Een zeer volledige, maar ook wel pittige training, waarbij ik heel veel heb geleerd over Excel. Doordat je stapje voor stapje mee wordt genomen door Excel is het erg goed te doen en was het voor mij erg leerzaam. De onderwerpen worden in kleine hoofdstukken behandeld. Ik vond dat erg prettig werken. Dat maakt het erg overzichtelijk.