Course Contents
Naming Ranges
·
Defining a Range Name
·
Using a Range Name
·
Selecting a Named Range
Working
with a List
·
What
is a list?
·
Sorting the Records of a list
·
Filtering the Records of a List
·
Specifying a Range of Values as Criteria for a Filter Operation
Using
DATE / TIME Functions
·
Using the DATE Function
·
Using the NOW Function
Using Absolute Cell References
·
Entering an Absolute Column and Absolute Row Cell Reference into a
Formula
Using Financial Functions
·
Using the PMT Function
·
Using the FV Function
Linking Worksheets Within a Workbook
·
Renaming Worksheets in a Workbook
·
Moving the Cell Pointer From One Worksheet to Another
·
Inserting and Deleting Worksheets
·
Entering a Formula to Link Related Worksheets
·
Formatting Multiple Worksheets in One Operation
·
Previewing and Printing Multiple Worksheets in One Operation
Linking Multiple Workbooks
·
Entering a Formula to Link Multiple Workbooks
·
Creating a Workspace
Analyzing
Worksheet Data
·
Creating a PivotTable Report
·
Resetting the Summary Function in a PivotTable Report
·
Creating a PivotChart Report
·
Creating and Displaying a Scenario
·
Using the Analysis ToolPak
·
Using Solver
Controlling the
Worksheet Display
·
Splitting the Workbook Window into Panes
·
Freezing Window Panes
·
Hiding Rows and Columns of a Worksheet
·
Opening a New Workbook Window / Arranging Open Workbook Windows
·
Changing the Zoom Level of a Worksheet
Advanced Data Entry
and Formatting Techniques
·
Restricting Cell Entries to Specific Numbers, Dates or Times
·
Restricting Cell Entries to Specific
Entries in a List
·
Creating a Custom Number Format
·
Applying Conditional Formatting to a Worksheet
Creating a Custom
Workbook Template
·
Creating a New Workbook Template
·
Modifying the Default Workbook Template Style
·
Basing a New Workbook on a Custom Workbook Template
Final
Case Study