Microsoft Excel 2013

by NetPLUS College of Information Technology Claim Listing

This Microsoft® Excel 2013 Level 2 Guide teaches the information worker how to work with intermediate oradvanced features for business reports such as charts to show trends or patterns, what-if scenarios, or table anddatabase functions.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

NetPLUS College of Information Technology Logo

img Duration

35 Hours

Course Details

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

  • Toronto Branch

    1891 Kennedy Road, Unit #3, Toronto

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy