Excel 2007 Level 2 (Intermediate) - French Instruction/English Software

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.

Course Outline

In this course, you will use Microsoft® Office Excel® 2007 to manage, edit, and print data. Participants must have basic knowledge of the Windows environment, keyboard and mouse operations as well as a basic understanding of mathematics.

Learning objectives: You will create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks.

Course Outline: Lesson 1: Creating a Basic Worksheet
Topic 1A: Explore the User Interface and the Ribbon
Topic 1B: Navigate and Select in Excel
Topic 1C: Obtain Help
Topic 1D: Enter Data and Save a Workbook
Topic 1E: Customize the Quick Access Toolbar

Lesson 2: Performing Calculations
Topic 2A: Create Basic Formulas
Topic 2B: Calculate with Functions
Topic 2C: Copy Formulas and Functions

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: Formatting a Worksheet
Topic 4A: Modify Fonts
Topic 4B: Add Borders and Color to Cells
Topic 4C: Change Column Width and Row Height
Topic 4D: Apply Number Formats
Topic 4E: Position Cell Contents
Topic 4F: Apply Cell Styles

Lesson 5: Printing Workbook Contents
Topic 5A: Print Workbook Contents Using Default Print Options
Topic 5B: Set Print Options
Topic 5C: Set Page Breaks

Lesson 6: Managing Large Workbooks
Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets in a Workbook
Topic 6C: Manage the View of Large Worksheets

Additional Details

Pre-Requisites

Participants must have basic knowledge of the Windows environment, keyboard and mouse operations as well as a basic understanding of mathematics.

Certificates offered

Certificate of completion

Cancellation Policy

RESCHEDULING POLICY

Registrants who wish to reschedule their course may do so at least 5 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course. Otherwise, a 20% surcharge is applicable.

CANCELLATION POLICY

Notice received less than 5 working days prior to the course date is subject to a 20% service charge. If the notice is given within 48 hours of the course date, the course is non-refundable. Notice of cancellation must be received by CompuEase 5 working days prior to the confirmed date to obtain a full refund.

Map & Reviews

CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa, ON
Canada   K1P 5M9

Reviews

 

   

I am satisfied - in fact, I will go to another training within the few next weeks.

Reviewed by Suzanne R. 2011