Excel Tutorial Workshops

Microsoft Excel is a spreadsheet program which enables you to set up and maintain budgets, perform financial and scientific analyses, and create graphs. A spreadsheet is a grid of cells arranged into rows and columns. Rows are identified by numbers and columns are identified by letters. A cell can be referred to by its address, which is the column letter followed by the row number, e.g. A1, B5, Q37. Text, numbers, or mathematical formulas can be entered into the cells. Formulas are entered in such a way that changing any of the numbers they reference will automatically update the calculated value. You can also create labels for cells and ranges of cells. Worksheets are grouped into workbooks. You can have a number of spreadsheets stored under the one filename. To access a worksheet, simply click on one of the tabs.

These Excel Tutorial Workshops will teach you how to use this spreadsheet application. Each Excel workshop contains illustrated explanations and examples of the features being taught, followed by detailed learning activities. In the classes taught here you will learn the skills for using and understanding Excel’s features and commands. West Virginia University provides these free computer and software training workshops and materials (pdf format).


Excel Tutorial Workshops

• Excel Basics QuickStart (43kb, 4 pages)
• Activity 1: Explore and Enter Data
• Activity 2: Practicing navigation and data selection techniques
• Activity 3: Formatting your spreadsheet

• Excel Charts QuickStart (59kb, 4 pages)
• Create a Chart
• Resize a Chart
• Edit a Chart
• Drawing Tools

• Introduction to Excel (297kb, 24 pages)
• Activity: Familiarization using a sample spreadsheet
• Customizing Excel
• Entering Information
• Editing Information
• Navigating the Worksheet
• Selecting Columns and Rows
• Activity: Practicing editing and data selection techniques
• Copying and Moving Information
• Functions and Formulas
• Activity: Autosum
• Activity: Formulas
• Formatting the Spreadsheet
• Formatting Numbers
• Activity: Formatting your spreadsheet 
• File Managment
• Printing a File
• Charts
• Data Arrangement
• Selecting, Moving, Resizing, and Editing Charts
• Introduction to Excel workbook file [.xls]

• Excel Data Management (285kb, 24 pages)
• Managing Workbooks and Worksheets
• Manage Multiple Worksheets within a Workbook
• Freezing Worksheets
• Linking Data
• AutoFill
• Data Validation
• Protecting portion of worksheet from modification
• Create a data entry form
• Import Data
• Export Data
• Using Excel worksheet as data for Word Mail Merge
• Sorting Data
• Filtering Data
• Pivot Tables
• Excel Data Mgt workbook file [.xls]
• data.txt
• delimit.txt

• Advanced Excel: Calculations and Customization (304kb, 21 pages)
  The Advanced Excel workshop is designed to illustrate techniques which enhance the functionality of spreadsheets. These include:
  • Formulas and built-in functions
  • Consolidation and Analysis of Data
  • Interactive documents
  • Customizing the worksheet’s display, its tools, and its printing
• Functions and Formulas
• Formulas
• Functions: Examples
• Advanced Business Analysis
• Goal Seek
• Formatting Worksheet Appearance
• AutoFormat
• Custom Formatting
• Cell Background Color
• Clearing Cell Formatting
• Screen Display Options
• Freezing, Unfreezing and Splitting Worksheets
• Using Comment Boxes
• Customizing Excel
• Environment Options
• AutoCorrect Options
• Toolbars
• Printing Options
• Page Setup
• Page Breaks
• Interactive Web Documents
• Interactive Excel Web Document
• Interactive Web Page
• Excel Calculations workbook file [.xls]

Popularity: 7% [?]