Microsoft Excel

Northeast Technical Institute
Hermon, Scarborough, Maine, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Microsoft Excel is a powerful spreadsheet program. The help system and many intuitive features make Excel easy to learn and use. This course presents introductory techniques for creating, formatting, and printing worksheets, using functions, and creating charts.

PREREQUISITES

Windows 98: Introduction, or equivalent knowledge.

BENEFITS

Students will learn how to use an electronic spreadsheet to create basic data reports.

CERTIFICATION

This courses will help prepare students to take the following Certification:

(MOS) Microsoft Office Specialist
PERFORMANCE BASED OBJECTIVES

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.

Create a basic worksheet by entering text, values, and formulas.

Create formulas by using Excel’s built-in functions.

Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.

Change the appearance of worksheet data by using a variety of formatting techniques.

Prepare a document for printing by using the spell checking feature and a variety of printing options.

Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.

Save an Excel workbook as a Web page
COURSE OUTLINE

Excel basics

The paper spreadsheet The Excel program
The workbook environment

Entering data and navigating in a worksheet

Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques

Modifying a workbook

Working with ranges
Working with functions
Editing cell contents
Moving and copying data

Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature

Formatting a worksheet

Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Printing a worksheet

Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options

Introduction to the workbook environment

Using a multiple-sheet workbook
Creating a chart
Outlining Spreadsheet Solutions
Creating Excel Web pages

Using Excel as a Web tool
CERTIFICATION:

This courses will help prepare students to take the following Certification:

Microsoft Excel (Core Certification) - Microsoft Office Specialist
...''

Phone:(800) 447-1151

School Address:

Northeast Technical Institute
51 US Route 1, Suite K
Scarborough, ME 04074

Northeast Technical Institute
19 White Pine Road
Hermon, ME 04401

Northeast Technical Institute
191 Merrimack Street, Suite 701
Haverhill, MA 01830

Northeast Technical Institute
in partnership with Allied CS
55 Hampshire Road
Methuen, MA 01844

Jobs & Resumes: Hermon, Scarborough
Houses & Roommates: Hermon, Scarborough

Software Administration (MCAD)
Web Master (w/3D Animation)
Database Administrator (MCDBA)
Truck Driving
Bartending/Mixology
Bar and Beverage Management
Basic Bartending
Business Administration
Legal Transcription
Microsoft Access
Microsoft FrontPage
Microsoft PowerPoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Windows XP
QuickBooks
Crystal Reports

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.