NewEra Technology Facebook
Microsoft Excel 2007 Level 1 - Course Information
PRINT
SEND TO A FRIEND
Name: Microsoft Excel 2007 Level 1
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245
Description:
This course is designed to teach the fundamentals of using an Excel spreadsheet, including the basics of entering data into a sheet, to building formulas to formatting.
Prerequisites:
Previous knowledge of this application is not required.

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
Outline:
Creating a Basic Worksheet
• Explore the User Interface and the Ribbon
• Navigate and Select in Excel
• Obtain Help
• Enter Data and Save a Workbook
• Customize the Quick Access Toolbar

Performing Calculations
• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions

Modifying a Worksheet
• Manipulate Data
• Insert and Delete Cells, Columns, and Rows
• Search for Data in a Worksheet
• Spell Check a Worksheet

Formatting a Worksheet
• Modify Fonts
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Apply Number Formats
• Position Cell Contents
• Apply Cell Styles

Printing Workbook Contents
• Print Workbook Contents Using Default Print Options
• Set Print Options
• Set Page Breaks

Managing Large Workbooks
• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets
Guaranteed to run courses