 |
Workshop Offerings
Client Site Training
One-to-One Tutoring
Custom Course Development
Instructor Bios
|
Microsoft® Office Excel 2007: Basic
(One-day workshop)
Date(s):
The schedule for this workshop is not currently available. Please call nSight Training at 781-273-6300 for more information or fill out our online inquiry form.
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 2007 to manage, edit, and print data. You will create and edit basic Microsoft® Office Excel 2007 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 2007 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.
|
br>
|
|
