Introduction to Excel

Microsoft Excel is a very powerful integrated software program. It combines the three most useful business applications: electronic spreadsheet, business graphics and data management, into one powerful system.

Participants receive an overview of the basic Excel commands to construct a simple spreadsheet. They then cover basic commands for data manipulation, printing and graphics. The course provides a workshop and personal instruction to help design and build an Excel application from the student's own office requirements.

More than 70% of the course is hands-on use of Excel.

• Identify the basic functions of an electronic spreadsheet and understand the functions of Excel;
• Access Excel menus and understand screen prompts and system structure;
• Use Excel commands for:
• worksheet development, manipulation and modification,
• simple formula construction,
• database sort,
• graph preparation, and
• printing;
• Understand how to apply Excel in their own work.

Target Audience: This course is useful for professional, managerial and administrative personnel at all levels. Familiarity with the basics of microcomputer use is recommended.

•Getting Started

•The Excel program

•The workbook environment

•Introduction to Worksheets

•The paper spreadsheet

•Opening a file, Closing a file

•"What if" analysis

•Creating a Basic Worksheet

•Entering and correcting data

•Saving a file

•Working with Ranges

•Selecting and manipulating ranges

•Naming ranges

•Working with long text

•Movement Techniques

•Movement techniques in worksheets

•Introduction to Workbooks

•Using Functions

•Working with functions

•Functions with 3D references

•The Function Wizard

•Moving and Copying Data

•Moving data

•Copying data

•Filling series of data

•Modifying Worksheets

•Editing cell contents

•Absolute references

•Circular references

•Inserting rows and ranges

•Additional Excel Features

•Using Help

•Checking the spelling of a worksheet

•Formatting Techniques

•Formatting cell contents

•Working with dates

•Advanced formatting

•Copying and pasting formats

•Printing a Worksheet

•Using print preview

•Printing the entire worksheet

•Printing specified ranges

•Previewing Charting

•Upgrading to the next version of Excel