|
|
|
Microsoft Office Excel Advanced Level |
Microsoft Excel Course Contents
Microsoft Office Excel Advanced Level
Customise Excel
Advanced Features In Excel
Customise Menus
Creating Custom Menus
Customise A Toolbar
Create A New Toolbar
Calculate your Data
Work With Named
Ranges
Range Naming Rules
Create Range Names Using Labels
Define Range Names For Data
Use A Named Range In A Formula
Use Subtotals
Add Subtotals To A Worksheet
What Is A Lookup Function?
The VLOOKUP Function
The HLOOKUP Function
Auditing Worksheets
Trace Precedents & Dependents
Trace Errors
Use Data Validation
Manage and Analyse Data
Create Data Lists
Sort List Data
AutoFilter & Advanced AutoFilter
Subtotal Columns
Outline A Worksheet
Remove An Outline
Query External Databases
Use The Query Wizard
Use Goal Seek
What Is A Scenario?
Scenarios
Create & View Scenarios
Data Linking
Data Consolidation
Link Consolidated Data
Link Data From Multiple Workbooks
Create A PivotTable
Modifying A Pivot Table
Create A Pivot Chart
Format a Workbook
What Is Conditional Formatting?
Use Conditional Formatting
What Is A Style?
Create & Apply A Style
Use Macros
Create Macros
What Is A Macro?
Assign A Macro
Edit A Macro
Manage Data and Workbooks
Import & Export Data
Import Data From Text Files
Import Data From Other Applications
Import Data From The Web
Export Data To Other Applications
Collaborate with Others
Share Workbooks
Create A Shared Workbook
Track Changes In A Shared Workbook
Track Changes
View The Change History
Protect Cells In A Worksheet
Apply Workbook Protection
Apply Password Protection
Excel and the Web
Create Web Pages
Publish A Worksheet To The Web
Create Hyperlinks
 
|
|
|
