| |

These quality, short-term, and practical computer training courses are offered to both individuals and businesses at any skill level and are taught in person at our Taylorsville Redwood Campus. Employers: We can also schedule custom training at your location or at any SLCC campus that is the most convenient. Word Level I CECW 0110 | | Prerequisite: Basic knowledge of Windows. This module teaches students how to create, format, print and save Word documents. Tasks include text editing, cut, copy and paste; spelling and grammar tools. Students will also learn how to work with document views and print options. Tasks include character, paragraph, and document formatting; using styles; setting tabs; indenting paragraphs; and using numbers and bullets. The students will also learn how to work with headers and footers, and section breaks. View sections |
Word Level II CECW 0124 | Prerequisite: Knowledge of Word Level I. Everyday Tasks Made Easier Module This module covers many of the features that can make everyday tasks quicker and easier. The student will learn how to insert dates and symbols; create and edit Tables, apply borders and shading. The student will also learn how to insert, move and size graphics, Watermarks, WordArt and drawing objects; create and modify Templates and Wizards; create Newsletter-Style Columns. Advanced Features Module This module covers Mail Merge, creating a Data Source, merging mailing labels, catalogs and Outlook Data Sources. Students will also learn how to Sort Table Data, use and format Bullets and Numbered Lists; record macros, run Macros, and create Macro Buttons. View sections |
Word Level III CECW 0125 | Prerequisite: Knowledge of Word Level I. Word Helpers Module This module covers several topics that help the student perform tasks more efficiently. Tasks include using AutoFormat, AutoCorrect, AutoText, Find and Replace, and Thesaurus. Students will also learn how to use Outline view, Insert Diagrams, inserting Hyperlinks. Working with Long Documents Module This module covers working with long documents. Tasks include creating Section Headers and Footers, creating a Table of Contents, working with Table of Authorities, creating a document Index; creating Bookmarks, Footnotes, and Endnotes. Students will also learn how to Track Revisions, use Comments and create Master Documents. View sections |
Excel Level I CECW 0210 | | Prerequisite: Basic knowledge of Windows. Learn Excel tools/shortcuts and become more productive. This module introduces the basic skills necessary for creating, printing and saving Excel workbooks. Students will create basic formulas and functions, absolute references, work with ranges, auto-fill, and copy/move data; covers basic skills needed to prepare worksheets for printing; page setup, Headers & Footers, format numbers, text, cells, borders, columns, rows and AutoFormat. View sections |
Excel Working with Large Worksheets CECW 0211 | | Prerequisite: Knowledge of Excel Level I . Tasks include working with multiple worksheets, navigating worksheets, inserting/deleting worksheets, moving worksheets, copying worksheets, and re-naming worksheets. Other topics covered include creating 3-D formulas or formulas using multiple worksheets and multiple workbooks; freezing panes, splitting the window, working with outlines, sorting data using ascending/descending order, find/replace data and using Range Names. View sections |
Excel Charts & Graphics CECW 0212 | | Prerequisite: Knowledge of Excel Level I. Tasks include creating, formatting and editing charts; changing chart types, moving, sizing and formatting chart objects, legends, data table, source data, and printing charts. Advanced chart formatting of Gridlines, Axis, Secondary Axis, Trendline, and user defined Charts. Students will also learn how to draw lines, boxes, ellipses, flow charts, connectors, arrows, stars, banners and AutoShapes. View sections |
Excel Database Mgmt/Pivot Tables CECW 0213 | | Prerequisite: Knowledge of Excel Level I. Learn how to take raw data and create valuable management reports using Tables. Filter data with AutoFilter and Advanced filters; perform Multiple-field sorts; format data using Conditional Formats, Data Validation, Subtotals, Database functions, Data Form and export/import data. Create PivotTable reports, add/move PivotTable fields, change/format PivotTables, and create PivotTable Charts. View sections |
Excel Using Advanced Functions CECW 0214 | | Prerequisite: Knowledge of Excel Level I. This module introduces advanced Excel functions including Function Arguments, Financial Functions; Logical Functions, VLOOKUP, HLOOKUP, IF, AND, OR and ISERROR advanced functions. Students will learn how to solve problems using Scenarios, Goal Seek, Data Tables and Custom Views. View sections |
Excel Organizational Tools CECW 0215 | | Prerequisite: Knowledge of Excel Level I. This module introduces the skills to organize Excel information; creating, viewing and using Comments; using the Auditing Tools and WatchWindow; worksheet Protection, Workbook Protection, assigning and removing passwords. Students will also learn how to create and use Excel Templates, share Excel workbooks with others and track changes to shared workbooks. View sections |
Excel Macros, Toolbars, and Macro Buttons CECW 0216 | | Prerequisite: Knowledge of Excel Level I. This module introduces the skills necessary to Define, Record and Run Excel Macros. Students will learn how to edit Macros, enter Macro Commands, use Relative and Absolute References; assign Macro shortcut-Keys, create a Macro Toolbar Button to run macros and create and modify macro buttons. View sections |
QuickBooks Pro Beginning CECW 0230 | Prerequisite: Basic understanding of Windows. This workshop will review general accounting basics, how QuickBooks works, set up of student company file, customize chart of accounts, set up bank account, go through all the menus and reports available, customize desktop, merging names, profit and loss report, balance sheet, tracking loans from owners, historical data entry, writing letters by exporting to Word. Accounts Rec. - create items for invoicing, generate cash sale, create customers, generate invoices, look at reports, receive payments, make deposits, payment terms. Accounts Payable - adding vendors/1099 contractors, entering bills and credit memos, discount terms, paying bills, A/P reports. View sections |
QuickBooks Pro Intermediate CECW 0231 | Prerequisites: QuickBooks Beginning - builds on material learned in prior class. Tracking fixed assets and their associated liabilities, depreciation, prepaid expenses, memorized transactions, making deposits not related to receivables, sales tax, bank reconciliation's, petty cash, custom/memorized reports, budgets, accountants review, credit card transactions. Accounts Receivable - customize sales forms, accounting for retainer payments from customers, receiving payments at a discount, refunds to customers, finance charges, statements, and bounced checks. View sections |
QuickBooks Pro Advanced CECW 0232 | Prerequisites: QuickBooks Intermediate; builds on material learned in prior class. Payroll, payroll, payroll -- setting up and tracking payroll liabilities, adding employees, adding payroll items, year-to-date payroll issues, payroll additions and deductions, preparing quarterly 941, making payroll tax deposits, process payroll checks, payroll reports. Job Costing - time tracking, estimates, progress billing, job cost reports, Inventory Management - adding inventory items, purchase orders, receiving inventory, inventory reports, cost of goods sold, adjustments to inventory. General - Accounting for trades, writing off bad debt, passwords, graphs, year-end issues, W-2's, 1099's, 940, Find feature, statement of cash flow. View sections |
Windows Introduction CECW 0305 | | Learn the basics of Personal Computers hardware/software components, Windows features, Start Menu, Taskbar, views and toolbars. Tasks include using multiple windows; opening, moving, sizing, closing, switching between windows; working with multimedia files; Cut, Copy and Paste. Students will learn File Management; how to organize files, folders, and shortcuts; work with Windows Explorer; and search for files and folders. Tasks include using the Recycle Bin, Customizing the Display, My Computer, Desktop, screen saver, wallpaper, Accessories and Control Panel. View sections |
A+ Computer Training CECW 0310 | | The A+ training helps student learn basic-to-advanced PC hardware and Windows operating system installation, configuration, and troubleshooting. This workshop helps students prepare to take the A+ certification exam. View sections |
Network+ Computer Training CECW 0312 | | Prerequisite: A+. The Network+ training covers basic networking concepts for connecting to a network and setting up a small office/home office (SOHO) network. This workshop helps students prepare to take the Network+ certification exam. View sections |
Security+ Computer Training CECW 0314 | | Prerequisite: Network+. The Security+ training covers critical security concepts and skills required for military IT personnel as well as for an increasing number of IT security jobs with corporations and government. This workshop helps students prepare to take the Network+ certification exam. View sections |
Access Level I CECW 0405 | | Prerequisite: Basic knowledge of a database and Windows. Tasks include creating & working with tables, editing tables, column width, row height, finding and filtering records, sorting records, using Filter by Selection, Filtering by Form and advanced filters. Students will also learn how to print table data, print selected records, use simple queries, use the Simple Query Wizard, modifying query results, creating basic forms, using Form Wizard, basing a form on a query, using AutoForm, creating basic reports, using the Report Wizard, basing a report on a query and using Help. View sections |
Access Level II CECW 0406 | | Prerequisite: Access Level I. Tasks include modifying tables, setting field properties, using queries with And/Or comparison operators, designing advanced queries, creating a calculated field, using multiple tables in a query, creating action queries, using advanced query wizards and database features, file utilities; using advanced features of forms and reports, designing forms & reports, using editing tools and advanced design functions. View sections |
Access Level III CECW 0407 | | Prerequisite: Access Level I and II. Introduces more advanced features including working with charts, using subforms & form letters, creating custom controls, indexing and replicating databases; creating saving, and running macros, assigning actions, conditions and creating group macros. Also includes creating and modifying switchboards, custom menus and toolbars. View sections |
Access - Advanced Topics: Query Techniques CECW 0408 | | Prerequisite: Access Levels I and II . Introduces students to advanced query writing skills. Tasks include techniques for basing one query upon another, using Functions in queries, adding conditional 'IF' statements to calculations, and troubleshooting complex queries. View sections |
Access - Advanced Topics: Reporting Techniques CECW 0409 | | Prerequisite: Access Levels I and II. Introduces students to advanced report writing skills. Tasks include creating a custom form for entering query criteria for the report, printing criteria on a report, changing the sort order of a report on the fly, and using sub-reports. View sections |
Access - Advanced Topics: Macro Techniques CECW 0410 | | Prerequisite: Access Levels I, II and III. Introduces students to advanced uses for macros and how macros relate to Visual Basic. Tasks include creating macro groups for better organization, using the SetValue macro to set properties, creating a splash screen and converting macros into visual basic code. View sections |
Access - Advanced Topics: Security CECW 0414 | | Prerequisite: Access Levels I, II and III. Learn to set up User/Group Level security for your MS Access database. Students will learn how to set up security using the Security Wizard, create/modify user names and passwords, use the MS Access Workgroup Administrator, apply user groups to make essential security changes, implement security on a network, work with the .MDW security file, customize user/group rights, use security to customize your database’s look and feel. View sections |
MS Outlook Level I CECW 0504 | Prerequisite: Basic knowledge of Windows. Students will learn the skills necessary for working with Outlook Messages, Calendar, Tasks, Contacts and Notes. Students will learn how to send and receive email, forward and reply to emails, send and receive attachments; schedule appointments with the Calendar; manage names and addresses with Contacts, create and use Tasks and Notes. The workshop is filled with hands-on, interactive exercises to help student retention. Introduces the skills necessary to use Microsoft Outlook, Email, Calendars and Tasks. Students will learn how format Outlook messages, create HTML messages, and use the Address Book. Tasks also include organizing with folders, customizing views, setting Outlook options and using Outlook Bar shortcuts. View sections |
Microsoft Office Suite CECW 0507 | Prerequisite: Basic knowledge of Windows. Students will learn the basics of Microsoft Office Suite, including Word, Excel and PowerPoint. For class content, please view descriptions for Word Level I, Excel Level I and PowerPoint Level I. MS Office software is included in the price of this workshop! View sections |
MS Project CECW 0508 | Prerequisite: Basic knowledge of Windows. Use Microsoft Project to manage projects more efficiently and effectively. Students will learn how to start, save, print and close a project. Students will also learn how to open existing projects, use a project template, work with Tasks, adjust Tasks, and outline Tasks and Views. This workshop covers how to create, assign and adjust resources. Students will learn how to create change and assign calendars, define costs, assign costs, and work with the critical path. Students will learn how to work with the critical path, baselines, earned value, reports, how to filter, sort and group information, customize project information and track the progress of a project. This workshop also covers how to finalize a project, how to evaluate, distribute project data, and work with multiple projects, master projects, subprojects and resource pools. Tasks also include how to import and export data and work with graphics. View sections |
Introduction to PC CECW 0515 | | Learn the basics of Personal Computers. Students will review PC hardware/software components, Windows features, Start Menu, Taskbar, views and toolbars. Tasks include using multiple windows; opening, moving, sizing, closing, switching between windows; working with multimedia files; Cut, Copy and Paste. Students will learn File Management; how to organize files, folders, and shortcuts; work with Windows Explorer; and search for files and folders. Tasks include using the Recycle Bin, Customizing the Display, My Computer, Desktop, screen saver, wallpaper, Accessories and Control Panel. View sections |
Internet Overview CECW 0601 | | Prerequisite: Basic knowledge of Windows . Introduces the skills necessary to begin using the Internet. Students will learn Internet terms and definitions, how to use Internet Explorer and Firefox browsers, how to navigate forward, back and home, how to use search engines to locate information, create bookmarks, and how to print information. Internet email (Yahoo, Gmail or Hotmail) and social networking sites will also be explored. View sections |
Dreamweaver CECW 0603 | Prerequisite: Basic knowledge of HTML and Windows. Module One This workshop is designed to give proficiency in using Dreamweaver to create, design, and update Web pages and entire Web sites. Introduces basic Web and HTML concepts, navigate and customize the Dreamweaver environment, and work with the Code Inspector, the Tag Inspector, and the Quick Tag Editor. Plan and define a Web site, create, save, and import text in a document, and modify page properties. Define headings and paragraphs, create lists and special characters, import Microsoft Office documents, and check for spelling errors in a document. Insert tables, add text content, insert and delete rows and columns, create table headers, align text in table cells, modify table properties, and create table summaries. Module Two This module uses interactive exercises to help students gain proficiency in creating templates, forms, rollovers, basic animations and database-driven pages. Create and draw layers, modify layer properties, embed a Flash movie in a layer, and apply behaviors to layers. Identify the basic concepts of database-driven pages, set up a database-driven Web site, create a recordset and display records, create a recordset navigation bar, create a master/detail page set, and add search capability to a Web page. Check a document for browser-specific compatibility problems and code errors, and apply the Check browser behavior. View sections |
Flash CECW 0607 | Prerequisite: Knowledge of Windows and experience working with images. Module One This workshop teaches students the fundamentals of using Flash to design animations for the Web. Introduces skills necessary to create and edit shapes, apply colors and line styles, combine and group shapes and use external images. Topics include using layers to arrange shapes, modify layers, create frame-by-frame animation, and work with templates. This workshop is filled with interactive exercises to help improve student retention. Module Two This workshop builds on the fundamentals taught in Flash Level I. Students learn how to create, edit and animate symbols and shapes; work with instances to create more complex animations. Students add interactivity to movies by using the ActionScript and the Actions panel, and store and perform calculations by creating fields. Course activities also cover adding sound to layers and buttons, editing sound objects, importing and managing video and associating sound and video in Flash. Students test the download performance of a movie, create a pre loader, and publish a movie on the Web. View sections |
Selling on eBay - Seller Basics CECW 0609 | | Prerequisite: Basic knowledge of Windows, Email and Internet. Sell Sell Sell - Get rid of your clutter! Topics covered include opening a seller account, doing effective research, creating listings, setting pricing, opening a PayPal account, leaning how to monitor your listings, completing transactions, and learning how to pinpoint fraud. Students are encouraged to bring an item to class to create their first listing as a seller during this course. View sections |
CSS/XHTML CECW 0612 | Prerequisite: DreamWeaver. This hands-on workshop will build upon the concepts from the DreamWeaver Workshop. CSS stands for Cascading Style Sheets and students will learn how to use CSS & XHTML to control the style and layout of multiple Web pages. Using CSS allows you to save time designing, updating and maintaining Web pages as well as presenting a consistent appearance for your Web pages.- Understanding Selectors
- Page layouts using CSS
- Foreground and background properties
- Typography
- Margins and borders
- Styling Tables
- Styling for Print
View sections |
MS Publisher Introduction CECW 0701 | | Prerequisite: Basic knowledge of Windows and MS Word. Tasks include exploring Publisher, working with publications, using the Wizard, adding text to a frame, correcting spelling errors, enhancing publication text, printing and publishing presentations. Students will also learn how to insert, size, format, and rotate objects and Graphics. Customize color schemes, use tables and mail merge. View sections |
MS PowerPoint Level I CECW 0703 | | Prerequisite: Basic knowledge of Windows and MS Word. This module introduces the skills necessary to create, modify, save and print PowerPoint presentations; introduces presentation skills, working with the outline tab, Design Templates and AutoContent Wizard, Speaker Notes and Outline Tab. Students will also learn how to format text, bullets, drawing objects, slide format, and slide layout; insert, move and size images/pictures. This module covers how to print slides and handouts, move, duplicate and sort slides; set Slide Transitions, run and navigate a Slide Show. View sections |
MS PowerPoint Level II CECW 0704 | | Prerequisite: PowerPoint Level I. This module covers working with the editing tools to create more advanced presentations. It includes tasks such as creating charts; creating and using tables; adding special effects, customizing presentations with Custom Color Schemes, editing presentation masters, notes masters, handout masters and saving a Custom Template. Students will learn how to set up slides with Special Effects, Animation, Sound and Video. Tasks include presenting to a wider audience, Action Buttons, and jumping to another Presentation. Students will also learn how to edit and import charts; create custom charts, use organization charts and diagrams, and export outlines and presentation slides. View sections |
Photoshop Level I CECW 0800 | Prerequisite: Knowledge of Windows and experience working with images. This workshop is designed to help students create images for both print and the Web. Students will use Photoshop's basic tools, palettes, and features to create images, retouch photographs, and save files using multiple file formats. Tasks include viewing tools, image and canvas size; Selection Tools, Crop, Trim, Skew, Distort and Perspective commands. Explore layers, create, placement, visibility, format and flatten. Edit foreground and background colors by using the Color and Swatches palettes, the color ramp, and Color Picker, choose custom colors, pick colors by using the Eyedropper tool, create gradients, draw with the Pencil and Brush tools, create customized brushes, use the Eraser tool, the History palette, and History brush tools, and use the Clone and Pattern Stamp tools and the Pattern Maker command. Retouch images using Auto Color, the Healing Brush, the Dodge, the Burn, the Sponge, the Blur, the Sharpen, and the Smudge tools. View sections |
Photoshop Level II CECW 0801 | Prerequisite: Photoshop Level I. This workshop covers the advanced features and functions of Photoshop. Before taking this course, students should have basic photo editing skills, and they should know how to create simple shapes and drawings. Students will learn how to create artwork for both print and the Web. The workshop is filled with interactive exercises that help ensure student retention. Topics include Shape Tools, Histogram Palette, Layer opacity and effects, Layer Comps Palette, Channels Palette, Quick Mask, Horizontal Type Mask tool, Background Eraser Tool and Extract command. Apply Noise and Rendering Filters, Brush Strokes Filter, Texture Filter and Liquify Filter to modify images. Automate Photoshop commands, Crop/Straighten Photos, and PDF presentation. Soft proof images, set print options, optimize images create slices, and save optimized and sliced images. View sections |
Adobe Acrobat Professional CECW 0803 | Prerequisite: Basic knowledge of Windows. Provide students with the skills needed to create, edit, save and secure PDF documents. Tasks include how to convert paper documents to PDF documents, add navigation, comments, digital ID, password security, and create forms/templates. Create interactive forms and apply text boxes, combo boxes, list boxes, radio buttons, check boxes, signature fields, and buttons; define the tab order; and import and export form data. Number pages, add headers, footers, watermarks, and backgrounds to pages, and create presentations. View sections |
Adobe Illustrator Level I CECW 0804 | | Prerequisite: Knowledge of Windows and experience working with images. Introduces students to Adobe Illustrator; how to start Illustrator, open a file, and identify interface components; navigate in the artwork window; create, save, print and close files. Create rectangles, ellipses, polygons, stars, spirals, flares and text; modify object placement and size; use the Paintbrush tools; create new brushes and symbols. Create and edit simple and complex paths by using the Pencil and Pen tools. Add colors, patterns, and gradients to objects; modify strokes; and copy paint attributes between objects. View sections |
Adobe Illustrator Level II CECW 0805 | Prerequisite: Illustrator Level I. This workshop is filled with interactive exercises designed to help students create artwork for both print and Web using Illustrator. Students will learn how to use advanced features to Transform objects, apply Filters and Effects, automate tasks, modify Images, 3D effects, Liquify and Symbolism Tools. Manage colors by applying blending modes and gradient meshes, create masks to hide and reveal areas of underlying artwork through specific shapes, discuss filters and effects, use Colors filters to adjust, blend, and invert colors, use the Distort filters to pucker and bloat, roughen, scribble and tweak, and twist objects, use Pen & Ink filters to apply hatch effects and create new hatch effects Convert shapes, add drop shadows, feather edges, and apply warp effects, automate tasks with actions and Data-driven graphics and slices. View sections |
Adobe InDesign Level I CECW 0806 | Prerequisite: Knowledge of Windows and experience working with images . This workshop helps students design and produce professional print documents and layouts. Students will learn how to manipulate text, shapes, colors, and frames to create eye-catching print products. Use Toolbox, palettes, and navigation tools; add text and pages to a document; place an image in a master page; insert auto page numbers; import text, thread, and unthread text frames; create and modify character and paragraph styles; use the Tabs palette; edit text, text outlines. Create basic shapes; transform objects by using the Selection, Scale, Rotate, Shear, and Free Transform tools; copy and duplicate objects; arrange, align, group, and ungroup objects. Create paths by using the Pencil and Pen tools; Direct Selection, Anchor Point, Smooth, Erase, and Scissors tools; create and apply color swatches. Crop and mask images in frames; apply frame fitting options and special effects such as drop shadow, feather, and corner effects; create and edit tables. View sections |
Adobe InDesign Level II CECW 0807 | Prerequisite: Indesign Level I. Students will learn how to manipulate page layout, control the appearance of text and tables, and create books, tables of content, and indices; convert documents to PDF, HTML, and XML format, work with XML features and tags, and apply a variety of print options. How to create and manipulate grids and guides; define and apply document presets, zero point; use the Info Palette, create, duplicate, edit, and delete master pages. Create layers; hide, lock, duplicate, and delete layers; move and copy objects between layers; and rearrange and merge layers. Create and manage book file documents, hyperlinks, bookmarks, insert sound and movie objects, and create interactive buttons. Create a print preset, print a document, preview color separations, and specify printer’s marks. View sections |
Premier Elements Introduction CECW 0820 | Prerequisite: Basic understanding of Windows. Students will learn how to create a movie using Adobe Premiere Elements software. This hands-on course guides students through the process of creating a movie from start to finish, leaving time for questions and answers about the many editing options that Adobe Elements provides. Topics covered will include:- Capturing video and audio, and collecting project content
- Organizing and naming video clips to increase productivity
- Assembling and manipulating clips on the timeline
- Using transitions, sound effects and voiceover
- Creating titles that enhance your movie
- Producing a finished product (either in DVD format and/or uploaded to a website such as YouTube). The finished DVD will include a menu.
Students are encouraged to bring video to the class in the form of a USB camera (a Flip Camera, for example), or a DVD. Stock footage can be provided for those who do not have footage. We may not be able to use video from all formats for the purposes of the class. View sections |
MS Visio CECW 0825 | | Prerequisite: Basic knowledge of Windows. Use Microsoft Visio software to communicate information by using diagrams. Students will learn about the Visio environment how to use stencils, scale and resize objects, draw basic shapes, manipulate compound lines, and distribute and group objects. They will also learn how to create network diagrams, drawings, org charts, work with text, format shapes and lines, apply a background page, advanced layout and connection techniques. View sections |
|
|
|