
This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.
TRAINING NAME: |
|
FORMAT: |
|
|
---|---|---|---|---|
ASSOCIATED CREDENTIAL: |
|
LOCATION & SCHEDULES: |
|
|
COST: |
|
TESTING VOUCHER or CERTIFICATE OF COMPLETION? |
|
|
TARGET STUDENT: |
|
PREREQUISITES: |
| |
COURSE MATERIALS INCLUDE: |
|
|
HOW TO ENROLL: |
|
01 - Working with Multiple Worksheets and Workbooks | 06 - Creating Sparklines and Mapping Data | ||
---|---|---|---|
02 - Sharing and Protecting Workbooks | 07 - Importing and Exporting Data | ||
03 - Automating Workbook Functionality | 08 - Internationalizing
Workbooks |
||
04 - Using Lookup Functions and Formula Auditing | 09 - Working with Power Pivot | ||
05 - Forecasting Data | 10 - Advanced Customization Options |