|
Microsoft Excel Objectives
Module 3 and 4 - Advanced
|
| |
| You cannot test
out of the Advanced courses. They are part of Level 3 of ITI. |
| |
|
VALIDATING, PROTECTING, AUDITING FORM AND TEMPLATE |
|
Using Data Validation |
|
Creating New Workbook Using Template |
|
Protecting Worksheet Style, Contents And Elements |
|
Protecting Workbook Content |
|
Protecting Your Workbook From Unauthorized Users Access |
|
Auditing Worksheets And Tracing Cell References |
|
Tracing Invalid Data |
|
Complete Exercise for this Section |
|
|
|
|
WORKING WITH ADVANCED FORMATTING, STYLE AND OUTLINING |
|
Customizing Data Appearance With Advanced Formatting |
|
Using Conditional Formatting |
|
Maintaining Format Consistency With Style |
|
Using Data Outlining |
|
Complete Exercise for this Section |
|
|
|
|
WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS |
|
Managing Data In Multiple Worksheets |
|
Using 3-D Formula Across Worksheets |
|
Using Range Name |
|
Combining Worksheets And Data From Different Workbooks |
|
Linking Information From Different Worksheets And Workbook |
|
Complete Exercise for this Section |
|
|
|
|
USING ADVANCED FUNCTIONS |
|
Using Financial Functions |
|
Using Logical Functions |
|
Complete Exercise for this Section |
|
|
|
|
|
USING WORKGROUP FEATURES |
|
Using Comments |
|
Sharing Workbooks |
|
Creating Workbook With Restricted Permission Using IRM |
|
Complete Exercise for this Section |
|
|
|
|
|
CREATING POWERFUL DATABASE |
|
Creating Database |
|
Managing Record In A Database |
|
Sorting Records |
|
Using AutoFilter |
|
Using Advanced Filter |
|
Using Simple Database Functions |
|
Using VLOOKUP Functions |
|
Complete Exercise for this Section |
|
|
|
|
|
CREATING PIVOTABLE AND ANALYZING DATA |
|
Creating PivotTable |
|
Updating PivotTable |
|
Modifying Calculated Field In PivotTable |
|
Creating Chart From PivotTable |
|
Exploring What-If Table |
|
Using Scenarios |
|
Implementing Problem Solving |
|
Complete Exercise for this Section |
|
|
|
|
|
AUTOMATING ROUTINE TASKS WITH MACROS |
|
Understanding Macro |
|
Editing Macro |
|
Using Relative Reference Macro |
|
Complete Exercise for this Section |
|
|
|
|
|
INTEGRATING WITH OTHER APPLICATIONS |
|
Importing / Exporting Data |
|
Retrieving Data From A Database |
|
Complete Exercise for this Section |
|
|
|
|
|
WORKING WITH THE WEB |
|
Creating Web Pages |
|
Editing The Web Pages |
|
Complete Exercise for this Section |
|
|
HOME