CollegeTransfer.Net

Course Criteria

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

    You will learn to: -navigate large worksheets effectively by using magnification and frozen panes and control the printing of large worksheets -navigate, manage, and print multiple worksheets, link workbooks by 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 trendlines, 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 complex 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.
  • 3.00 Credits

    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 a 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 PivotTables 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 repetitive tasks -publish a worksheet as an interactive Web page Prerequisites: Excel Level II or equivalent knowledge.
  • 3.00 Credits

    No course description available
  • 3.00 Credits

    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 inresponse 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.
  • 3.00 Credits

    The Advanced Photoshop class will introduce the automated features in Photoshop, including photomerge, picture package, PDF presentation and Photo Web Gallery. We will explore advanced features for using type, including type warping, layer styles and type along a path. Non-destructive working methods will be emphasized in tutorials including: working with layer masks, blending modes, non-destructive burning and dodging, using a retouching layer and use of adjustment layers. The history palette and history brush and channels will be used in tutorials. Finally we will look at color management in Photoshop and discuss monitor calibrating and print profiling. Prerequisites: PhotoShop, Level I or instructor's approval
  • 3.00 Credits

    Extend your knowledge of Visual Basic code and programming tools. You will learn: -object collections and arrays -text files and text strings -external database sources -Windows API -FlexGrid control (embedded speadsheet object) -ActiveX controls -progress bar, status bar, and other information controls Prerequisites: Visual Basic 6.0 Level I or equivalent knowledge.
  • 3.00 Credits

    This introduction to HTML scripting will teach you how to create a Web page with formatted text. Learn how to create links between multiple documents, links to other Web sites, and link to different sections of a single Web page. Prerequisite: A basic knowledge of the use of the computer and the Internet is required for this workshop.
  • 3.00 Credits

    Forms provide a way for you to receive information from those who view your web pages. They include a variety of input formats, such as "text boxes" and "check lists". This workshop will demonstrate the basics of how to add this powerful feature to your web pages. Prerequisite: Knowledge of Basic HTML.
  • 3.00 Credits

    If you want to spice up your web pages, then this workshop is for you! More advanced than HTML, JavaScript is a programming language that lets you create compelling visual and interactive effects on your web pages. This workshop will introduce you to the basics of this powerful resource. Prerequisite: Basic knowledge of HTML and Web graphics.
  • 3.00 Credits

    Once you create a web page, you need to transfer the file from your computer to a web server on the Internet. This workshop demonstrates how to download and use the popular program "WS-FTP" to get your pages published on the web. Prerequisite: Knowledge of Basic HTML.
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)