On the Trails

Intermediate Skills

Getting started with excel

1. The excel window
2. Viewing worksheets
3. Go to specific cells
4. Save workbooks in new folders
5. Close workbooks

Working with Cells, Rows, and Columns

1. Use the Task Pane to create Workbooks
2. Enter cell content
3. Edit cell content
4. Check spelling
5. Insert & Delete cells
6. Merge & split cells
7. Insert & delete columns & rows (columns are inserted to the left, rows above selection)
8. Modify column width & row height

Moving & Copying Data

1. Look at the clipboard task pane
2. Examine cut, copy & paste
3. Use paste special
4. Move cells and ranges
5. Understand fills
6. Fill a series
7. Fill by example

Exploring Cell References & Formulas

1. Understand Formulas
2. Understand Cell References
3. Use cell references in formulas
4. Enter a formula in the formula bar
5. Copy & edit formulas

Exploring Functions

1. Understand Functions
2. Build functions
3. Look at function argument ScreenTips
4. Use AutoSum & AutoCalculate
5. Insert Sums Using the Insert Function
6. Calculate Averages Using the Insert Func.
7. Create Minimum Functions
8. Create Maximum Functions

Formatting Cells & Cell Contents

1. Understand date & number Formatting
2. Format Numbers
3. Change text alignment
4. Wrap text within cells
5. Modify Text Appearance
6. Apply shading
7. Format Painter
8. Use border Drawing

Working with Charts

1. Examine Charts
2. Use the Chart Wizard
3. Change chart types
4. Elevate, Rotate, Resize & Position Charts
5. Edit and Resize chart titles

Exploring Printing

1. Understand Printing
2. Preview Worksheets
3. Change Page Orientation & Scaling
4. Set page margins and alignment
5. Create headers and footers
6. Select print options
7. Set Print, and Clear Print Areas
8. Print Selections
9. Print Worksheets and Workbooks

Technorati Tags: OfficeSkills, Excel, spreadsheets, onthetrail

Powered by ScribeFire.