MS Excel 2007 Level 1

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.

Course Outline

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.

Course 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

Additional Details

Pre-Requisites

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.

Certificates offered

Certificate of completion

Cancellation Policy

Students are required to give notice if they are unable to attend their class:

2 weeks (10 full business days) or longer prior to training date = full refund
1 to 2 weeks (5 - 9 full business days) prior to training date = 50% of course fee refund
Less than 1 week (4 full business days or fewer) prior to training date = 0% refund

NOTE: You may substitute classes or students at any time.

Map & Reviews

New Era Technology Training
[ View Provider's Profile ]

New Era Technology Centre
#300, 633 - 6th Ave S.W., Ford Tower
Calgary, Alberta
Canada   T2P 2Y5

Reviews

 

   

Alex is great!

Reviewed by ellen m. 2011