Excel 2019 - Expert Advanced Formulas, Macros and External Data

Excel 2019 - Expert Advanced Formulas, Macros and External Data

Regular price
£15.00
Sale price
£15.00
Shipping calculated at checkout.

Seat time: 3.5 hours

About the course:

This course covers topics included in the MOS Expert exam 77-728. This includes custom templates, data formats and Internationalizing workbooks. You will also get external data, use macros and form controls, evaluate formulas and use the MATCH and INDEX functions.

Modules:

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

You'll learn:

Languages and Accessibility

  • Internationalization
  • Language Options
  • Adding Editing Languages
  • Language Proofing Options
  • Applying Currency Formats
  • Applying Accounting Formats
  • Applying Date Formats
  • Creating Font Themes
  • Checking for Accessibility

AutoSave and Templates

  • AutoSave
  • Restoring AutoSave Versions
  • Restoring AutoRecover Files
  • Creating New Templates
  • Opening Custom Templates

MATCH and INDEX Functions

  • MATCH and INDEX Functions
  • Entering Validation Rules
  • Using MATCH Functions
  • Using INDEX Functions
  • Nesting Functions

Custom Formatting

  • Creating Custom Formats
  • Creating Number Formats
  • Creating Date Formats
  • Creating Time Formats
  • Creating Conditional Formats
  • Applying Conditional Formats
  • Creating Custom Styles
  • Applying Custom Styles

External Data and Queries

  • Get External Data
  • Refreshing External Data
  • Importing Multiple Tables
  • Creating Custom Queries
  • Appending Queries
  • Merging Queries
  • Removing Fields
  • Editing Steps
  • Renaming Fields

Evaluating Formulas and Watch Window

  • Working with Formulas
  • Evaluating Formulas
  • Dependents and Precedents
  • Tracing Dependents
  • Tracing Precedents
  • Using the Watch Window

Macros and Form Control

  • Macros
  • Customize Ribbon Settings
  • Viewing Macros
  • Editing Macros
  • Worksheet Controls
  • Inserting Controls
  • Adding Text Boxes
  • Modifying VBA Code
  • Using Structured References
  • Using Flash Fill