|
|
|
Microsoft® Excel for Power Users 1a: Creating & Modifying Worksheets
|
Prerequisites
Basic Windows® skills and working knowledge of Excel.
Course description
Custom Training Course Learn how to be more effective when using Excel. This 1/2 day course is designed to review three major components of the software program in order to help you become more efficient and successful.
Why take this course?
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 and run calculations manually. You now want to save time and move that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.
What you will learn
You will get an overview of Excel, perform tasks with worksheets, and use electronic calculations.
Topics covered include
Getting Started with Excel
- An Overview of Excel
- Navigate Excel
- Select Data
- Enter Data
- Save a Workbook
- Obtain Help
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
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create an Absolute Reference
Follow up courses
|
Course details
Course: S 101
Duration: 1/2 Day
Fee:
| Members: |
|
112.00 |
| Non-Members: |
|
160.00 |
Instructor:
|
|
|
|