|
Microsoft® Office Excel 2003: Basic
(One-day workshop)
Date(s):
Aug 7
Instructor(s): TBA
Description
You have basic computer skills such as using a mouse, navigating through Windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data. You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.
Intended Audience
This course is designed for a person preparing for certification as a Microsoft® Office Specialist in Excel, who already has knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desires to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.
Topics Include:
- Lesson 1: Getting Started with Excel
- An Overview of Excel
- Navigate in Excel
- Select Data
- Enter Data
- Save a Workbook
- Obtain Help
- Lesson 2: Modifying a Worksheet
- Move and Copy Data between Cells
- Fill Cells with Series of Data
- Edit Cell Data
- Insert and Delete Cells, Columns, and Rows
- Find, Replace, and Go To Cell Data
- Spell Check a Worksheet
- Lesson 3: Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create an Absolute Reference
- Lesson 4: Formatting a Worksheet
- Change Font Size and Type
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Create a Custom Number Format
- Align Cell Contents
- Find and Replace Formats
- Apply an AutoFormat
- Apply Styles
- Lesson 5: Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Copy a Workbook
- Lesson 6: Printing Workbook Contents
- Set a Print Title
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Insert and Remove Page Breaks
- Print a Range
- Lesson 7: Customizing Layout
- Split a Worksheet
- Arrange Worksheets
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
To learn more about nSight training programs and for assistance, please contact our Training department at 781-273-6300 or Training@nSightWorks.com.
|
Download Fall 2007 Workshop Schedule
nSight is a Certified Provider member of the International Association for Continuing Education and Training (IACET)—a nonprofit association dedicated to quality continuing education and training programs. nSight is certified to offer continuing education credits (CEUs) to students who successfully complete its training workshops. One (1) CEU is equal to ten (10) contact hours. Learn more at 
