• Authored Course

Microsoft Excel 2010 - New Features from Excel 2003

Learn via: Classroom / Attend from Anywhere

Price: £403

Dates and Locations

About this Course

You have used Excel 2003 in your job and are now upgrading. In this course you will learn the new features of Excel 2010 that will help to streamline your work.

Further detailed training is available on all other Office 2010 applications, including: Word, Outlook, PowerPoint, Access, InfoPath, Project, Publisher, SharePoint, OneNote and Visio 2010.

Target Audience

An experienced end user who has worked regularly with Excel 2003 and needs to know the new features of Excel 2010.

Essential Excel Keyboard Shortcuts

Essential Microsoft Excel Shortcuts

In this article we list some of the top Microsoft Excel shortcuts you should know, helping you navigate Excel more easily. Read the full article

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA

Locations

There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London

    London

    International House

  • Manchester

    Manchester

    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

Module 1 - Using the Excel 2010 Environment

  • General Environment
  • Customisation Features
  • File Tab
  • Excel Options
  • Views
  • Zooming
  • Document Inspector
  • File Formats and Compatibility Checker
  • Workbook Management Tools

Module 2 - Using Excel General Features

  • Increased Capacity
  • Mini Toolbar
  • Live Previews
  • Galleries
  • Enhanced Print Options
  • Page Layout View
  • New Paste Options
  • Digital Signatures
  • Equation Builder

Module 3 - New Formula and Function Features

  • Resizable Formula Bar
  • AutoComplete
  • Name Manager
  • New Function Tab and Library
  • New Functions

Module 4 - Formatting Excel Worksheets

  • Cell Styles
  • Conditional Formatting

Module 5 - Data Management

  • Sort and Filter Data
  • Create and Modify Excel Tables

Module 6 - Data Analysis

  • Create Pivot Tables and Pivot Charts
  • Use Slicers with Pivot Tables

Module 7 - Charts and Graphics

  • Insert Charts
  • Create Sparklines
  • Insert SmartArt
  • Insert Screenshots
  • Use Themes

Before attending this course, delegates should be existing Microsoft Excel 2003 users who will be required to use Microsoft Excel 2010. They should have basic knowledge of this application and should be able to use a keyboard and mouse and be able to navigate the Windows XP or Windows 7 operating system, including using Windows Explorer.

At the end of this course you will be able to:

  • Explore the general environment of Excel 2010
  • Use the key new features of Excel 2010

Microsoft
Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.