Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


Instructor-Led, Hands-On, Microsoft Excel 2002/3003 Level 2


 
Course Outline
Microsoft Excel - Level 2
| | ID: SAMSE1 | Course Length: 1
|Module 0: Using Large Worksheets|
  • Increasing the Magnification
  • Decreasing the Magnification
  • Changing the Magnification of a Range
  • Switching To Full Screen View
  • Splitting the Window
  • Removing Split Windows
  • Freezing the Panes
  • Unfreezing the Panes
  • |Module 1: Working with Multiple Worksheets|
  • Using Multiple Worksheets
  • Navigating Between Worksheets
  • Selecting Worksheets
  • Renaming Worksheets
  • Selecting Multiple Worksheets
  • Coloring Worksheet Tabs
  • Inserting Worksheets
  • Deleting Worksheets
  • Printing Selected Worksheets
  • |Module 2: Managing Worksheets|
  • Copying Worksheets
  • Moving Worksheets
  • Using Grouped Worksheets
  • Moving Data Between Worksheets
  • Copying Data Between Worksheets
  • Creating 3-d Formulas
  • Using 3-d Ranges in Functions
  • |Module 3: Using Range Names|
  • Working with Range Names
  • Using 3-d Range Names in Formulas
  • Jumping To a Named Range
  • Assigning Names
  • Using Range Names in Formulas
  • Creating Range Names From Headings
  • Applying Range Names
  • Deleting Range Names
  • Using Range Names in 3-d Formulas
  • Creating 3-d Range Names
  • |Module 4: Using Other Functions|
  • Using Function Arguments
  • Using Financial Functions
  • Using Logical Functions
  • Using Date Functions
  • Formatting Dates
  • Revising Formulas
  • |Module 5: Managing Data|
  • Sorting Lists
  • Sorting in Ascending/descending Order
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Formats
  • |Module 6: Using Autofilter|
  • Enabling Autofilter
  • Using Autofilter To Filter a List
  • Clearing Autofilter Criteria
  • Creating a Custom Autofilter
  • Disabling Autofilter
  • |Module 7: Managing Files|
  • Changing Workbook Properties
  • Using the Basic Search Task Pane
  • Using the Advanced Search Task Pane
  • Clearing Query Clauses
  • Selecting File Views
  • Sorting Excel Files
  • |Module 8: Creating Charts|
  • Using Charts
  • Charting Non-adjacent Ranges
  • Changing the Chart Range
  • Changing the Data Source
  • Changing the Chart Location
  • Printing a Chart
  • Creating Charts with the Chart Wizard
  • Moving and Resizing Charts
  • Identifying Chart Objects
  • Changing the Chart Type
  • Changing the Chart Type and Sub-type
  • Changing the Plot Direction
  • Removing/adding a Legend
  • Moving the Legend
  • |Module 9: Formatting Charts|
  • Formatting Charts
  • Adding Chart Titles
  • Formatting Chart Objects
  • Changing the Text Orientation
  • Adding a Data Table
  • Creating An Exploded Pie Chart
  • Adjusting the 3-d View
  • Deleting a Chart
  • |Module 10: Drawing An Object|
  • Working with Drawing Objects
  • Changing and Removing the Fill Color
  • Changing the Font Color
  • Deleting An Object
  • Drawing Enclosed Objects
  • Drawing a Line
  • Selecting Filled and Unfilled Objects
  • Moving An Object
  • Adding Text To An Object
  • Selecting Text in An Object
  • Resizing An Object
  • Formatting Lines
  • |Module 11: Using Additional Effects and Objects|
  • Adding a 3-d Effect
  • Applying a 3-d Setting
  • Adding a Shadow
  • Drawing a Text Box
  • Drawing An Arrow
  • Inserting Pictures
  • Formatting Graphics
  • |Module 12: Using Autoshapes and Diagrams|
  • Working with Autoshapes
  • Drawing a Callout
  • Drawing a Basic Shape
  • Drawing a Connector
  • Drawing a Flowchart Shape
  • Drawing a Block Arrow
  • Inserting a Diagram
  • Working with Diagrams
  • |Module 13: Using Html Files|
  • Previewing a Web Page
  • Creating a Hyperlink
  • Editing a Hyperlink
  • Saving a Worksheet As a Web Page
  • Using Publishing Options
  • Opening An HTML File
  • |Module 14: Working with Comments|
  • Creating Comments
  • Viewing a Comment
  • Using the Reviewing Toolbar
  • Printing Comments
  • Responding To Discussion Comments

  • Prerequisites & Certificates
    Pre-Requisites

    level 1 or equal knowledge

    Certificates offered

    certificates provided


    Cancellation Policy
    For courses bought at the regular price 10 Business days are required for cancellations.
    For courses bought at the 'last-minute' price - all Registration are final
    Map & Reviews
    CBIT Training Ottawa
    [ View Provider's Profile ]

    Reviews
     
    This is my second workshop with CBIT. The facilities and ammenities offered are exceptional. Administrative staff are very friendly, helpful and eager to assist. Course content and quality of instruction have more than met with my needs and expectations. I am very confident in their ability to provide quality programming and have already recommended them to others in my organization.
    Reviewed by 2011
    need-to-train-a-group-banner

    This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

    This page has been viewed 843 times.