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:  

• Getting Started With Excel 97

• Getting Started in Excel 2000

• Excel 2000 Intermediate

Resources

• Excel Basics: Getting Started - covers Excel 
  2002, too

• Excel Worksheet Basics

• Excel 2007

• Excel 2007 Training - Microsoft

More Tutorials

• New Perspectives on Office XP Professional,
  Excel Tutorials

• Excel 2002 Support Center

• 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

• Using Excel as a Database

• Data Filters and Spreadsheet Functions - Sun Associates Educational Technology Integration

• Mail Merge with Microsoft WORD & EXCEL

• Mail Merge with Word & Excel XP

• Mail Merge with Word & Excel 2000

  • Main Document

  • Excel Database

• Mail Merge exercises with Word and Excel

  • 53Data.xls

  • 53Ltr.doc

  • 54Data.xls

  • 54Ltr.doc

  • 55Data.xls

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

• A Short Quiz Over Excel

• Excel Quizzes

More Excel Links:

• Using Excel to Assist in Teaching
  Math & Science

• Excel 2000 How To's

• 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

  • Excel 2000 Book

  • Excel 2002 Book

  • Excel 2003 Book

  • Excel 2007 Book

• Lessons

  • Lesson 1           Income & Expenses

  • Lesson 2A        Mileage Reimbursement

  • Lesson 2B        Mileage Report

  • Lesson 2C

  • Lesson 3

  • Exercise 7 - pdf    Lesson File - Excel

  • Exercise 8 - pdf    Lesson File - Excel

  • Gradebook - Word

• Excel Videos

  • 2000

  • 2002

  • 2003

  • 2007