Excel 2016 – Expert – Advanced Formulas, Macros and External Data

R276.00

SKU: 46479 Category:

Description

The Excel 2016 – Expert – Advanced Formulas, Macros and External Data course covers topics included in the MOS Expert exam 77-728. This includes Tracking changes, using Logical, Informational, Time, Mathematical and Lookup Functions. You will also learn how to Consolidate workbooks, Share and Protect workbooks and use Auditing tools. There are 7 modules in this course:

Languages and Accessibility
* AutoSave and Templates
* Custom Formatting
* External Data and Queries
* Macros and Form Controls
* Evaluating Formulas and Watch Window
* MATCH and INDEX Functions

5 CPTD Points

Additional information

Training Duration

3 Hours 30 Minutes

Publisher

Knowhow2 IT desktop