Microsoft Excel 2013

This Microsoft® Excel 2013 Level 2 Guide teaches the information worker how to work with intermediate or advanced features for business reports such as charts to show trends or patterns, what-if scenarios, or table and database functions. The information worker will also look at more functions to set up more complex calculations.

Course Prerequisites

This course is a continuation of the Microsoft Excel 2013-Level 2 courseware, in which you were introduced to the basic concepts and skills required for creating and editing professional-looking spreadsheets for a variety of purposes and situations.Students who wish to become proficient using the intermediate features of Microsoft Excel 2013 will benefit from taking this course.

Outline

Lesson 1: Working with Charts andGraphics

• Creating a Basic Chart

• Moving and Resizing Charts

• Changing Chart Types

• Working with Pie Charts

• Modifying the Chart Design and location

• Adding New Data

• Using Sparklines

• Printing Charts

• Using Quick Analysis Tool

• Drawing Shapes

• Moving and Resizing Shapes

• Formatting Shapes

• Using WordArt

• Inserting Pictures and Clip Art

• Using the Image Editor

• Modifying Graphics Objects

• Using the Format Shape Pane

• Resizing, Reshaping, and scaling objects

• Rotating Objects

• Inserting a Watermark in the background

• Using SmartArt Graphics

Lesson 2: Organizing Data

• Working with Named Ranges

• Creating Named Ranges

• Modifying and Deleting NamedRanges

• Go To a Cell or Named Range

• Using Tables

• Creating a Table

• Modifying Table Data

• Formatting Table Data

• Moving or Copying Worksheets

• Sorting Data

• Sorting by Single-Level Data

• Sorting by Multi-Level Data

• Filtering Information

• Removing Duplicate Rows

• Outlining

Lesson 3: Macros, Importing andExporting Data

• Customizing Excel

• Customizing the Quick AccessToolbar

• Customize the Ribbon

• Finding and Replacing Data

• Finding Data

• Replacing Data

• Using Hyperlinks

• Inserting Hyperlinks

• Modifying and Deleting Hyperlinks

• Using Comments

• Importing and Exporting Data

• Importing Data Files

• Open Non-Native Files Directly inExcel

• Exporting Data from Excel

• Changing Workbook Properties

• Save to Remote LocationsSkyDrive

• Macros

• Creating a Macro

• Saving and- Opening a WorkbookContaining Macros

• Adding Macros to the QuickAccess Toolbar