Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Python
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Getting Started With Excel 2000
This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, E-Mail/Groupware training, Office Suite training, Operating Systems training, Presentations training, Spreadsheets training, Web Browsers training and Word Processing training

Overview

Students will learn basic worksheets skills and how to work with data in worksheets.

Prerequisites

To ensure students' success with this course, we recommend that they first take the following Content courses or have equivalent knowledge:

  • Windows 98 : Introduction
Target Student

Students enrolling in this course should understand how to use Windows 98. 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:

  • Identifying the disadvantages of paper spreadsheets and advantages of electronic spreadsheets by exploring both.
  • Create a basic spreadsheet 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.
  • Save an Excel workbook as a Web page.
What's next

Getting Started with Excel 2000 is the pared-down version of the first course in the Excel 2000 series. Excel 2000: Level 1, the first full-day course in this series, teaches students more about creating worksheets in Excel 2000. Excel 2000: Charting and Organizing Data, the next course in this series, teaches students how to use the charting and list management capabilities in Excel. Students who want to learn advanced features can take Excel 2000: Advanced.

Delivery Method

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

Benefits

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

Course duration

1 Day(s) Course outline

Lesson 1: Excel basics
  • Topic 1A: The paper Spreadsheet
  • Topic 1B: The Excel program
  • Topic 1C: The workbook environment
Lesson 2: Entering data and navigating in a worksheet
  • Topic 2A: Entering and correcting data
  • Topic 2B: Saving a file
  • Topic 2C: Using formulas
  • Topic 2D: Navigation and movement techniques
Lesson 3: Modifying a workbook
  • Topic 3A: Working with ranges
  • Topic 3B: Moving data
  • Topic 3C: Copying data
Lesson 4: Moving and copying data
  • Topic 4A: Inserting rows and ranges
  • Topic 4B: Moving data
  • Topic 4C: Copying data
Lesson 5: Formatting a worksheet
  • Topic 5A: Formatting a worksheet
  • Topic 5B: Number formats and text alignment
Lesson 6: Printing a worksheet
  • Topic 6A: Using the Print Preview command
Lesson 7: Creating Excel Web pages
  • Topic 7A: Using Excel as a Web tool
Hardware/software Requirements

You will need:

  • A486-compatible or faster PC that meets the minimum requirements for Windows 95 or later or Windows NT 4.0 or later (a Pentium 90 with 32 MB or better is recommended.)
  • 500 MB of free hard-disk space (Windows NT only: at least 4 MB of available space in the registry)
  • Either a local CD-ROM drive or access to a networked CD-ROM drive
  • A floppy disk drive
  • A VGA or higher display adapter (The EGA display adapter is not supported)
  • A two button mouse or Intellimouse
  • Printers are not required, however each PC must have an installed printer driver to use Print Preview.
  • Microsoft Windows 95 or later, or Microsoft Windows NT 4.0 Service Pack 3 (or later) installed. A full installation of Microsoft Office 2000 Premium Edition.
  • See your reference manual for hardware considerations that apply to your specific hardware setup.

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved