Microsoft Excel 102 Tutorial Outline

1. INTRODUCTION
Objectives
Pre-Requisites

2. USING AUTOFILL, PART ONE
Using AutoFill with series
Months of the year
Days of the week
Sequential dates
Number series
Non-seqential dates
Creating a calendar in Excel
Using the ZOOM drop-down
Zooming in and out
Zoom to selection
AutoFilling backwards (to the left)
###### showing up in your cells
Double-click to auto-resize a column
Highlighting multiple columns
Resizing multiple columns to the same width
Double-click resize multiple columns
Manually entering a column width

3. USING AUTOFILL, PART TWO
Right Click, Format Cells
Changing the format of a date
Two v. Four Digit Years
Using the Format Painter
Format Painter double-click trick
Sticky Format Painter
AutoFilling multiple columns/rows
Inserting a blank row or column
Forcing Excel to format text
Single-quote text formatting
Losing leading zeros (ZIP codes, SSN, etc.)
Align left
Merge and Center Cells
Center Across Columns
Print Preview
Cell Borders
Turning borders on and off
Preset borders
All Borders
No Borders
Thick Outside Border
Resizing rows to the same hight
Changing vertical cell alignment
Top, Center, Bottom vertical alignment

4. SORTING DATA
Setting up a new sheet
Green warning markers
Ignoring Errors
Numbers stored as text
Percent Style
Dealing with decimals and fractions
Increase Decimal
Decrease Decimal
Currency Style
How Excel rounds decimals
Using the AutoSum button
A warning about the AutoSum feature!
Sort Ascending
Sort Descending
Selecting the right cells to sort
Sort Warning
Expand the selection
Continue with the current selection
Accidentally scrambling your data
Recognizing the Key Cell to sort by
Sorting by the left-most cell in a range
Sorting by the right-most cell in a range
Sorting by some column in the middle of your range
Moving the Key Cell with the TAB key
Using Data > Sort
Sorting by up to three fields
The Sort Dialog box

5. CHARTING, PART ONE
Selecting which cells to chart
Selecting non-contiguous ranges with the CTRL key
Getting rid of Clippy, the Office Assistant
Using the Chart Wizard
Selecting a Chart Type and Chart Subtype
Verifying your data range
Entering a chart title
Where to place your chart
Chart as a new sheet
Chart as an object in an existing sheet
Using Format Data Series
Changing the color of your chart columns
Changing the background colors with Format Plot Area
Using Format Axis

6. CHARTING, PART TWO
Creating a 3D Column Chart
Press and Hold to View Sample
Entering a Category (X) Axis Title
Entering a Series (Y) Axis Title
Entering a Value (Z) Axis Title
The Axes tab - turning axis labels on/off
Major and Minor Gridlines
Showing or hiding the Legend
Legend Placement
Using Data Labels
Show Data Table
Show Legend Keys
Hiding the Chart Toolbar
Format Data Point
Changing the format of one specific column
Format Walls
Using a Gradient fill
Fill Effects
Textures
Patterns
Using 3-D View to rotate your chart
Changing elevation, perspective, rotation

7. CHARTING, PART THREE
Creating a pie chart
Category name, percentage data labels
Separating a piece of the pie
Separating all of the pie pieces
3-D View for pie charts
Formatting, moving data labels
Leader lines

8. REVIEW
Review topics