Upgrading to Excel 2013 – Training Course in Belfast Northern Ireland

Excel 2010 2013 training courses NI

Having worked with applications in Microsoft Excel 2003/2007/2010, students must also get to know the new interface in the latest release of the application.

Delegates will learn how to

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

Course Outline

Using the Excel 2013 Environment

  • Excel Start Screen
  • Templates
  • The Ribbon (Customization and Developer Tabs)
  • Tabs, Groups, Commands
  • Dialog Box Launcher
  • Quick Access Toolbar
  • File Tab (Backstage View)
  • Excel Options
  • Views and Zooming
  • Keyboard Shortcuts
  • Workbook Windows
  • Document Inspector
  • File Formats, Compatibility and Versions
  • Integration (SharePoint / SkyDrive)
  • File Types

Excel General Features

  • Increased Capacity
  • Mini Toolbar
  • Live Previews
  • Galleries
  • Print Preview / Page Layout View
  • Cut, Copy and New Paste Options
  • Flash Fill
  • Digital Signature
  • Equations

Formulas and Functions

  • Formula Bar
  • AutoComplete
  • Name Manager
  • New Functions

Worksheet Formatting

  • Cell Styles
  • Conditional Formatting

Data Management

  • Sort and Filter Data
  • Create and Modify Excel Tables
  • Use Slicers with Tables

Data Analysis

  • Use Quick Analysis Tool
  • Create Pivot Tables and Charts
  • Use Slicers with Pivot Tables

Charts and Graphics

  • Create and Modify Charts
  • Use Recommended Charts
  • Create Sparklines
  • Insert SmartArt
  • Insert Online Pictures
  • Insert Screenshots
  • Use Themes
Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks