Advanced Spreadsheets - Computer Lab

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

In this lesson you will learn:

Integrating Features (OLE)
Macros and the VB IDE
Formula Auditing, Data Validation and Complex Problem Solving
Importing Data from Databases, Files, XML, Pivot Tables and Trend lines
Creating and Formatting Pivot Tables and Pivot Charts

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

NOTE: Textbooks for the older versions work fine for these lessons.

Integration Features

Complete Project 6 page EX 465, which includes:

Linking to Work Processing Documents
Editing Linked Worksheets
Saving Word Processing Datasheet as a Web Page

When completed return to this page and continue.

Using Macros and the Visual Basic IDE

Complete Project 7, which includes:

Recording Macros
Assigning Macros to Toolbars and Menu Commands
Automation of Data Entry
Personalization of Data Entry
Digital Signatures

When completed return to this page and continue.

Auditing, Data Validation and Complex Problem Solving

Complete Project 8, which includes:

Formula Auditing - the Toolbar
Precedents
Data Validation
Solver
Scenario Manager to Analyze Data
Summarizing Scenarios
Creating and Attaching a Toolbar to a Workbook

When completed return to this page and continue.

Importing Data, Working with XML, Pivot Charts, Pivot Tables and Trend lines

Complete Project 9, which includes:

Importing Data from Files, Web Pages and Databases
Preparing Workbooks for Routing
XML Maps
Creating Pivot Tables and Pivot Charts
Comparing and Merging Workbooks
Trend lines
Saving Custom Views
Formatting Worksheet Backgrounds

Congratulations! You have completed the Advanced Spreadsheets course.

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

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