HOME | SITEMAP | COMMENTS

Uncle Jim's Web Designs
Development Tools for the Internet and Your Computer


Microsoft Excel Tutorial

 

 
Introduction & Table of Contents

Begin the Tutorial >>


This tutorial is designed for users of all experience and proficiencies. Using instructional diagrams, we will take you step-by-step through the various methods for creating and using using Microsoft© Excel Workbooks. You may begin by selecting the above link or you can skip to any section below by selecting the category title.



Spreadsheet Basics

  • Screen elements
  • Adding and renaming worksheets
  • The standard toolbar - opening, closing, saving, and more.

Customizing Excel

  • Menus
  • Customize toolbars
  • Recording a macro
  • Running a macro

Modifying A Worksheet

  • Moving through cells
  • Adding worksheets, rows, and columns
  • Resizing rows and columns
  • Selecting cells
  • Moving and copying cells
  • Freeze panes

Formatting Cells

  • Formatting toolbar
  • Format Cells dialog box
  • Dates and times
  • Styles
  • Style dialog box
  • Create a new style
  • Format Painter
  • AutoFormat

Formulas and Functions

  • Formulas
  • Linking worksheets
  • Relative, absolute, and mixed referencing
  • Basic functions
  • Function Wizard
  • Autosum
  

Sorting and Filling

  • Basic ascending and descending sorts
  • Complex sorts
  • Autofill
  • Alternating text and numbers with Autofill
  • Autofilling functions

Graphics

  • Adding clip art
  • Add an image from a file
  • Editing a graphic
  • AutoShapes

Charts

  • Chart Wizard
  • Resizing a chart
  • Moving a chart
  • Chart formatting toolbar
  • Copy a chart to Microsoft Word

Page Properties and Printing

  • Page breaks
  • Page orientation
  • Margins
  • Headers, footers, and page numbers
  • Print Preview
  • Print

Keyboard Shortcuts