On the Trails

Beginning Skills | Advanced Skills

Customizing Workbooks

1. Rename Worksheets
2. Change worksheet tab colors
3. Select and move sets of Worksheet
4. Copy worksheets
5. Insert & Delete Worksheets
6. Hide & Unhide Worksheets
7. Use Save As
8. Renaming Folders while Saving

Using Lists

1. Learn about database features
2. Find & Replace Cell Contents
3. Freeze & Unfreeze Rows
4. Freeze & Unfreeze Columns
5. Hide & Unhide Rows & Columns
6. Sort lists in Descending Order
7. Sort lists in Ascending Order
8. Understand Filters
9. Use Autofilter

Working with Functions

1. Understand Inserting Functions
2. Explore Logical Functions
3. Use the IF Function
4. Use the OR Function
5. Learn about Financial Functions
6. Use the FV Function
7. Use the PMT Function
8. Use the NOW Function

Formatting Worksheets

1. Understand Autoformatting
2. Apply AutoFormats
3. Modify AutoFormats
4. Define Styles
5. Apply & Remove Styles
6. Indent Text
7. Rotate text
8. Insert & Preview Page Breaks
9. Modify & Remove Page Breaks
10. Find & Replace Cell Formats

Working with Objects

1. Understand Inserting Objects
2. Insert Graphics
3. Move & Delete Graphics
4. Create & modify graphics
5. Add comments
6. Edit & remove comments

Using 3-D References

1. Understand 3-D references
2. Link worksheets using 3-D refs
3. Split (into panes)and arrange workbooks (see more than 1)
4. Link Workbooks using 3-D references

Using Spreadsheets with the Web

1. Understand Hyperlinks
2. Create & edit hyperlinks
3. Use web page preview
4. Save worksheets as web pages
5. Save workbooks as web pages
6. Insert supporting info into worksheets

Using Templates

1. Explore Templates
2. Create workbooks based on templates
3. Create new templates