|
LINKING
WORKSHEETS WITHIN A WORKBOOK
Setting up Related Worksheets
Moving the Cell Pointer From One Worksheet to Another
Copying Data From One Worksheet to Another
Entering a Formula to Link Related Worksheets
Formatting Multiple Worksheets in One Operation
Printing Multiple Worksheets in One Operation
LINKING MULTIPLE WORKBOOKS
Entering a Formula to Link Multiple Workbooks
Creating a Workspace
NAMING RANGES
Defining a Range Name
Using a Range Name in a Formula
Moving to a Named Range
CUSTOMIZING EXCEL
Defining a Custom AutoFill Series
Creating a Template
Modifying the Default Template Style
Basing a New Workbook on a Custom Template
Creating and Displaying a View
Outlining a Worksheet
USING FINANCIAL FUNCTIONS
Using the PMT Function
Using the FV Function
Setting Up a Financial Analysis Table
MANIPULATING TEXT STRINGS
Concatenating Labels
Using the TEXT Function
Using the PROPER, UPPER and LOWER Functions
ANALYZING DATA
Creating a PivotTable
Resetting the Function in a PivotTable
Using the Goal Seek Feature
Using the Histogram Tool
Using the Moving Average Tool
USING LOGICAL AND LOOKUP FUNCTIONS
Using the IF Function
Nesting IF Functions
Using the VLOOKUP Function
Further Applications for the VLOOKUP Function
Back to UT
Training Classes
|
