Spreadsheet Tools@2Learn.ca

TUTORIALS

The best way to escape from a problem is to solve it.

~ Alan Saporta ~

reflections outcomes How to exemplars extras about

bulletAppleWorks bulletMicrosoft Excel

AppleWorks bullet Spreadsheet - Topics covered apply to AppleWorks spreadsheets:
  • Introduction
  • A brief description of the spreadsheet environment.
  • Anatomy of a Spreadsheet
  • Learn about the different parts of a spreadsheet.
  • Create a Spreadsheet
  • Learn to create a new spreadsheet document.
  • Enter Data
  • Learn how to enter data into your spreadsheet.
  • Selecting a Cell
  • Learn how to select a single cell or a range of cells.
  • Number Format
  • Learn how to change the format of numbers, dates and times in a spreadsheet.
  • Sorting Cell Data
  • Learn to sort data in a spreadsheet.
  • Formulas
  • Learn how to add functionality to your spreadsheet by adding formulas to complete calculations.
  • Types of Formulas

http://www.uen.org/utahlink/tours/tourViewCategory.cgi?category_id=18613&tour_id=13811

bullet Math Forum: Suzanne Alejandre: Spreadsheet Lessons, Graphs - Bar Graphs (How To Make a Bar Graph, Changing Fonts and Colors), Pie Charts, (How To Make a Pie Chart, Changing Fonts and Colors), Pictograms, (Changing Graphics, Changing Icons to Picts, How To Use Web Graphics, Suggested Sites to Download Icons), Other Graphs, (How To Make a Graph, Graphing Linear Functions, Graphing Polynomial Functions, Graphing Exponential Functions).

http://mathforum.org/alejandre/spreadsheet.html

bullet Electronic Spreadsheets - A tutorial that introduces spreadsheets in instructional design and practise using ClarisWorks 1.0:
  • Advantages and benefits of spreadsheets
  • Instructions for completing an example spreadsheet
  • Adminstrative uses for spreadsheets
  • Instructional uses for spreadsheets
  • WWW Resources for Spreadsheets

http://www.uwf.edu/~coe/tutorials/technolo/spreadsh/spreadsh.htm

Microsoft Excel bullet FunctionX:  Microsoft Excel Tutorials - Lessons, examples, exercises, samples, and more.

Lesson topics include:

  • MS Excel Interface
  • Lists and Worksheet
  • Printing
  • Data Entry
  • Introduction to Cells Formatting
  • Formatting Cells Contents
  • Style and Conditional Formatting
  • Graphics And Drawing
  • Operators and Operands
  • Introduction to Functions
  • Series and Business Functions
  • Financial Functions
  • Date and Time Functions
  • Logical Functions
  • Charts

http://www.functionx.com/excel/index.htm

bullet Florida Gulf Coast University, Online Tutorials: Excel 2000 - Includes the following sections:  Spreadsheet Basics, Customizing Excel, Modifying A Worksheet, Formatting Cells, Formulas and Functions, Sorting and Filling, Graphics, Charts, Page Properties and Printing, and Keyboard Shortcuts.

http://www.fgcu.edu/support/office2000/excel/index.html

bullet Microsoft Excel 97 Spreadsheet - This tutorial introduces some of the techniques associated with spreadsheet programming, using Microsoft Excel 97 under Windows 95.
  • A Simple Spreadsheet Model
  • Building the Spreadsheet
  • Entering Numeric Data
  • Entering Double-height Headings
  • Entering Formulae
  • Duplicating Groups of Cells
  • "What if" Testing

http://www.fbe.unsw.edu.au/Learning/Excel97/

bullet Excel Tips
  • Quick Click Movement
  • Social Security Format
  • Shortcut Keys
  • Get attentioin with exploding charts (Version 7.0)
  • Bring Excel Data into Access (versions 7.0 & 97)
  • Automatic Range Names Used in Formulas
  • You Gotta Have Art (all versions)
  • Jump Around in Print (all versions)
  • Insert An Auto Sum (version 97)
  • Breaking up is hard to do (all versions)
  • Set the print area quickly at the click of a button (versions 5.0,7.0 & Mac)
  • Automatically display page breaks (all versions)
  • Save yourself a lot of time and trouble (all versions)
  • Quick Highlighting tips (version 7.0)
  • Get on the Grid (version 7.0)
  • Using Shortcut Keys (version 97)

http://www.engr.psu.edu/www/trg/TIPS/Tip-excl.htm

bullet Excel Tutorial
  • Topic One: What is Excel?
  • Topic Two: Getting Started
  • Topic Three: Creating a Simple Workbook
  • Topic Four: Writing Formulas Using Operators and Functions
  • Topic Five: Formatting The Appearance of a Workbook
  • Topic Six: Advanced Excel (Copying Cells)
  • Topic Seven: Linking Documents in ExcelTopic Eight: Creating Charts

http://einstein.cs.uri.edu/tutorials/csc101/pc/excel97/excel.html

bullet Western Carolina University - Microsoft Excel - "contains tutorials on how to use many of the basic features found in Microsoft Excel."  This is a comprehensive resource.

http://www.wcu.edu/ccenter_inf/CatOnline/MSEX/index.html

bullet A Quick Tutorial to Microsoft Excel

This tutorial, created by an Alberta teacher, provides an excellent introduction to Microsoft Excel for teachers.

http://www.compusmart.ab.ca/alummis/excel/exceltutorial.html

reflections outcomes How to exemplars extras about

| Teacher Tools - Overview | Spreadsheet Tools - Menu |

line