Microsoft Excel 2013 – Level 2

////Microsoft Excel 2013 – Level 2
Microsoft Excel 2013 – Level 2 2018-05-08T16:39:47+00:00

Microsoft Excel 2013 – Level 2

Course Length :  35 Hours

Course Description

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. The information worker will also look at more functions to set up more complexcalculations.

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 and Graphics

  • Creating a Basic Chart
  • Moving and Resizing Charts
  • Changing Chart Types
  • Working with Pie Charts
  • Modifying the Chart Design andLocation
  • 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 ScalingObjects
  • Rotating Objects
  • Inserting a Watermark in theBackground
  • 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 and Exporting 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
Online Course Fee Payment
Other Amount:
Your Email Address:

Microsoft Excel 2013 – Level 2

  • Duration :   35 Hours
  • Certificates :   Yes
Online Course Fee Payment
Other Amount:
Your Email Address:

Quick Facts

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.