You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.
Course Objectives
You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.
Prerequisites
This course is designed for students with basic computer skills.
Target Student
This course is targeted for a person who seeks ECDL certification.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- create a basic worksheet.
- edit data, copy or move data, find and replace data, and
fill series of data and sort them.
- insert and delete columns and rows, freeze and unfreeze
rows and columns, and change the column width and row height.
- manage worksheets in the workbooks.
- perform calculations.
- format a worksheet.
- create and modify charts.
- print workbooks.
Certification
The European Computer Driving License Foundation (ECDL) — Syllabus 4
Delivery Method
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities
Course duration
1 Day(s)
Course outline
Lesson 1: Getting Started with Excel
- Topic 1A: Explore the Excel Window
- Topic 1B: Select Data
- Topic 1C: Insert and Delete Data
- Topic 1D: Save a Workbook
- Topic 1E: Work with Multiple Workbooks
- Topic 1F: Use the Help Feature
- Topic 1G: Change the Excel Window Layout
- Topic 1H: Change the Excel Settings
Lesson 2: Manipulating Data
- Topic 2A: Edit Data
- Topic 2B: Copy and Move Data Between Cells
- Topic 2C: Copy and Move Data Between Worksheets
- Topic 2D: Copy and Move Data Between Workbooks
- Topic 2E: Fill Series of Data
- Topic 2F: Find and Replace Data
- Topic 2G: Sort Data
Lesson 3: Modifying a Worksheet's Layout
- Topic 3A: Insert and Delete Columns and Rows
- Topic 3B: Freeze and Unfreeze Columns and Rows
- Topic 3C: Change Column Width and Row Height
Lesson 4: Managing Worksheets
- Topic 4A: Manipulate Worksheets
- Topic 4B: Copy and Move Worksheets Within Workbooks
- Topic 4C: Copy and Move Worksheets Across Workbooks
Lesson 5: Calculating Data
- Topic 5A: Create Basic Formulas
- Topic 5B: Calculate Data Using Functions
- Topic 5C: Calculate with Logical Functions
- Topic 5D: Create Relative Cell References
- Topic 5E: Create Absolute Cell References
- Topic 5F: Create Mixed Cell References
Lesson 6: Formatting a Worksheet
- Topic 6A: Change Font Type, Size, and Style
- Topic 6B: Apply Borders and Shading
- Topic 6C: Merge Cells
- Topic 6D: Format Numeric Data
- Topic 6E: Align Cell Contents
Lesson 7: Creating and Modifying Charts
- Topic 7A: Create a Chart
- Topic 7B: Format Chart Items
- Topic 7C: Change the Chart Type
- Topic 7D: Copy and Move Charts
Lesson 8: Printing a Workbook
- Topic 8A: Preview a Worksheet
- Topic 8B: Change Sheet Layout
- Topic 8C: Create and Modify Headers and Footers
- Topic 8D: Set Page Margins
- Topic 8E: Set Page Layout
- Topic 8F: Print a Workbook
Platform Requirements
Hardware Requirements
For this course, you will need one computer for each student
and one for the instructor. Each computer will need the following minimum
hardware components:
- A 300 MHz Pentium-class processor if you use Microsoft®
Office Windows XP Professional as your operating system. 500 MHz is recommended.
- A 233 MHz Pentium-class processor if you use Microsoft®
Office Windows 2000 Professional as your operating system.
- 256 MB of RAM.
- A 6 GB hard disk or larger.
- A floppy disk drive.
- A mouse or other pointing device.
- An 800 x 600 resolution monitor.
- Network cards and cabling for local network access.
- Internet access (see your local network administrator).
- A printer (optional).
- A projection system to display the instructor's computer screen.
Software Requirements
- Either Windows XP Professional with Service Pack 1, or Windows
2000 Professional with Service Pack 4.
- Microsoft® Office Professional Edition 2003.
