• 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 2

View course dates

Course Duration: 1 day

Course Code: DEX07L2

Course Description:

In Microsoft® Office Excel® 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Office Excel® 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

 

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisite courses:

Excel 2007 Level 1

Relevant Certifications:

MCAS: Microsoft Certified Application Specialist

This course includes the following modules:

Enhancing Workbooks

• Customize the Excel Environment
• Customize an Excel Worksheet
• Enhance Worksheets Using Themes
• Work with Comments
• Access External Resources Using Hyperlinks
• Use Web-Based Research Tools

Creating Workbooks Using Templates

• Create a Workbook from a Template
• Create a Custom Template

Organizing Data Using Tables

• Create Tables
• Modify Tables
• Format Tables

Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts
• Create a Chart Template
• Share Excel Charts

Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable
• Perform Calculations Using PivotTables
• Analyze Data Using PivotCharts

Enhancing Visual Appeal Using Graphic Objects

• Insert Graphics
• Modify Graphic Objects
• Emphasize an Area of a Worksheet
• Illustrate Workflow Using SmartArt Graphics
• Format Graphic Objects
• Change the Order of Layered Graphic Objects
• Group Graphic Objects
• Organize Graphic Objects

Calculating Data with Advanced Formulas

• Refer to a Range of Cells
• Calculate Data Across Worksheet
• Perform Date and Time Calculations
• Format Text Using Formulas
• Perform Numeric Calculations
• Calculate Data with Lookup & Reference Functions
• Perform Logical Analysis
• Print Formulas

Sorting and Filtering Data

• Sort Data in a Spreadsheet
• Filter Data in a Spreadsheet
• Calculate Large Volumes of Data
• Add Subtotals to a Worksheet

 

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			14 - 14		15 - 15
Bristol	1 days	£215			9 - 9
Exeter	1 days	£215			16 - 16
Glasgow (RenSt)	1 days	£215		3 - 3			2 - 2
Leeds	1 days	£215					17 - 17
London (Mid)	1 days	£215	29 - 29	30 - 30			18 - 18
London (Tab)	1 days	£215			20 - 20
Manchester (Exch)	1 days	£215			6 - 6			13 - 13
Milton Keynes	1 days	£215			1 - 1			7 - 7
Newcastle	1 days	£215			2 - 2
Reading	1 days	£215					4 - 4
Wokingham	2 days	£495			13 - 14		10 - 11

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