Introduction to Microsoft Excel

Day or Evening Class

 

Overview

Microsoft Excel is a powerful, spreadsheet application that is used to analyze and share data. The Introduction to Microsoft Excel Class will teach students the basics of spreadsheet design, use various formulas and functions and work with basic worksheet techniques.

 

Prerequisite

Students should have a basic understanding of using Windows operating system. Not required but recommend taking Computer Literacy and Introduction to Microsoft Word.

 

Outline

 

            1. Exploring the Excel Screen

 

                A. Menus and Toolbars

                B. Worksheets

 

            2. Basic Workbook Skills

            A. Selecting cells

            B. Workbooks

            C. Enter and edit data

            3. Formatting Numbers and Text

            A. Numbers

            B. Text

            C. Ranges

            4. Formatting Cells

            A. Alignment

            B. Borders

            C. Insert and delete cells

            5. Working with Columns and Rows

 

            6. Simple Formulas

            A. Formulas

            B. AutoSum

            C. Basic functions

            7. Copy and Move Data

            A. Fixing mistakes

            B. Copy and Paste

            8. Page Setup and Printing

            A. Setting margins

            B. Gridlines

            C. Print preview

            9. Managing Files

                A. Properties

                B. Searching for files