1. Toolkit

Information Processing 1060

Toolkit

 

 

The toolkit is a support for you in CTS. In it will be resources to help clarify ideas and support you as you work through your course. Anytime there is a toolkit item for you to access, you will see this icon.

 

All of the support resources in this toolkit will be available at any time as you work through this course. By housing these resources here, you can easily find specific support resources without having to traverse through the course.

 

In this toolkit are the following:

 

Project 1 Instructional Videos

 

Creating a Folder on Your Desktop

Opening Excel for the First Time

Saving a Workbook

Creating and Saving a File

Headers and Footers

Ergonomics Video

 

Project 3 Instructional Videos

 

Training Room 1

 

Key Features of Excel 2007

Accessing Help in Excel 2007

Accessing Microsoft Online

Using the Fill Handle

Formatting Data

Font Color

Splitting Panes

Freezing Panes

Hiding and Unhiding Worksheets

Changing Worksheet Views

Inserting Worksheets

Deleting Worksheets

Moving Worksheets

Copying Worksheets

Templates

 

Training Room 2

 

Deleting Rows and Columns

Inserting Rows and Columns

Converting Text to Columns

Adjusting Column Widths

Adjusting Row Heights

Hide and Unhide Rows and Columns

Aligning Data in Cells

Centering Text Across a Selection of Cells

Merge Cells

Table Themes

Table Styles

Cell Styles

 

Training Room 3

 

AutoSum

Minimum and Maximum

Averages

Subtotals

Dates and Times

COUNT and COUNTA Functions

PMT Function

RATE Function

Present Value

IF Statements

Text Functions

LOOKUP

Lock Cells

 

Training Room 4

 

Charts

Moving Charts

Creating Simple Pie Charts

Resizing Graphics

Sorting

Filtering

 

Training Room 5

 

Protecting Your Workbook

 

Rubrics