This course is for the new user of Excel and assumes no experience with workbooks. In this course you learn the basic skills to create, edit, format, print basic worksheets and learn to create formulas and use basic functions

Prerequisites

A knowledge of personal computer fundamentals, experience in working within the Microsoft Windows environment, a reasonable degree of keyboard proficiency and experience in using a mouse.

---

Objectives

After completing this course, students will be able to:

• Start Excel
• Use the Excel menu system, toolbars and task panes
• Display help information
• Reset the working folder
• Open and close a workbook
• Enter labels and values into a worksheet
• Enter a formula into a worksheet
• Adjust column width and row height in a worksheet
• Print a worksheet
• Open a new workbook
• Use the Spelling Checker

• Automatically fill a range

• Copy and move cells

• Automatically compute a row or column total

• Insert and delete rows and columns

• Realign cell entries

• Reset font options for cell entries

• Reset the number format of cell entries

• Add borders and shading to a worksheet

• Change the page setup for a worksheet

• Preview a worksheet

• Insert a manual page break into a worksheet

• Print selected worksheet entries

• Use Excel functions (SUM, AVERAGE, MAX, MIN and COUNT)

---

Course Materials

The courseware (book) and student data files are included with the class. The courseware is Microsoft Approved Courseware. The courseware has been reviewed and approved to satisfy Microsoft Office Specialist certification exam standards.

[Part 1]  [Part 2]  [Part 3]  [Part 4]

Top of Page