IT & Software

Excel 2016 Basic, Advanced & Expert with pretest

by OEM Office Elearning Menu
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 Basic, Advanced & Expert with pretest
including VAT 119,99

Course Features

  • Certified by TÜV Rheinland
  • Lifetime Access
  • Course Level: Beginner
  • Learning Extent: 13 hrs. 10 min.
  • Language: english
Target Audiences:

Course Overview

About this online Course

This online course Excel 2016 for beginners, advanced and experts offers you an exceptional e-learning methodology in a virtual office application. Learn at your own pace and in your own order directly in the virtual application 'Excel 2016'.

Based on a placement test before the start of the course, you will be assigned appropriate learning modules. The duration of the course varies according to your level.

The course has been developed by professional instructors with more than 27 years of experience and offers you varied, interactive multimedia lessons with video, audio and subtitles. Practical exercises with real time analysis of actions and results help you learn.

This online course can be used to prepare for the Microsoft Office Specialist (MOS) exam.

Benefit

Discover the spreadsheet program Excel and master all its functions. In this course, you'll learn everything you can do with the software, from basic to expert functions. A placement test before the course begins will test your current knowledge of Excel 2016 and tailor learning modules to your skill level.

No proprietary software is required for this online course. You learn in a virtual environment directly in Excel 2016.

Target group

For all users who would like to learn or repeat the basics of Excel and get to know advanced as well as expert functions.

Learning content

Level 1: Basic knowledge

  • Explore Excel and complete a workbook
  • Discover Excel, perform your first actions: create, open and save a workbook, enter and edit data, etc.
  • Things to know: Discover a spreadsheet
  • Opening a workbook
  • General information about the work environment
  • Navigating in a workbook
  • Things to know: Accessibility
  • Entering data
  • Things to know: Selecting, copying, and moving data
  • Selecting and deleting cells
  • Undoing and redoing an action
  • Column width and row height
  • Things to know: Saving files
  • Saving a workbook
  • Changing the contents of a cell
  • Creating a new workbook
  • Performing your first calculations
  • Entering a calculation formula
  • Sums and other simple calculations
  • Calculating a percentage
  • Transferring to adjacent cells
  • Apply minimal presentation to your data
  • Simple number formats
  • Apply a theme
  • Things to know: Formatting characters
  • Highlighting characters
  • Font and font size
  • Alignment of cell content
  • Color of cells
  • Cell borders
  • Page layout
  • Preview and print
  • Page break
  • Print area
  • Things to know: Header and footer
  • Header and footer
  • Work more efficiently
  • Using Excel Help
  • Spell check
  • Search and replace
  • View zoom
  • Insert/delete rows, columns and cells
  • Move cells
  • Copy to non-contiguous cells
  • Quick copy of a cell format
  • Merge cells
  • Alignment of cell contents
  • Cell format templates
  • Sort data
  • Manage sheets and the display of your data
  • Name of a sheet, sheet tab color
  • Insert, delete and background worksheets
  • Move, copy and hide a worksheet
  • Freeze rows/columns, split the window
  • Repeat columns/row headings when printing
  • Hide elements of a sheet
  • Arrange data in the form of an outline

Level 2: Advanced knowledge

  • Display multiple rows in a cell
  • Formulas with absolute cell reference
  • Transfer values, copy with link or transpose
  • Interesting facts: Entering arithmetic functions
  • System date and date format
  • Simple condition
  • User-defined format
  • Applying conditional formatting
  • Managing conditional formatting
  • Name of a cell range
  • Validity criteria
  • Cell ranges in a function
  • Representing your numbers in charts
  • Things to know: Charts
  • Create and move a chart
  • Manage charts
  • Select chart elements
  • Add and delete elements
  • Formatting diagram elements
  • Editing the text elements of the diagram
  • Legend and drawing area
  • Print a diagram and define the page setup
  • Improve the appearance of your diagrams
  • Change the data labels
  • Data series and axes of a chart
  • Manage data series
  • The chart type options
  • Manage chart templates
  • Create Sparklines
  • Manage a sparkline
  • Make your charts more attractive
  • Create drawing objects
  • Select and delete objects
  • Copying and moving objects
  • Change the size of a drawing object
  • Edit a text field
  • Edit a drawing
  • Format drawing objects
  • Inserting an image
  • Manage images
  • Rotate and align objects
  • Object order and grouping
  • Use your tables with data lists
  • Calculate partial results
  • Create and manage a table
  • Display and sort data in a table
  • Automatic calculations in a table
  • AutoFilter
  • User-defined filters
  • Empty values and duplicates
  • Things to know: Criteria Range
  • Using a criteria range
  • Filtering and copying rows using a criteria range
  • Statistics with a criteria range
  • Fun facts: Lightning preview
  • Create and use PivotTables
  • Fun facts: PivotTables and PivotCharts
  • Create a PivotTable
  • Editing a PivotTable
  • Selecting, copying, moving, and deleting a PivotTable report
  • Layout and formatting of a PivotTable
  • Filtering and searching a PivotTable
  • PivotChart

Level 3: Skills for experts

  • Data conversion
  • Creating data series
  • Custom views
  • Add comments to cells
  • Error checking
  • Evaluate formulas
  • The watch window
  • Reference table and search functions
  • Text functions
  • Hour calculation
  • Date calculations
  • Conditions with AND, OR, NOT
  • Nested conditions
  • Conditional functions
  • Matrix formula
  • Perform calculations when copying
  • Consolidate
  • Financial functions
  • Data table with two variables
  • Discover unexpected functions
  • Target value
  • The Solver
  • Manage scenarios
  • Hyperlink
  • Create and use a template
  • Modify and delete a template
  • Things to know: Exporting data
  • Transfer Excel data: PDF, email, and web page
  • Converting Excel files
  • Importing data
  • Updating and managing imported data
  • Properties of a workbook
  • Protecting a workbook
  • Protect cells
  • Share a workbook
  • Track changes to a workbook
  • Merging workbooks
  • Finalize a document
  • Digital signature
  • Create a form
  • Protect and use a form
  • Even more...
  • Macro commands
  • Versions and restoring files
  • Things to know: Customizing the ribbon
  • Things to know: Sharepoint
  • Things to know: Microsoft account
  • Things to know: The right way to work with a spreadsheet

Learning Contents

Summary of Learning Contents

Excel 2016 Basic, Advanced & Expert with pretest 

timelapse 13 hrs. 10 min.
  • Excel 2016 Basic, Advanced & Expert with pretest 
    extension interactive content
    timelapse 13 hrs. 10 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 Excel 365 | 2019 Grundlagenkurs
IT & Software
Excel 365 | 2019 Grundlagen
Preview image for training Excel 2016 - Online-Aufbaukurs
IT & Software
Excel 2016 Aufbaukurs
Preview image for training Excel 2019 Anfänger, Fortgeschrittene & Profis mit Einstufungstest
IT & Software
Excel 2019 Anfänger, Fortgeschrittene & Profis mit Einstufungstest
Preview image for training Excel: Formeln und Funktionen
IT & Software
Excel: Formeln und Funktionen