About this course

Course type Essentials
Course code QAEX10NF
Duration 1 Day

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.

Prerequisites

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

Delegates will learn how to

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

Outline

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
Essentials

1 Day

Duration
Microsoft Excel
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.