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