Logo   Contact
Excel Level 2
 
Course Description    
Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel.  
Course Content Prerequisites

OCR
Cisco
Sage
COmTIA
BCS
ECDL
MCP

Lesson 1: Creating Charts
Creating a Chart Sheet
Creating an Embedded Chart
Comparing Chart Sheets with Embedded Charts
Lesson 2: Modifying Charts
Chart Types
Modifying Embedded Charts
Adding and Deleting Chart Items
Moving and Sizing Chart Items
Lesson 3: Formatting a Chart
Formatting Chart Text
Formatting Labels
Formatting the Chart
Printing a Chart Sheet
Lesson 4: Using Graphic Objects
Adding Graphic Objects
Formatting Graphic Objects
Using Graphic Objects to Enhance Worksheets and Charts
Lesson 5: Sorting Data
Single-level Sorting
Multiple-level Sorting
Sorting Options
Importing Data
Design Considerations
Lesson 6: Filtering Data
Filtering a List Custom Criteria
Multiple-condition Criteria
Managing a Filtered List
Excel Level 1
or equivalent knowledge.
Course Duration
7.5 hours
Study Methods Available
aIndividual Tuition
aGroup Training
x Distance Learning
Follow-on Courses
Excel Level 3
All Courses
Click here to see all our courses