Excel
Nancy Slonneger - Technology Integration Specialist

Integrating Technology into Today's Home, Office & Classroom

Home
Services
Personal Info
ROE Classes
Internet
How E-Mail Works
Microsoft Office
Resources
Savvy Searching
Online Safety
Multimedia
Digital Imaging
Class Projects
Scavenger Hunts
Windows
Palm Training
Excel
DVD-Productions

 

Microsoft Excel Tips, Tricks & Help

 

Quickly create weekly column headings in Excel* 

Here's a quick way to make a weekly listing of column headings in adjacent columns. Enter the first date of the series in a cell (we'll say A1). In the cell next to it, enter the formula =A1+7.  Then, place the mouse pointer on the lower-right corner of the second cell until the fill handle appears. Finally, click on the fill handle and drag to produce your row of headings.

Tutorials from the University of Illinois:  

bullet

Getting Started With Excel 97

bullet

Getting Started in Excel 2000

bullet

Excel 2000 Intermediate

Resources

bullet

Excel Basics: Getting Started - covers Excel 
2002, too

bullet

Excel Worksheet Basics

bullet

Excel 2007

More Tutorials

bullet

New Perspectives on Office XP Professional,
Excel Tutorials

bullet

Excel 2002 Support Center

bullet

Excel 2000 tutorial - Icons and shortcuts, selecting, editing, and 
formatting, worksheets and workbooks, working with databases, working with lists and 
range names, printing, customizing toolbars and menus, working with columns, rows 
and cells, performing calculation, creating charts and posting excel files online.

bullet

Excel 2002 I Tutorial - pdf file to download and print (you'll need Adobe Acrobat Reader)

bullet

Excel 2002 III Tutorial - pdf file to download and print (you'll need Adobe Acrobat Reader)

Excel Integration

bullet

Using Excel as a Database

bullet

Data Filters and Spreadsheet Functions - Sun Associates Educational Technology Integration

bullet

Mail Merge with Microsoft WORD & EXCEL

bullet

Mail Merge with Word & Excel XP

bullet

Mail Merge with Word & Excel 2000
bullet

Main Document

bullet

Excel Database

bullet

Mail Merge exercises with Word and Excel
bullet

53Data.xls

bullet

53Ltr.doc

bullet

54Data.xls

bullet

54Ltr.doc

bullet

55Data.xls

Excel Quizzes

bullet

Label the Parts of the Excel Window - You must use Microsoft Internet Explorer version 5.01
or later to access this interactive quiz

bullet

A Short Quiz Over Excel

bullet

Excel Quizzes

More Excel Links:

bullet

Using Excel to Assist in Teaching
Math & Science

bullet

Excel 2000 How To's

bullet

Microsoft in Education - Tutorials

 

Excel Class Files:

bullet

Learning Excel 2000

bullet

Lesson 1, Exercise 2  - XL02

bullet

Lesson 1, Exercise 3  - XL03

bullet

Lesson 1, Exercise 4  - XL04

bullet

Lesson 2, Exercise 7  - XL07

bullet

Lesson 2, Exercise 8  - 08 Inventory

bullet

Lesson 2, Exercise 9  - 09 Deposits

bullet

Lesson 2, Exercise 10 - 10 MOSales

bullet

Lesson 3, Exercise 13 - 13 Loans

bullet

Excel Basics

bullet

Syllabus - Word file

bullet

Excel 2000 CB Training - needs Shockwave to play

bullet

Book - pdf file - you'll need Adobe Reader

bullet

Lesson 1           Income & Expenses

bullet

Lesson 2A        Mileage Reimbursement

bullet

Lesson 2B        Mileage Report

bullet

Lesson 2C

bullet

Lesson 3

bullet

Exercise 7 - pdf    Lesson File - Excel

bullet

Exercise 8 - pdf    Lesson File - Excel

bullet

Gradebook - Word

Home ] Math & Science ]


Copyright © 1999 - 2006 Keyboard Connections
Last modified: May 15, 2008