• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User Microsoft Office Training Courses

Excel 2007 Level 1

View course dates

Course Duration: 1 Day

Course Code: DEX07L1

Course Description:

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 a Microsoft Office Windows XP Introduction course or have equivalent knowledge.

Relevant Certifications:

MCAS: Microsoft Certified Application Specialist

This course includes the following modules:

Exploring the Excel Environment

• Explore the User Interface
• Explore the Ribbon
• Obtain Help
• Customise the Quick Access Toolbar

Working with an Excel Worksheet

• Navigate in Excel
• Select and Enter Data
• Save a Workbook

Modifying a Worksheet

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

Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create a Mixed Reference

Formatting a Worksheet

• 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

Developing a Workbook

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheet
• Copy and Paste Worksheets

Printing Workbook Contents

• Set Print Titles
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Set Page Breaks
• Print a Range

Customising Layout

• Split a Worksheet
• Arrange Windows
• Freeze and Unfreeze Rows and Columns
• Hide and Unhide Worksheets

 

Location	Duration	RRP	Aug	Sep	Oct	Nov	Dec	Jan
Click on course date to make a booking, check availability, or find out about available discounts.
Birmingham	1 days	£215				12 - 12
Bristol	1 days	£215		11 - 11
Exeter	1 days	£215		16 - 16
Glasgow (RenSt)	1 days	£215				3 - 3
Leeds	1 days	£215				19 - 19
London (Tab)	1 days	£215		23 - 23		25 - 25
Manchester (Exch)	1 days	£215		1 - 1			8 - 8
Milton Keynes	1 days	£215		2 - 2			3 - 3
Newcastle	1 days	£215		19 - 19
Reading	1 days	£215				5 - 5
Wokingham	1 days	£199			7 - 7		2 - 2

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course