Microsoft Excel 2013 New Features from Excel 2003

1 Day Course
Code QAEX13NF

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

Further detailed training is available on all other Office 2013 applications, including: Word, Outlook, PowerPoint, Access, InfoPath, Project, Publisher, SharePoint, OneNote and Visio 2013. Target Audience: An experienced end user who has worked regularly with Excel 2003 and needs to know the new features of Excel 2013.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Module 1 - Using the Excel 2013 Environment (15 topics)

  • 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

Module 2 - Excel General Features (9 topics)

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

Module 3 - Formulas and Functions (4 topics)

  • Formula Bar
  • AutoComplete
  • Name Manager
  • New Functions

Module 4 - Worksheet Formatting (2 topics)

  • Cell Styles
  • Conditional Formatting

Module 5 - Data Management (3 topics)

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

Module 6 - Data Analysis (3 topics)

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

Module 7 - Charts and Graphics (7 topics)

  • Create and Modify Charts
  • Use Recommended Charts
  • Create Sparklines
  • Insert SmartArt
  • Insert Online Pictures
  • Insert Screenshots
  • Use Themes

Prerequisites

Before attending this course, delegates should be existing Microsoft Excel 2003 users who will be required to use Microsoft Excel 2013. 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.

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections