Upgrading to Excel 2013

Enquire About This Course

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

Click here to download:

Upgrading to Excel 2007

Enquire About This Course