IT & Software

Excel 2016 Advanced

by M.I.T e-Solutions GmbH
Back to Courses
Proceed to Checkout Edit Shopping Cart Got a voucher? Book for others? Go to the shopping cart!
Preview image for training Excel 2016 Advanced
including VAT 34,99

Course Features

  • Certified by TÜV Rheinland
  • Lifetime Access
  • Course Level: Intermediate
  • Learning Extent: 8 hrs. 00 min.
  • Language: english
Target Audiences:

Course Overview

About this online Course

The learning program is aimed at users who use MS Excel for demanding calculations or for data evaluation. Deepen your knowledge of formulas and functions and learn how to use conditional formatting or range names to simplify the construction of complex calculations. One focus of the learning program deals with the import and preparation of (data) lists or tables for data analysis. From simple (table) filters to sophisticated pivot tables, you will learn how easy and effective data analysis in Excel can be. You will also learn how to share workbooks in a team and how to protect your data appropriately.

Beyond the general applications of Excel 2016, this e-Learning will teach you how to use sophisticated pivot tables and how to use Excel for effective data analysis. This course serves as preparation for the corresponding ECDL module.

Target group

Users who are familiar with the basics of MS Excel and want to deepen their knowledge.

Learning content

  • Worksheets
  • Formulas
  • Excel functions
  • Working with tables
  • Data import
  • PivotTables
  • Working with diagrams
  • Workbooks in a team

Learning Contents

Summary of Learning Contents

Excel 2016 Advanced 

timelapse 8 hrs. 00 min.
  • Excel 2016 Advanced 
    extension interactive content
    timelapse 8 hrs. 00 min.

Ratings

Overall Rating

Average Rating
{{ summary.avg }}
{{ summary.total }} Rating {{ summary.total }} Ratings
{{ 5 - summaryRating }} stars:
{{ summaryCount }} Ratings

Reviews

from {{ rating.user.display_name }} am {{ rating.created_at | formatDate }}

Answer from {{ rating.answer_user.display_name }} Adminstrator am {{ rating.answered_at | formatDate }}

star_border

This training does not yet have ratings.

Questions & Discuss

Comments and Questions about the course

Do you have any general questions about the course? Would you like to get a more detailed picture of the structure of the course? Whether you want to share your own experiences with the learning community or have questions about a specific content: Feel free to join the discussions with other learners on this course.

Please login to participate in this course discussion.
chat_bubble_outline

No comment available. Be the first one to leave a reply.


Courses you may also be interested in:

Preview image for training Online-Aufbaukurs Excel 2016
IT & Software
Excel 2016 Aufbaukurs
Preview image for training Online-Zusammenarbeit
IT & Software
Online-Zusammenarbeit
Preview image for training Online-Grundlagenkurs PowerPoint 2016
IT & Software
PowerPoint 2016 Grundlagen
Preview image for training Neuheiten in Microsoft Office 2016 und Office 365
IT & Software
Neuheiten in Microsoft Office 2016 und Office 365