Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

Instructor-Led Microsoft Excel 2002/2003 Level 1 available in English and in French

Course Outline
Microsoft Excel - Level 1
| | ID: SAMSE0 | Course Length: 1
|Module 0: Exploring Excel|
  • Starting Excel
  • Exiting Excel
  • Working with Excel Windows
  • Working with Worksheets
  • Using Menu Commands
  • Displaying and Hiding Toolbars
  • Displaying Hidden Toolbar Buttons
  • Moving and Resizing Toolbars
  • Changing Menu and Toolbar Options
  • Using the Task Pane
  • |Module 1: Working with the Office Assistant|
  • Displaying/hiding the Office Assistant
  • Using the Office Assistant
  • Finding An Answer
  • Changing the Office Assistant Options
  • Using Ask a Question
  • |Module 2: Using Basic Workbook Skills|
  • Selecting a Cell Using the Keyboard
  • Opening An Existing Workbook
  • Using Data Entry Shortcuts
  • Editing Cell Entries
  • Checking Worksheet Spelling
  • Creating a New Folder
  • Renaming An Existing Workbook
  • Scrolling Using the Mouse
  • Using the Go To Dialog Box
  • Entering Text Into Cells
  • Entering Numbers Into Cells
  • Saving a New Workbook
  • Closing a Workbook
  • Creating a New Workbook
  • Using a Template
  • |Module 3: Working with Ranges|
  • Working with Ranges
  • Selecting Ranges with the Keyboard
  • Selecting Ranges with the Mouse
  • Selecting Non-adjacent Ranges
  • Entering Values Into a Range
  • Using the Auto Fill Feature
  • |Module 4: Creating Simple Formulas|
  • Using Formulas
  • Using Range Borders To Modify Formulas
  • Checking Errors
  • Entering Formulas
  • Using Functions
  • Using the Autosum Button
  • Using the Autosum List
  • Entering Basic Functions
  • Inserting Functions in Formulas
  • Editing Functions
  • Using the Autocalculate Feature
  • |Module 5: Copying and Moving Data|
  • Copying/cutting and Pasting Data
  • Using the Paste Options Button
  • Using the Paste List
  • Using the Clipboard Task Pane
  • Creating An Absolute Reference
  • Filling Cells
  • Using Drag-and-drop Editing
  • Using Undo and Redo
  • |Module 6: Printing|
  • Previewing a Worksheet
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing Multiple Copies
  • Printing a Page Range
  • |Module 7: Using Page Setup|
  • Setting Margin and Centering Options
  • Changing the Page Orientation
  • Creating Headers and Footers
  • Customizing Headers and Footers
  • Changing Print Gridlines
  • Repeating Row and Column Labels
  • Scaling a Worksheet
  • Using Page Break Preview
  • Setting/removing a Print Area
  • |Module 8: Formatting Numbers|
  • Using Number Formats
  • Using the Currency Style
  • Using the Percent Style
  • Using the Comma Style
  • Changing Decimal Places
  • |Module 9: Formatting Text|
  • Formatting Cell Text
  • Changing Cell Alignment
  • Changing Text Indentation
  • Changing An Existing Font
  • Modifying the Font Size
  • Using Bold and Italics
  • Underlining Text
  • Changing the Font Color
  • Rotating Text in a Cell
  • Wrapping Text in a Cell
  • Shrinking Text in a Cell
  • |Module 10: Working With Columns And Rows|
  • Selecting Columns and Rows
  • Deleting a Row
  • Changing the Width of Columns
  • Changing the Height of Rows
  • Adjusting Columns Automatically
  • Hiding Columns and Rows
  • Unhiding Columns and Rows
  • Inserting a Column
  • Insert a Row
  • Deleting a Column
  • |Module 11: Formatting Cells|
  • Using the Merge and Center Button
  • Clearing Formats
  • Inserting Selected Cells
  • Inserting Cut Or Copied Cells
  • Deleting Selected Cells
  • Changing the Vertical Alignment
  • Splitting Cells
  • Using the Borders Button
  • Drawing Cell Borders
  • Using the Fill Color Button
  • Pasting Formats
  • Using the Format Painter Button
  • Copying Formats To Non-adjacent Cells
  • |Module 12: Using Automatic Formatting and Styles|
  • Using Automatic Formatting Features
  • Applying An Autoformat
  • Changing Autoformat Options
  • Extending List Formats and Formulas
  • Creating a Style By Example
  • Applying a Style
  • Creating a New Style
  • Editing An Existing Style
  • Merging Styles
  • |Module 13: Using Online Help|
  • Working with Online Help
  • Viewing Screentips
  • Using Help Contents
  • Using Help Window Features
  • Using the Help Answer Wizard
  • Using the Help Index

  • Prerequisites & Certificates


    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 ]


    This course has not yet been rated by one of our members.

    If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

    Here are some reviews of the training vendor.
    I would recommend this vendor, with cautions. The course content did not nearly cover everything listed in the course description. The course started late and finished early, the instructor did not follow the course materials at all, and many topics that were supposed to be covered were not. Hopefully they are in the course book and I will be able to work through it on my own. I haven't had time to go through the book yet, and we didn't use it in the course. The material that was presented was good, but the instructor's knowledge was limited.
    Reviewed by 2012
    The Teacher really explained every topic very well and kept us very interested. She was a wonderful teacher.
    Reviewed by 2012
    I registered for the Access level two after already taking the level one last week thinking that it would be a continuation of what I learned in level one. This was not the case, it was all the same material as in level one. I don't understand how this can happen at the same school. I felt that the level two was really a waste of my time and mostly money.
    Reviewed by 2012
    I found there was too much theory. Hard to follow the second day. Should be more theory day 1 and then plenty more exercises Day 2.
    Reviewed by 2012
    Location isn't the greatest, but I had a good instructor, great computers to work with and relevant exercises. I would go back for more courses.
    Reviewed by 2012
    The instructor was very knowledgeable and accommodating. The presentation material and CD was excellent.
    Reviewed by 2012
    Trainer was good. Gave explanation WHY things are done in specific order. Not just "do this, do that"
    Reviewed by 2012
    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
    Course was fantastic and the instructor very knowledgeable and well organized. Due to a small class size, she was able to customize the course content to meet our individual training needs. In addition, CBIT provided each of us with the complete Org Plus manual which will be very handy as a reference tool back in the workplace. CBIT staff were welcoming and friendly - and served a hot breakfast at 10:00 am! There is also a fridge, microwave and break room avail. Not many great restaurants in the area, so better to pack your lunch. Overall, a great day.
    Reviewed by 2011
    We were provided a cd with a pdf copy of the manual for future reference which is great but no printed manual was provided to refer to during the course - this would have been helpful for learning.
    Reviewed by 2011

    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 1311 times.