WebJunction

Description:

Microsoft Excel is probably one of the most versatile and powerful programs you can have on your desktop. Having a basic understanding of the software can save you hours of time and make record-keeping a much simpler process.

This basic course will help the new user understand and navigate Excel. It will demonstrate how to use the software's powerful built-in functions. It will show how to use formatting techniques to make data stand out. It will teach how to use charts, sorting and filtering, and much more, in order to get the most out of your data. It will also show how you can use Excel to import data into an Access database.

In this tutorial you will be guided step-by-step as you design, build and format a simple spreadsheet.

The course covers Excel basics, with a special section on Excel 2007 and illustrations on how Excel 2007 differs from earlier versions.

Objectives

This course will help you develop the skills necessary to build, maintain, and present a basic spreadsheet. Following this course, participants will be able to:

• Describe the basic functions of spreadsheet software and define basic terms
• Identify the various parts and functions of Excel spreadsheet software
• Store data in an Excel spreadsheet and move around efficiently in a spreadsheet
• Edit and format data in a spreadsheet
• Sort and filter data
• Use formulas and functions to calculate values
• Create charts and graphs
• Use Excel to load info

NOTE: After you enroll, you will receive an additional email with special LE@D login information within 3 business days. If you do not receive the message, please email courses@webjunction.org. After completing the course, click the Launch button on your My Courses page and follow the instructions to record completion.