Intermediate Spreadsheets - Computer Lab

In this lesson you will learn:

Financial Functions, Data Tables, Amortization Schedules and Hyperlinks
Creating , Sorting and Querying a List
Creating Templates and Working with Multiple Worksheets and Workbooks

Use the Shelley Cashman Book for Microsoft Excel, Comprehensive Concepts and Techniques to complete this section. It is in the Black file cabinet in the front of the room.

Financial Functions, Data Tables, Amortization and Hyperlinks

Complete Project 4, which includes;

Custom Borders and Backgrounds
Cell Names Based on Row Titles
Data Table to Analyze Worksheet Data
Adding Pointers to Data
Creating Amortization Schedules
Adding Hyperlinks
Printing Worksheet Sections
Protecting a Worksheet
Formula Checking

When completed return to this page and continue.

Creating, sorting and Querying a list

Complete Project 5, which includes:

Creating a list
Data Validation
Adding New Fields
Lists
Zooming
Data Forms - Finding Records
Querying a list
Using Criteria on a Range of Cells
Extracting Records
Criteria Ranges

When completed return to this page and continue.

Using Templates and Working with Multiple Worksheets and Workbooks

Complete Project 6, which includes:

Creating Templates
Column Titles
Formatting Templates
Creating Workbooks from a Template
Working with Multiple Workbooks
Working with Multiple Worksheets - Referencing Cells
Drawing 3_D Cylinder Charts
Comments in Cells
Headers and Margins
Printing Non-adjacent Worksheets
Find and Replace
Updating Links

When completed return to this page and continue.

Congratulations! You have completed the Spreadsheet Intermediate course

Turn in your assignments to the Computer Lab instructor for your certificate.

NOTE: These are posted for student and staff educational & class use.

<<= Back Intermediate Spreadsheets - Basic Classes Next =>>

In this lesson you will learn:

Financial Functions, Data Tables, Amortization and Hyperlinks

Creating, sorting and Querying a list

Using Templates and Working with Multiple Worksheets and Workbooks