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:
Resources
Excel Basics: Getting Started - covers Excel
2002, too
Excel 2007 Training - Microsoft
More Tutorials
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.Excel 2002 I Tutorial - pdf file to download and print (you'll need Adobe Acrobat Reader)
Excel 2002 III Tutorial - pdf file to download and print (you'll need Adobe Acrobat Reader)
Excel Integration
Excel 2007: Video - Mail Merge I
Excel 2007: Video - Mail Merge II
Data Filters and Spreadsheet Functions - Sun Associates Educational Technology Integration
Mail Merge exercises with Word and Excel
Excel Quizzes
Label the Parts of the Excel Window - You must use Microsoft Internet Explorer version 5.01
or later to access this interactive quiz
More Excel Links:
Microsoft in Education - Tutorials
Excel Class Files:
Learning Excel 2000
Lesson 1, Exercise 2 - XL02
Lesson 1, Exercise 3 - XL03
Lesson 1, Exercise 4 - XL04
Lesson 2, Exercise 7 - XL07
Lesson 2, Exercise 8 - 08 Inventory
Lesson 2, Exercise 9 - 09 Deposits
Lesson 2, Exercise 10 - 10 MOSales
Lesson 3, Exercise 13 - 13 Loans
Excel Basics
Syllabus - Word file
Excel 2000 CB Training - needs Shockwave to play
Excel 2002 (XP) CB Training - needs Shockwave to play
Books - pdf files - you'll need Adobe Reader
Lessons
Exercise 7 - pdf Lesson File - Excel
Exercise 8 - pdf Lesson File - Excel
Gradebook - Word