|
|
|
|
Microsoft Excel Advanced
Course Outline
VALIDATING, PROTECTING AND AUDITING FORMS & TEMPLATES
Using Data Validation
How To Validate Data Input
How To Compose A Data Input Message
How To Create An Error Alert Message
Creating New Workbook Using A Template
How To Create A New Workbook Using A Built-In Template On Your Computer
How To Create A New Workbook Using Templates From Office Online
How To Create A New Template
How To Create A New Workbook From Your Own Template
How To Edit The Template
Protecting Worksheet Styles, Contents And Elements
How To Protect The Worksheet
How To Unprotect The Worksheet
How To Unlock Cells For Editing In A Protected Sheet
How To Hide A Cell Formula In A Protected Sheet
How To Set A Password To Edit A Specific Range
How To Grant Selected Users Permission To Edit A Range Without A Password
Protecting Workbook Contents
How To Protect The Workbook Structure
How To Unprotect The Workbook Structure
Protecting Your Workbook From Unauthorized Users Access
How To Set A Password To Open A Worksheet
How To Remove A Password From A Workbook
How To Set A Password To Modify A Worksheet
Auditing Worksheets And Tracing Cell References
How To Select Cells That Contain Formulas
How To Watch Formulas
How To Find Cells That Provide Data To An Active Cell (Precedents)
How To Find Cells That Are Referred To By An Active Cell (Dependents)
How To Hide The Auditing Arrows
Tracing Invalid Data
How To Add And Remove Circles For Invalid Data
How To Correct Calculation Errors
How To Set Error Checking Options
How To Scan And Correct All Errors
WORKING WITH ADVANCED FORMATTING, STYLES AND OUTLINING
Customizing The Appearance Of Data With Advanced Formatting
How To Use The Built-In Number Formats
How To Customize The Number Format
How To Customize The Date Format
Using Conditional Formatting
How To Use Conditional Formatting
Maintaining Format Consistency With Styles
How To Add The Style Box Tool To The Toolbar
How To Create A New Style
How To Apply Styles
How To Redefine A Style
How To Delete A Style
How To Merge A Style From Another Workbook
Using Data Outlining
How To Create An Outline Automatically
How To Remove An Outline
How To Create An Outline Manually
How To Use A Subtotal To Create An Outline
How To Show / Hide Details Using Outline Symbols
How To Remove A Subtotal
WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
Managing Data in Multiple Worksheets
How To Select Adjacent Worksheets
How To Select Non-Adjacent Worksheets
How To Enter Data Into Multiple Worksheets
Using A 3-D Formula Across Worksheets
How To Enter A 3-D Formula Across Worksheets
How To Enter A 3-D Formula Across Worksheets Using A Function
Using Range Names
How To Define A Range Name
How To Define A 3-D Range Using The Menu
How To Redefine The Cell References For A Range Name
How To Delete A Range Name
How To Use A Range Name In A Formula
Combining Worksheets And Data From Different Workbooks
How To Consolidate Data
How To Move Or Copy Worksheets to Another Workbook
Linking Information From Different Worksheets And Workbooks
How To Link Information Using Copy And Paste Link
How To Update A Link
USING ADVANCED FUNCTIONS
Using Financial Functions
How To Use The PMT Function
How To Use The ABS Function
Using Logical Functions
How To Use A Logical Test
How To Use The IF Function To Return A Text
How To Use The IF Function To Return A Value
How To Use A Nested IF Function
How To Use The OR Function
How To Use The AND Function
How To Use the COUNTIF Function
USING WORKGROUP FEATURES
Using Comments
How To Add A Comment Into A Cell
How To Show Comments Permanently
How To Show/Hide Comment Indicators
How To Edit And Delete Comments
Sharing Workbooks
How To Enable Workbook Sharing
How To Disable Workbook Sharing
How To Merge Copies Of Shared Workbooks
How To Accept Or Reject Changes In A Merged Workbook
How To Protect A Shared Workbook
How To Track Changes In The Same Workbook
How To Accept Or Reject Changes From Different Users
Creating Workbooks With Restricted Permission Using IRM
How To Create A Workbook With Restricted Permission
How To View A Document With Restricted Permission
How To Allow Users To View A Workbook Without Microsoft Office 2003
How To Allow Users To Print A Document With Restricted Permission
How To Change A User’s Access Level
How To Set An Expiration Date For A Workbook
How To Attach Referral Information To A Restricted Workbook
How To Remove Restricted Permission From A Workbook
| |
|
|
|