COURSE FINDER

Microsoft Excel 2010 - Transition from Excel 2003

£255 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.
  • Corps Construct Logo
  • Safety & Health Logo
  • Hawks Logo
  • Know How Logo
  • SYNERGIETRAINING Logo
  • Induct Ltd Logo
  • Ace Safety Logo
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • Health Life and Safety Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • CCAS Health and Safety Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Total Construction 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).

© 2020 Book My Course Limited. All rights reserved

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