Intermediate Spreadsheets
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.
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.
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.
Congratulations!! You have completed the Spreadsheet Intermediate course
Turn in your assignments to the computer lab instructor for your certificate.
Email me: arcon4@frontier.com
If you have a project or would like to see something that is not here, send me an email. I would love to hear from you!!
