CollegeTransfer.Net

Course Criteria

Add courses to your favorites to save, share, and find your best transfer school.

  • CECM 255: XP Level I

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: start MS Excel and identify the main components of the Excel Window and Excel workbook, and use the Help feature enter and edit lables, values, and formulas ina worksheet, use the Undo and Redo commands, and find and replace a formula move and copy data, insert and/delete ranges, and work with relative and absolute references when creating and copying formulas use functions such as SUM, AVERAGE, MIN, and MAX to preform calculations in a worksheet and use the AutoSum feature format text, numbers, rows and columns in a worksheet preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area create, format, modify, and print charts based on worksheet data save a worksheet as a web page, use the AutoRepublish feature, insert and edit hyperlinks in worksheets, and send a workbook via email Prerequisites: Introduction to Windows or equivalent knowledge.
    ShareCECM 255 - XP Level I
    Favorite

  • CECM 256: XP Level II

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: navigate large worksheets effectively by using magnification, frozen panes and control the printing of large worksheets navigate, manage, and print multiple worksheets, link workbooksby using 3-D formulas, and summarize data by using the Consolidate command change the settings of Excel and customize toolbars and menus format data points, create combination charts and tredlines, and add and format graphic elements add borders and shading, apply special formats, create, apply, and modify styles, and change the orientation of cells sort lists by columns and filter lists based on comples criteria add comments and text boxes, use the auditing features, and protect a worksheet or part of a worksheet create and manage custom templates Prerequisites: Excel Level I or equivalent knowledge
    ShareCECM 256 - XP Level II
    Favorite

  • CECM 257: XP Level III

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: use names to assign descriptive labels to cells; use logical and financial functions to calculate values based on conditions use lookup functions to return values from table use data tables to view the effects of multiple input values on a formula use data forms and validation to facilitate data entry in lists create and use Pivot Tables to analyze and compare large amounts of data import data from and export data to external databases use Goal Seek and Solver to perform what-if analyses, and use custom scenarios and views to manage different versions of worksheets run and record macros to automate complex or repetive tasks publish a worksheet as an interactive web page Prerequisites: Excel Level II or wquivalent knowledge
    ShareCECM 257 - XP Level III
    Favorite

  • CECM 258: XP Level I

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: -use database terminology, plan the design of a database, and use the Help feature -create and save databases, create a table, and set the primary key -use Datasheet view and Design view -modify a table's design; add, delete, sort, and filter records -create simple queries and design complex queries to perform calculations -create, use and modify forms -create, modify, and print reports -import and export database objects and XML documents, and link database objects Prerequisites: Introduction to Windows or equivalent knowledge.
    ShareCECM 258 - XP Level I
    Favorite

  • CECM 259: XP Level II

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: -normalize tables to reduce redundancy, set relationships between tables, and implement referential integrity -use the Lookup Wizard to create lookup lists in table design view and use subdatasheets to enter data in related tables -create an input mask in design view, use the Input Mask Wizard, set different properties of a field in design view, and set validation rules for entering data in a field -create self-joins, inner joins, and outer joins, create calculated fields in a query, create queries to add, modify, and delete data from tables, and create queries to create a new table -use queries to view summarized and grouped data from tables, create crosstab queries to summarize grouped data, create parameter queries, and set indexes in a table -use controls to add graphics and calculated fields to a form, add combo boxes to a form, and add unbound controls to a form -customize headers and footers in a report, use the Hide Duplicates property in a report, use functions to add calculated values, and use subreports to view data from related tables in a report -create and modify charts in forms and reports Prerequisites: Access Level I or equivalent knowledge.
    ShareCECM 259 - XP Level II
    Favorite

  • CECM 260: XP Level III

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: -create Pivot Tables and Pivot Charts for analyzing and comparing large amounts of data -create and use an advanced form by adding a tab control, an option group control, and a subform to it -create and use a macro to open database objects and attach a macro to a command button -create and use macros to automate user-interaction by using the Condition column and SetValue action -use Structured Query Language (SQL) to create queries in Access -use hyperlink and data access pages to link an Access database to the Internet or intranet -work with database utilities to optimize resources and secure data, and use security features to encrypt data from other applications -secure a database by setting a password and specifying user-level and object-level permissions Prerequisites: Access Level II or equivalent knowledge.
    ShareCECM 260 - XP Level III
    Favorite

  • CECM 261: XP Level IV

    3.00 Credits
    Tompkins Cortland Community College

    Automate and enhance your Access applications with Visual Basic for Applications (VBA) for Access XP. Wizards are fine, but some knowledge of VBA lets you edit wizard-generated code, so it will do what you want it to do. Even better, you will write VBA code from scratch, mostly in response to events, like opening a form or clicking a button. You will learn to: -work with the Visual Basic Editor -control the response to clicking a button -control the response to choosing a value in a combo box and option group -create custom error messages and user response messages -write custom data validation and error handling routines -use code to find and filter records on a form -write user-defined functions -create a dialog box form -use code to set the filter records for a report Prerequisites: Strong working knowledge of Access is required, including the design of tables, queries, forms and reports. No prior programming experience is required. Although this course uses Access XP, the course is suitable for anyone working with Access 97 and/or 2000.
    ShareCECM 261 - XP Level IV
    Favorite

  • CECM 262: Introduction to MicroSoft Office XP

    3.00 Credits
    Tompkins Cortland Community College

    This workshop is designed to meet the needs of a new user, self taught, or transitioning user of Microsoft Office. It will allow you to become mor familiar with, and take advantage of, all the capabilities offered with Microsoft XP. In this class you will learn: step by step procedures for using Word, Escel, PowerPoint and Access how to increase your productivity by learning new shortcuts how to save time on projects how to build a presentation through the use of PowerPoint and Excel gain valuable information fromorganizing spreadsheets, budgets, inventory, work hours, graphs, and charts converting text quickly from an older version of Office to be utilized effectively in XP
    ShareCECM 262 - Introduction to MicroSoft Office XP
    Favorite

  • CECM 264: XP Level II

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: -create and format sections as multiple columns, work with text in columns, and edit and remove sections and columns -modify tables by applying borders and shading, use the Table AutoFormat feature, and draw tables -import data from Excel into Word, link data from Excel by using the Paste Special feature, and perform calculations on table data by using formulas -create and use paragraph styles, and use the Outline feature, Document Maps, and AutoText entries -create headers and footers, and use the Page Numbers dialog box -insert graphics, files, WordArt, symbols, and watermarks in a document; use the Drawing Canvas and the Diagram Gallery -use and customize templates to create consistent-looking documents -compare and merge documents, and work with comments -use advanced printing options, and print labels and envelopes Prerequisites: Word Level I or equivalent knowledge.
    ShareCECM 264 - XP Level II
    Favorite

  • CECM 265: XP Level III

    3.00 Credits
    Tompkins Cortland Community College

    You will learn to: -use the Mail Merge Wizard to create form letters, add fields to a form letter, use data source files to sort and query data, and create mailing labels -create, modify, protect, and use forms -create a master document, table of contents, table of figures, endnotes and footnotes, index, bookmarks, and cross-references in documents -track changes in a document; create, save, and compare document versions; and insert, edit, and delete comments -record and run macros to automate tasks, modify and delete macros, create and delete custom menus and toolbars, and add buttons to toolbars Prerequisites: Word Level II or equivalent knowledge.
    ShareCECM 265 - XP Level III
    Favorite
To find college, community college and university courses by keyword, enter some or all of the following, then select the Search button.
(Type the name of a College, University, Exam, or Corporation)
(For example: Accounting, Psychology)
(For example: ACCT 101, where Course Prefix is ACCT, and Course Number is 101)
(For example: Introduction To Accounting)
(For example: Sine waves, Hemingway, or Impressionism)
Distance:
of
(For example: Find all institutions within 5 miles of the selected Zip Code)