Excel - Level 2
Overview: In this course, students will gain the skills needed to
create and use templates, sort and filter data, import and export data,
analyze data and collaborate on the web.
Prerequisites: Windows 95: Introduction, Windows 98: Introduction,
Excel Level 1
Table of Contents
LESSON 1: Working with Templates
· Create a Template
· Create a Workbook from a Template
LESSON 2: Sorting and Filtering Data
· Sort Data
· Subtotals Command
· Filter lists
· Custom Filters
LESSON 3: Importing and Exporting
· Import Data from Web
· Import Data from External Sources
· Export Data
· Save as a Web Page
LESSON 4: Working with Advanced Formulas
· Sharing Data
· Named Ranges
· Advanced Functions
· Worksheet Auditing Tools
LESSON 5: Analyzing Data
· Pivot Tables & Reports
· Scenarios
· Solver & Goal Seek
LESSON 6: Collaborating
· Hyperlinks
· Comments