Eliquo - Excel 3 - EN

Microsoft Office Excel 2016 is the newest version of Microsoft’s popular spreadsheet program. This explores the advanced features in in Excel 2016. Students will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data and import/export XML data.

prerequisite:
Pré-requis :
MO16EX201—Microsoft Excel 2016 - Part Two or equivalent knowledge or experience is mandatory.
Durée :
Duration:
1 Day

Ordre du jour

Outline

Automating Worksheet Functionality

Macros

Conditional Formatting

Data Validation

Auditing Worksheets

Trace Cells

Evaluate Formulas

Analyzing and Presenting Data

Sparklines

Scenarios

What-If Analysis

Working with Multiple Workbooks

Consolidate

Link

Merge Workbook

Exporting Excel Data

Export Excel Data

Import CSV

Web Query

-

Autres cours