Microsoft Excel Excel 2016 Basic and Advanced E-Learning
Excel 2016 Basic and Advanced E-Learning
€85,00
Microsoft Excel

Excel 2016 Basic and Advanced E-Learning

EUR 85,00 Excl. tax
  • Buy 3 for €82,45 each and save 3%
  • Buy 5 for €80,75 each and save 5%
  • Buy 10 for €76,50 each and save 10%
  • Buy 25 for €72,25 each and save 15%
  • Buy 50 for €70,00 each and save 18%
  • Buy 150 for €65,00 each and save 24%
  • Buy 300 for €60,00 each and save 29%

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.

  • E-Learning - Online toegang: 365 dagen
  • Taal: Nederlands of Engels
  • Certificaat van deelname
In stock
Order before 4:00 PM and start today.
Quantity
- +
  • 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
Product description

E-Learning Courses Office 2016 Basics and Advanced

Take these unique E-Learning courses from Microsoft Excel 2016 on a basics and 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.

Content:

Basic:

Allocated time : 04:15:00

You need to know: About your spreadsheet application
Opening a workbook
Overview of the environment
Moving around a workbook
You need to know: Text made easy
Entering data
You need to know: Selecting, copying, moving
Selecting and deleting cells
Undoing and redoing an action
Column width/row height
You need to know: Saving files
Saving a workbook
Modifying the contents of a cell
Creating a new workbook
Entering a calculation formula
Calculating a sum and other basic functions
Calculating a percentage
Reproducing data in adjacent cells
Simple numerical formats
Applying a theme
You need to know: Formatting characters
Formatting characters
Character font and size
Aligning cell content
Cell colour
Cell borders
Page layout
Print preview and printing
Page breaks
Print areas
You need to know: Headers and footers
Headers and footers
Using Microsoft Excel Help
Checking spelling
Find and replace
Zoom
Inserting/deleting rows, columns and cells
Moving cells
Copying to non-adjacent cells
Copying cell format quickly
Merging cells
Orientation of cell content
Cell styles
Sorting data
Sheet name, tab colour
Inserting and deleting sheets, sheet background
Moving, copying, hiding sheets
Splitting the window, freezing a column/row
Repeating rows/columns on printed pages
Hiding elements of a sheet
Summarising data with an outline

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

Product information
Brand Microsoft Excel
EAN 8,71932E+12
Specifications
Online access
Lesson duration
Study load
Certificate of participation
Learning methods
Operating systems
Included services
Supported browsers
MOS Exam
Combination deals
What our customers say
5,0/5

average of 3 review(s)

My account
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Language
Cart
Your cart is empty
Menu
Search
Search suggestions
No courses or trainings found...
Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »