Excel 2016 Advanced & Expert

Benefit

Discover the spreadsheet program Excel, and learn to master all its functions. In this course, you'll learn everything you can accomplish with the software, from advanced to expert functions.

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

Target group

For all users who already have knowledge of Excel 2016 and want to learn advanced, as well as expert functions.

Learning content

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