SCS Training Centre
  

 

MICROSOFT® OFFICE
MS EXCEL 2010 LEVEL 2

 

Course Description

Microsoft® Excel 2010 Level 2 teaches students how to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports. Students will learn to create and manipulate charts, work with different types of graphics, look at various methods of analyzing, organizing, linking and sharing workbooks, learn to use advanced formatting features.

Course Length

For the shortest course lengths, students can perform just the Learn the Skill exercises.
For longer course lengths, students can complete both the Learn the Skill and Practice the Skill exercises

Course Prerequisites

This course is a continuation of the Microsoft Excel 2010 – Level 1 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 2010 will benefit from taking this course.
Course Objectives
This course book is a continuation of the Microsoft Excel 2010 Level 1 course. It teaches the skills you will need to successfully understand the basics of Microsoft Excel 2010. These skill sets are introduced using a fictional company named Tolano Adventures, a travel service that is a department within Tolano Environmental Consulting. Tolano Adventures offers tours to the public that are friendly to the environment.

After completing this course, you will be able to:

    • create charts
    • change the chart type
    • work with pie charts
    • move and resize a chart
    • change the chart layout
    • create, customize and remove a sparkline chart
    • print a chart
    • draw different types of shapes
    • move, resize and format shapes
    • use WordArt objects
    • insert clip art, pictures and SmartArt
    • use the Image Editor tools
    • insert screenshots
    • resize, reshape and rotate graphics objects
    • sort data
    • use the AutoFilter feature to find specific data
    • create, modify and delete range names, hyperlinks and comments
    • import and export data with other programs
    • change workbook document properties
    • use Office BackStage to share workbooks with others
    • customize chart elements
    • add a secondary vertical axis
    • add or remove data series for charts
    • create and use sparklines
    • create and customize trendline charts
    • create and apply chart templates
    • customize formats for numbers, dates, scientific, or text data types
    • create and modify a table
    • use dynamic charts

Click here to register for courses

Or return to the seminars page to register and pay online.


or call us at: 905-628-3208

Service Areas:  
Ancaster, Milton, Waterdown, St. Catharines, Niagara Falls, Kitchener, Waterloo, Hamilton, Burlington, Dundas, Oakville and Mississauga West