Book your training online... 1000's of courses, 100's of locations, 1 website!

Less

COURSE FINDER

or

Booking Enquiry

Microsoft Excel 2010 - Transition from Excel 2003

£265 per delegate

Duration: 0.5 days

Trainer: LH333N

Overview

In this course students will use the new and enhanced features in Microsoft Office Excel 2010.

Who Should Attend

This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel, ideally Microsoft Office Excel 2003, and who are planning to upgrade to Microsoft Office Excel 2010.

Course Outcome

Upon successful completion of this course, students will be able to:

- Identify the elements of the Microsoft Office Excel 2010 environment.
- Organize data in Excel worksheets.
- Analyze Excel data by sorting, filtering, and conditionally formatting it.
- Present Excel data using charts, illustrations and PivotTables.
- Use Office Web Apps.

Prerequisites

Students must have prior knowledge of Microsoft Office Excel 2003 or Excel XP on the Windows operating system.

Course Outline

Lesson 1: Identifying the Elements of the Excel 2010 Environment

- Identify the User Interface Elements
- Identify the Ribbon Components
- Use Contextual Tabs
- Use Excel Galleries
- Customize the Excel Interface

Lesson 2: Organizing Data

- Identify the Enhancements to Excel 2010 Spreadsheets
- Insert Tables
- Format Tables

Lesson 3: Analysing Data

- Apply Conditional Formatting
- Sort Data in a Spreadsheet
- Filter Data in a Spreadsheet
- Apply a Formula

Lesson 4: Presenting Data

- Create Charts
- Format Charts
- Work with Illustrations
- Create PivotTables and PivotCharts
- Share Excel Charts
- Save Data in Compatible Formats

Lesson 5: Using Office Web Apps

- Save Excel Spreadsheets to the Web
- Access andWork with Spreadsheets on the Web

Your Enquiry

Please select expected number of delegates

VCode

I am interested in...

In-Company/Own Venue Open Course All Course Types

Enquiry

Please enter your enquiry details below and leave the rest to us. Need different dates or venue? No problem! Please remember to include:
- Preferred dates
- Preferred location(s)

Your Details

Name

Company Name

Email

Telephone

Mobile

Postcode

Address

City

County

Country

What happens next?
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

Email Enquiries

enquiries@bookmycourse.co.uk

GET A QUOTE