Training Course:Excel 2007School/Trainer:New Horizons Computer Learning Center - Albany
Albany, NY, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks.
Who Should Attend:
This course is designed for people preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
At Course Completion:
Upon successful completion of this course, students will be able to: - explore the Excel 2007 environment. - work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet. - modify a worksheet. - perform calculations. - format a worksheet. - develop a workbook. - print workbook contents. - customize the layout of the Excel application window.
Pre-requisite(s):
Windows XP (New Version) - Level 1
Outline: Top
Lesson 1: Exploring the Excel Environment
Explore the User Interface
Explore the Ribbon
Obtain Help
Customize the Quick Access Toolbar
Top
Lesson 2: Working with an Excel Worksheet
Navigate in Excel
Select and Enter Data
Save a Workbook
Lesson 3: Modifying a Worksheet
Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet
Lesson 4: Performing Calculations
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create a Mixed Reference
Lesson 5: Formatting Worksheets
Convert Text to Columns
Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Align Cell Contents
Find and Replace Formats
Apply AutoFormat
Apply Cell Styles
Apply Themes
Top
Lesson 6: Developing a Workbook
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Lesson 7: Printing Workbook Contents
Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Set Page Breaks
Print a Range
Lesson 8: Customizing Layout
Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets
...''
Please go to the school's official website for training price and schedule:
http://www.newhorizons.com
Phone:518-452-6444
School Address:
New Horizons Computer Learning Center
10 Airline DriveSuite 101
Albany,NY 12205
USA
Jobs & Resumes: Albany
Houses & Roommates: Albany
Other training courses offered by New Horizons Computer Learning Center - Albany:
Internet Information Services 6.0
Flash
SUSE Linux Administration
GroupWise 7.0 Administration
Word 2007
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent. |
|
|
