This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview
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.
