Microsoft Excel 2007

Complete Computing Inc.
Little Rock, Arkansas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course 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.

Course Objective: You will create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks
.
Target Student: 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.

Prerequisites: To effectively understand this course, we recommend that you take the Microsoft Office Windows XP Introduction course offered by Element K or have equivalent knowledge.

Certification

This course is one of a series of titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.


Performance-Based Objectives
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.
Course Content
Lesson 1: Exploring the Excel Environment

Topic 1A: Explore the User Interface

Topic 1B: Explore the Ribbon

Topic 1C: Obtain Help

Topic 1D: Customize the Quick Access Toolbar


Lesson 2: Working with an Excel Worksheet

Topic 2A: Navigate in Excel

Topic 2B: Select and Enter Data

Topic 2C: Save a Workbook


Lesson 3: Modifying a Worksheet

Topic 3A: Manipulate Data

Topic 3B: Insert and Delete Cells, Columns, and Rows

Topic 3C: Search for Data in a Worksheet

Topic 3D: Spell Check a Worksheet


Lesson 4: Performing Calculations

Topic 4A: Create Basic Formulas

Topic 4B: Calculate with Functions

Topic 4C: Copy Formulas and Functions

Topic 4D: Create a Mixed Reference


Lesson 5: Formatting a Worksheet

Topic 5A: Convert Text to Columns

Topic 5B: Modify Fonts

Topic 5C: Add Borders and Color to Cells

Topic 5D: Change Column Width and Row Height

Topic 5E: Merge Cells

Topic 5F: Apply Number Formats

Topic 5G: Align Cell Contents

Topic 5H: Find and Replace Formats

Topic 5I: Apply AutoFormat

Topic 5J: Apply Cell Styles

Topic 5K: Apply Themes


Lesson 6: Developing a Workbook

Topic 6A: Format Worksheet Tabs

Topic 6B: Reposition Worksheets in a Workbook

Topic 6C: Insert and Delete Worksheets

Topic 6D: Copy and Paste Worksheets



Lesson 7: Printing Workbook Contents

Topic 7A: Set Print Titles

Topic 7B: Create a Header and a Footer

Topic 7C: Set Page Margins

Topic 7D: Change Page Orientation

Topic 7E: Set Page Breaks

Topic 7F: Print a Range

Lesson 8: Customizing Layout

Topic 8A: Split a Worksheet

Topic 8B: Arrange Windows

Topic 8C: Freeze and Unfreeze Rows and Columns

Topic 8D: Hide and Unhide Worksheets

...''

Phone:(800) 880-2949

School Address:

Complete Computing, Inc.
400 West 7th Street
Little Rock, AR USA 72201

Jobs & Resumes: Little Rock
Houses & Roommates: Little Rock

Adobe Acrobat 7.0 Combo
Adobe Acrobat 7.0 Lev 1
Adobe Acrobat 7.0 Lev 2
Adobe Illustrator CS
Adobe InDesign CS
Adobe PageMaker 7.0 Lev 1
Adobe PageMaker 7.0 Lev 2
PhotoShop CS
Access 2003 VBA
Microsoft Access 2003
Excel 2003
Outlook 2003
PowerPoint 2003
Microsoft Word 2003
CorelDraw 11: Lev 1
CorelDraw 11: Lev 2
Crystal Reports XI
Crystal Reports 10
DreamWeaver MX

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: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.