COURSE FINDER

Microsoft Excel 2010 - Transition from Excel 2003

£265 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 0.5 days

Trainer: LH333N

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

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
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Hawks Logo
Know How Logo
Induct Ltd Logo
BAM Construction Training Logo
Citrus Training Logo
3B Training Logo
Construction Industry Training Providers Logo
Health Life and Safety Logo
MI Construction Training Logo
Innov8 Training Logo
OM Safety Training Logo
Construction Skills People Logo
Harris Safety Training Logo
First Response Training Logo
KeyOstas Logo
OMS Logo
Tala Training Logo
PRS Health and Safety Training
SSG Training and Consultancy Logo
Safety Training Services Logo
Lighthouse Training Logo
The Building Safety Group Logo
Kentec Training Logo
NTSS logo
Frinton Training logo
The Safety Maintenance Company logo
PC Workshops logo
Zero Harm Training logo
Risk Health and Safety logo
Sibbald Training logo
UTN Training logo
Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

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

© 2024 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy