CGTC Home
Economic Development
About Economic Development
Meeting Facilities
Campus & Street Map
Mission Statement
Contact Us
Business and Industry
About Business and Industry
QuickStart
Retraining Tax Credits
WorkKeys
Customized Training
Certification
Facilities
Request Information
Computer Training Center
About the Computer Training Center
Schedule of Classes
Class Descriptions
Register Online
Facilities
Request Information
Continuing Education
About Continuing Education
Schedule
Class Descriptions
Register Online
Facilities
Request Information
Site Map
Computer Training Center
Imagine the Possibilities - Economic Development
CGTC Home >> Economic Development >> Computer Training Center >> Class Descriptions >> Excel 2000/97
Level 1

Excel 2000/97 Level 1

Prerequisites: Windows Level 1, or equivalent knowledge

In Excel 2000/97, Level 1, students get started with Excel, create, modify, print, and format worksheets, work with basic formulas and functions, use multiple worksheets, enhance worksheets, use styles and AutoFormats, and work with charts.

Register Online

Getting Started with Excel 2000
Exploring Spreadsheet Uses
Defining Workbooks/Worksheets
Starting Excel
Using the Office Assistant
Creating Worksheets
Creating New Workbooks
Using the AutoComplete Feature
Saving and Closing New Workbooks
Modifying Worksheets
Opening Existing Workbooks
Copying Worksheet Data
Moving Worksheet Data
Cutting and Pasting Data
Deleting Data and Reversing Actions
Saving Existing Workbooks
Formatting Worksheets
Inserting and Deleting Rows and Columns
Changing Column Widths/Row Heights
Using Numeric Formats
Changing the Alignment of Data
Using Conditional Formatting
Printing Worksheets
Previewing Print Jobs
Using Page Break Preview
Defining Page Setup Options
Creating Headers and Footers
Printing Worksheets
Formulas and Functions
Using Formulas
Creating Formulas
Editing Formulas
Using Relative Cell References
Using Absolute Cell References
Using Mixed Cell References
Using Functions
Using AutoSum
Using AutoCalculate
Using Multiple Worksheets
Working with Multiple Worksheets
Moving Between Worksheets
Inserting and Deleting Worksheets
Moving and Copying Data Between Worksheets
Grouping Worksheets
Creating 3-Dimensional Formulas
Renaming Worksheets
Enhancing Worksheets
Enhancing Text
Changing Text and Font Attributes
Adding and Modifying Borders
Creating and Modifying 3-Dimensional Objects
Using Styles and AutoFormats
Using Styles
Creating Styles
Formatting Cells with Styles
Modifying and Deleting Styles
Using AutoFormats
Working with Charts
Creating Charts
Formatting Charts
Modifying Charts
Resizing and Moving Charts
Editing Chart Data
Placing and Modifying Data Tables in Charts
Printing Charts

 

 


Accreditation | Non-Discriminatory Statement | Contact Webmaster

CGTC Home | College Profile | Academics | Apply to CGTC | Student Services | Faculty and Staff | News & Information | Economic Development | Campuses | Site Map | Faculty WebMail | Search
Central Georgia Technical College, A Unit of the Technical College System of Georgia