De Meest Voordelige Opleider van Nederland
Award winning E-Learning & Gecertificeerde Trainers
Upgrade uw cv met een certificaat van deelname van OEM
SpringestMicrosoft PartnerEC-CouncilOfferte Aanvragen
0

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Microsoft Excel Excel 2016 Advanced and Expert E-Learning

Product description
E-Learning Course Excel 2016 Advanced & Expert Package  Take these unique E-Learning course from Microsoft Excel 2016 advanced and expert 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 t...

E-Learning Course Excel 2016 Advanced & Expert Package 

Take these unique E-Learning course from Microsoft Excel 2016 advanced and expert 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.With this course package you will receive an Excel 2016 course book as a reference work in addition to the online course.

Course content

Advanced:

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


Expert:

Converting data
Creating a data series
Custom views
Attaching a comment to a cell
Detecting errors
Evaluating formulas
The Watch Window
Lookup functions
Text functions
Time calculations
Date calculations
Condition with AND, OR, NOT
Nested conditions
Conditional functions
Array formulas
Calculating with copied values
Consolidation
Financial functions
Double entry data table
Goal seek
The Solver
Managing scenarios
Hyperlinks
Creating and customising a theme
You need to know: Styles and templates
Creating and working with templates
Modifying and deleting templates
You need to know: Exporting data
Diffusing Excel data: PDF, XPS, e-mail and Web page
Converting Excel files
Importing data
Updating and managing imported data
Workbook properties
Protecting workbooks
Protecting specific cells
Sharing a workbook
Tracking changes in a workbook
Merging workbooks
Finalising a workbook
Digital signatures
Creating a form
Protecting and using a form
Macros
Versions and recovery of files
You need to know: Customising the ribbon
You need to know: The SharePoint site
You need to know: Sharing a document over the internet
You need to know: Best practice with a spreadsheet application

Product specifications

Online access
365 days

Reviews

4.5 / 5Based on 6 reviews
  • 4 / 5
    Posted by: SHARON on 1 March 2020
    Best pittige formules. Je moet wel zelf rekenkundig kunnen denken. Maar goed te doen!
  • 5 / 5
    Posted by: Jesse Scheltens on 13 December 2019
    Goede cursus, veel verschillende aspecten. Duidelijke uitleg
  • 3 / 5
    Posted by: Dennis Lemmers on 10 December 2019
    Inhoud van de cursus Gevorderd is goed, die van de Expert cursus viel tegen qua toevoeging op de Gevorderd cursus
Create your own review

Excel 2016 + Naslagwerk

Microsoft Excel 2016 course Book

Microsoft Excel Excel 2016 Advanced and Expert E-Learning

Excel 2016 Advanced and Expert E-Learning

You save 2%
€132,50
€130,13

Excel 2016 + Naslagwerk

Excl. tax
I'm going to order

USP underneath buy button

Eerder bekeken door jou

Microsoft Excel Excel 2016 Advanced and Expert E-Learning
Microsoft ExcelExcel 2016 Advanced and Expert E-Learning

Take an Excel 2016 Basic and Advanced course now online. You will learn how to enter formulas, copy calculation results and links, transpose and adjust notation.

€85,00 Excl. tax
Please accept cookies to help us improve this website Is this OK? YesNoMore on cookies »