Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


Instructor-Led Microsoft Excel 2002/2003 Level 3


 
Course Outline
Microsoft Excel - Level 3
| | ID: SAMSE2 | Course Length: 1
|Module 0: Working with Labels in Formulas|
  • Using Labels in Formulas
  • Using Labels To Define a Range
  • Using Multiple Stacked Headings
  • Referring To Individual Cells
  • |Module 1: Working with Outlines|
  • Applying An Outline
  • Collapsing/expanding An Outline
  • Modifying Outline Settings
  • Clearing An Outline
  • Using Auto Outline
  • |Module 2: Working with Databases|
  • Using a Database
  • Removing Subtotals From a List
  • Creating a Database
  • Modifying a Database
  • Sorting Records By Multiple Fields
  • Using Data Validation
  • Validating Data Using a List
  • Creating a Custom Error Message
  • Removing Data Validation
  • Creating Subtotals in a List
  • |Module 3: Working with the Data Form|
  • Viewing the Data Form
  • Viewing Data Form Records
  • Editing Data Form Records
  • Adding Data Form Records
  • Defining Criteria
  • Clearing Data Form Criteria
  • Deleting Data Form Records
  • |Module 4: Working with Advanced Filters|
  • Creating a Criteria Range
  • Using a Criteria Range
  • Showing All Records
  • Using Comparison Criteria
  • Using An Advanced And Condition
  • Using An Advanced Or Condition
  • Copying Filtered Records
  • Using Database Functions
  • |Module 5: Exporting and Importing Data|
  • Exporting Data To Other Applications
  • Exporting To XML
  • Importing Data
  • Importing Data From Text Files
  • Changing External Data Range Properties
  • Importing Data From Other Applications
  • Removing the Query Definition
  • Importing Dynamic Data From the Web
  • Copying a Table From a Web Page
  • |Module 6: Advanced Charting|
  • Adding and Removing Gridlines
  • Creating User-defined Charts
  • Applying User-defined Charts
  • Formatting Gridlines
  • Formatting An Axis
  • Changing the Axis Scaling
  • Formatting the Data Series
  • Adding Data - Different Worksheets
  • Using a Secondary Axis
  • Changing Data Series Chart Types
  • Adding a Trendline
  • |Module 7: Using Multiple Workbooks|
  • Opening Multiple Workbook Windows
  • Linking Workbooks
  • Opening Linked Workbooks
  • Cascading Open Workbook Windows
  • Activating Cascaded Workbook Windows
  • Tiling Open Workbook Windows
  • Activating Tiled Workbook Windows
  • Copying Data Between Workbooks
  • Saving a Workspace
  • Closing All Open Workbooks
  • Opening a Workspace
  • |Module 8: Using Conditional and Custom Formats|
  • Applying Conditional Formats
  • Changing a Conditional Format
  • Adding a Conditional Format
  • Deleting a Conditional Format
  • Creating a Custom Format
  • |Module 9: Using Templates|
  • Working with Templates
  • Saving a Workbook As a Template
  • Using a Template
  • Editing a Template
  • Inserting a New Worksheet
  • Deleting a Template
  • Creating Default Templates
  • |Module 10: Using Paste Special|
  • Working with Paste Special
  • Copying Values Between Worksheets
  • Copying Formulas Between Worksheets
  • Performing Mathematical Operations
  • |Module 11: Customizing Excel Preferences|
  • Setting View Options
  • Setting Edit Options
  • Setting General Options
  • |Module 12: Using Worksheet Protection|
  • Unlocking Cells in a Worksheet
  • Removing a Password
  • Setting Manual Calculation
  • Resetting Automatic Calculation
  • Using the Document Recovery Pane
  • Protecting a Worksheet
  • Unprotecting a Worksheet
  • Creating Allow-editing Ranges
  • Deleting Allow-editing Ranges
  • Protecting Workbook Windows
  • Unprotecting Workbook Windows
  • Assigning a Password
  • Opening a Password-protected File
  • |Module 13: Sharing Workbooks|
  • Using Shared Workbooks
  • Adding a History Worksheet
  • Reviewing Tracked Changes
  • Merging Shared Workbook Files
  • Saving a Shared Workbook
  • Viewing Users Sharing a Workbook
  • Viewing Shared Workbook Changes
  • Changing the Update Frequency
  • Highlighting Changes
  • Managing Conflicting Changes
  • Resolving Conflicting Changes
  • Setting Change History Options

  • Prerequisites & Certificates
    Pre-Requisites

    none

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