Microsoft Excel Training Certificate
Successfully complete all three classes and receive a Microsoft Excel Training Certificate and receive 1.8 CEUs. Classes may also be taken individually if you do not wish to obtain the certificate.
Introduction to Microsoft Excel 2016
Enter and edit information. Create and copy simple formulas and functions. Use Cut/Copy/Paste and Drag and Drop to duplicate or reorganize data. Apply borders, shading and other formats. Sort and graph your data. Prerequisite: Windows knowledge.
Wed, Sept 6-13, 6:30-9:30 p.m., 2 wks Littleton Campus
COMP 1007F02-68043 $179, includes manual closed
Fri, Sept 22, 9 a.m.-4 p.m. Littleton Campus
COMP 1007F01-68042 $179, includes manual closed
Fri, Nov 3, 9 a.m.-4 p.m. Parker Campus
COMP 1007FP1-68044 $179, includes manual
Intermediate Microsoft Excel 2016
Work with multiple and large workbooks. Enter a 3D formula. Learn about outlines, subtotals, tables, and lists. Apply names to ranges. Practice advanced graphing techniques. Prerequisite: Introduction to Excel or equivalent knowledge.
Wed, Sept 20-27, 6:30-9:30 p.m., 2 wks Littleton Campus
COMP 1008F02-68046 $179, includes manual closed
Fri, Sept 29, 9 a.m.-4 p.m. Littleton Campus
COMP 1008F01-68045 $179, includes manual
Fri, Nov 10, 9 a.m.-4 p.m. Parker Campus
COMP 1008FP1-68050 $179, includes manual
Advanced Microsoft Excel 2016
Create and use pivot tables and charts; lookup functions and multiple workbook techniques; create and edit macros and customize toolbars. Prerequisite: Intermediate Excel or equivalent knowledge.
Wed, Oct 4-11, 6:30-9:30 p.m., 2 wks Littleton Campus
COMP 1009F02-68049 $179, includes manual
Fri, Oct 6, 9 a.m.-4 p.m. Littleton Campus
COMP 1009F01-68048 $179, includes manual
Fri, Nov 17, 9 a.m.-4 p.m. Parker Campus
COMP 1009FP1-68047 $179, includes manual
If you are a new or an existing SharePoint user, this program will provide you with the skills you need to work within and manage SharePoint sites. Explore SharePoint versions, layouts, and navigation, list and library views. Manage sites and page content, including wiki pages. Explore forms libraries, creating InfoPath forms, and managing site columns and content types. Discover SharePoint integration with Office applications, managing SharePoint site permissions, and participating in user communities.
This is an 80 hour online program completed at your own pace. When you register, you receive six (6) months to complete this program. Cost is $795. Register now.
These are 6-week, 24 hours of instruction, online classes which begin the 2nd Wednesday of every
month. These classes are $129.
Master the basics of the word processor PC Magazine ranked as one of the “strongest and most intelligent programs ever written.” By the time you’re done with the step-by-step lessons and hands-on activities in this course, you’ll be able to use Word confidently at home or on the job. Create, edit and save documents; explore cut, copy, paste and delete text word commands. Practice formatting and paragraph features, bullets and numbered lists; check grammar and spelling; and use the thesaurus.
Explore styles, section breaks, and columns and how to format tables. Use graphics, draw and edit shapes, and create text boxes. Learn how to print out labels, form letters, creating indexes, and envelopes. Learn to insert different types of graphics in a document including digital photographs from your own camera, clip art images provided by Microsoft, and different types of charts such as bar, line, or pie charts. Prerequisite: Introduction to Word or equivalent knowledge.
Take control of your data! In this course, you’ll learn how to harness the power of Microsoft Access to organize, store, edit, manage, and report on hundreds of thousands of records. Start with the basics of database concepts and structure. Build and customize tables to store data. Learn about relational databases, and see how you can use them to build forms, generate reports, and search for data with queries across thousands of records in hundreds of tables—often with just a few clicks of your mouse! Discover how to use macros to automate repetitive tasks and increase your efficiency.
Take your skills to the next level. Build an entire database project from scratch. Track customer and order information. Using action queries, add and update key fields that allow you to build relationships among the tables. Master the steps for building complex yet easy-to-use forms to manage table data. Build crosstab and summary queries so you can access information quickly and easily. Examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Build a navigation form to make it easy for your users to find what they need.
Computer Basics for Laptop and Desktop Devices
Take this is you who have little or no experience with personal computers and want to learn the basics. Explore the main components of a typical computer system and the basic elements of the Windows interface. Navigate in Windows Explorer, organize files and folders, search for items on a computer, and personalize Windows. Learn to use an Internet browser and explore tips for routine maintenance. Computers provided.
Tue/Thu, Oct 10/12, 6-9 p.m., 2 sessions Littleton Campus
COMP 1001F01-68058 $119, includes manual
Tue, Nov 7-14, 6-9 p.m., 2 sessions Parker Campus
COMP 1001FP1-68059 $119, includes manual
Explore Windows Hands-on
Bring your own Windows devices or use ours (Windows 10) and explore this operating system. Organize and navigate through information on your device and learn about the file
management system. Learn how to log on and discover tools and programs installed as well as helpful ones to consider. Discuss how to keep your device secure with Access Control and Defender and how to troubleshoot potential issues.
Fri, Oct 6-13, 2-5 p.m., 2 wks Littleton Campus
COMP 1012F01-68060 $179, includes manual closed
These are 6-week, 24 instructional hours, online classes which begin the 2nd Wednesday of every month.
|Course Name||Course Number||Cost|
|Introduction to PC Troubleshooting||ONLI 1214||$119|
|Introduction to Windows 8||ONLI 1177||$119|
|Introduction to Windows 10||ONLI 2029||$119|