On the Trails

Intermediate Skills
Using Templates

Create templates
Edit templates
Create new workbooks based on
User-defined templates
Modify Workbook properties
Change Default Templates & modify template settings

Working with Ranges

Create Named Ranges
Use named ranges in Formulas
Use Lookup Functions
Create & Modify List Ranges

Formatting Cells

Create & Apply Custom Number Formats
Apply conditional formatting
Add data validation criteria to cells

Importing & Exporting Data

Import Data from Text Files
Export Data to Other [...]

Beginning Skills | Advanced Skills

Customizing Workbooks

Rename Worksheets
Change worksheet tab colors
Select and move sets of Worksheet
Copy worksheets
Insert & Delete Worksheets
Hide & Unhide Worksheets
Use Save As
Renaming Folders while Saving

Using Lists

Learn about database features
Find & Replace Cell Contents
Freeze & Unfreeze Rows
Freeze & Unfreeze Columns
Hide & Unhide Rows & Columns
Sort lists in Descending Order
Sort lists in Ascending Order
Understand [...]

Intermediate Skills

Getting started with excel

The excel window
Viewing worksheets
Go to specific cells
Save workbooks in new folders
Close workbooks

Working with Cells, Rows, and Columns

Use the Task Pane to create Workbooks
Enter cell content
Edit cell content
Check spelling
Insert & Delete cells
Merge & split cells
Insert & delete columns & rows (columns are inserted to the left, rows above selection)
Modify column width & [...]