word processing tutorial training course online
Creating and Using Spreadsheets course

Creating and Using
Spreadsheets Tutorial
Info and Order

Creating and Using Spreadsheets

European Computer Driving Licence: Creating and Using Spreadsheets shows users how to work with a spreadsheet application to insert and manipulate data. It also shows users how to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts.

This Creating and Using Spreadsheets course is for those who have never used a computer and those who have some computer experience but no formal qualification proving their knowledge or skills. It is also for those preparing to take the European Computer Driving Licence examination.

Understanding Information Technology

Using the Computer

Word Processing

Using Spreadsheets

Using Databases

Presentations

World Wide Web

Computer Online
Training Courses
Info and Order

Computer Training Online

Best Weight Loss Program

Vitamin Supplements

Fruta Vida

Creating and Using Spreadsheets Course Objectives

  • Create and save a spreadsheet
  • Open, revise, and close a spreadsheet
  • Use application help
  • Change display settings
  • Insert, select, copy, move, and delete data
  • Undo and redo actions
  • Search and replace data
  • Sort data
  • Create and copy a formula
  • Use functions such as SUM, AVERAGE and IF
  • Format data
  • Preview and prepare a spreadsheet for printing
  • Import an object and text file into a spreadsheet
  • Create, adjust, move, and delete a chart

Course Topics

  • Getting Started
    • Starting a spreadsheet application
    • Creating and saving a spreadsheet
    • Opening, revising, and closing a workbook
    • Exiting from the application

  • Using Help and Display Settings
    • Using application help
    • Changing display settings

  • Adding and Moving Data
    • Inserting data
    • Undoing and redoing actions
    • Revising data

  • Manipulating Data
    • Searching and replacing values
    • Inserting, changing, and deleting columns and rows
    • Sorting data

  • Using Formulas
    • Creating a formula
    • Using AutoFill
    • Using relative cell references
    • Using absolute cell references
    • Correcting errors in formulas

  • Using Functions
    • Using the SUM function
    • Using the AVERAGE function
    • Using the IF function

  • Formatting a Spreadsheet
    • Formatting numeric data
    • Formatting textual data
    • Adding borders
    • Checking spelling

  • Printing a Spreadsheet
    • Previewing a spreadsheet
    • Adjusting page margins
    • Changing page settings
    • Printing parts of a spreadsheet
    • Printing a worksheet or workbook

  • Using Advanced Features
    • Inserting a picture
    • Adjusting a picture
    • Importing a text file
    • Producing a chart

Features:

  • Instructional steps -- walk through a procedure
  • Exercises -- try it out
  • Notes - See additional information related to the topic in the text
  • Tips - See a different, faster, or easier way of doing something
  • Quick References - See a quick reference guide to the features introduced in a chapter
  • Details - Display more detailed information related to the current topic
  • Hotwords - See related information
  • Navigation Bar - Maneuver easily through the courses
  • Topics and Index -- with searching feature and hyper-links
  • Printable Exercises - PDF downloadable files
  • Sample Application Files - PDF downloadable files
  • Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which topics you want to focus on and to go directly into that unit.

Technical Requirements

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Learning comes to life with challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. Our proven methodology provides an unequalled experience with exceptional results Learning that's Easy, Convenient and Affordable! High-quality, online, self-paced courses designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.

Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.