Noncredit Schedule of Classes

Are you a new computer user? Learn the basics of Microsoft Windows, file management, Microsoft Word, Microsoft Excel, Microsoft Access and Microsoft PowerPoint. Topics include creating a document, developing a spreadsheet, creating a database, and creating a presentation. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Expand your knowledge of Microsoft PowerPoint with the advanced features of the software. Topics include working with charts; updating a linked Excel worksheet; creating custom tables; designing and formatting SmartArt; animating a chart; adding action buttons; adding comments; creating a custom show; and packaging a presentation. Prerequisite: Learn PowerPoint in a Day. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Expand your intermediate knowledge of Microsoft Excel by learning the advanced features of the software. Topics include creating pivot tables; creating a template; using advanced analysis features; inserting comments; embedding an Excel chart into a PowerPoint slide; and importing a table into Access. Prerequisite: Excel Intermediate Features. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Earn your nationally recognized certification as a Microsoft Office Specialist (MOS) and improved your earning potential and employability. Each course in this series prepares students to sit for one of the five single application exams/certifications. This Excel, MO-200, preparatory class is a comprehensive class that covers the following Excel skills: managing worksheets and workbooks; managing data cells and ranges; managing tables and table data; building and using formulas and functions; and creating and managing charts. This curriculum is ideal for improving your ability to edit a workbook with multiple sheets and use a graphic element to represent data visually. Learn to create professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Expand your knowledge of Microsoft Excel by learning to create more complex workbooks. Topics include creating, modifying, and formatting charts; analyzing table data; creating and running simple macros; and using what-if analysis. Prerequisite: Learn Excel in a Day. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Learn the fundamentals of database design and explore key terms and concepts within Microsoft Access. Topics include creating a database, using queries to find and analyze data, and designing simple forms and reports. Prerequisite: Working knowledge of Windows. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Discover the uses of Microsoft Project. Topics include creating a task list; setting up resources; assigning resources to tasks; formatting and sharing your plan; tracking progress on tasks; and fine-tuning task details, resource details, assignment details, and the Project Plan. Prerequisite: Working knowledge of Windows. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Maximize your time with tools and techniques to create professional spreadsheets. Topics include creating a spreadsheet from scratch; inserting formulas and functions; using formatting features; and creating a simple chart. Prerequisite: Working knowledge of Windows. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Create imaginative and attention-grabbing PowerPoint presentations using Clip Art, animation, sound effects, web collaboration, and hyperlinks. Topics include creating a presentation, modifying a presentation, inserting objects, modifying Masters, and customizing animation affects. Prerequisite: Working knowledge of Windows. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree waivers apply. Transcript available.

Learn how to use Microsoft Word to make professional-looking documents both visually appealing and dynamic. Topics include formatting text and paragraphs; working with tabs and margins; adding borders and shading; inserting headers and footers; adding and formatting page numbers; and creating, formatting, and editing tables. Prerequisite: Working knowledge of Windows. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Earn your nationally recognized certification as a Microsoft Office (MOS) and improved your earning potential and employability. This course prepares students to sit for the MOS-100 Word exam, MO-200 Excel exam, and the MO-300 PowerPoint exam required to earn the MOS Specialist Associate certification. Senior adult and disabled retiree tuition waivers apply. Transcript available.

These online, live demo sessions have been designed to help you increase your Microsoft office skills without taking off work. Over a long lunch, learn many useful features for the software we use on a daily basis. This convenient format allows you to ask questions and get immediate answers with a live instructor. A recording of the session is included in the cost! Class 1: We often use more than one program. Did you know that many shortcuts can be used across all the Microsoft suite? In this class you will gain speed across the Microsoft Suite with understanding universal shortcuts. This course will show many techniques and shortcuts that can be used in Word, Excel, PowerPoint and Outlook. You will learn shortcuts covering formatting, screenshots, graphing styles, views and much more. Class 2: In this class you will learn many shortcuts for working in Word. There are keyboard shortcuts that help with formatting text, paragraphs & lists You will learn how to insert pictures and screenshots effectively without messing up your document. Using Quick Parts, Styles and Templates will improve the speed of formatting a document. Class 3: In this Word Styles and Table of Contents class you will achieve the ability to quickly format a document and then use that formatting to easily create a Table of Contents. Styles are hugely underused and can help not only with formatting but with outlining a document. You will also learn additional shortcuts with using the Format Painter and the keyboard shortcut F4 to format text, paragraphs and an entire document. Class 4: In this class you will learn how to create a mail merge for documents from start to finish. You will learn how to create data sources within Word or Excel. You will also learn how to use mail merge with envelopes and labels.

Earn your nationally recognized certification as a Microsoft (MOS) and improved your earning potential and employability. Each course in this series prepares students to sit for one of the five single application exams/certifications.This Outlook, MO-200, preparatory class is a comprehensive class that covers the following Outlook exam competencies: the ability to enhance professional correspondence, create calendars, and schedule appointments. Application examples include coordinating building resources, sending messages for marketing campaigns, planning staff meetings, and assigning meeting action items. This curriculum will help you manage workloads, meetings, and calendars with ease.

Earn your nationally recognized certification as a Microsoft Office Specialist (MOS) and improved your earning potential and employability. Each course in this series prepares students to sit for one of the five single application exams/certifications. This PowerPoint, MO-300, preparatory class is a comprehensive class that covers the following PowerPoint skills: Creating and managing presentations; managing slides; inserting and formatting shapes and graphic elements; inserting tables, charts, and other media; applying transitions and animations. This curriculum will help you create professional and engaging presentations.

Learn to automate business finances, including how to set up a new or existing company and enter customers, vendors, invoices, cash sales, bills, items bought and sold, and resale items. Additional topics include tracking expenses and income by job or client; monitoring and paying sales tax; receiving and depositing payments and reconciling bank statements; and printing invoices, statements, payroll checks, and reports. Reports include profit and loss, balance sheets, trial balances, journals, and cash flow. Prerequisites: Knowledge of accounting and working knowledge of Windows. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Build on skills learned in QuickBooks one by taking a deeper dive into Customizing your business setup, including forms and Chart of Accounts. Manage inventory and perform financial report analysis. In depth examination of the payroll module. Going beyond basics, students will learn how to utilize more advanced features of the software and accounting practices and methods. This course is intended for those who have basic knowledge of QuickBooks or who have taken QuickBooks 1 and are looking to advance their skills.

Expand your intermediate Microsoft Word knowledge with the advanced features of the software. Topics include integrating Word with other Microsoft programs; creating and modifying forms; creating and modifying screenshots; adding comments; tracking changes; and customizing Word. Prerequisite: Word Intermediate Features. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.

Earn your nationally recognized certification as a Microsoft Office Specialist (MOS), or singular MO certifications in specific applications, and improved your earning potential and employability.This Word, MO-100, preparatory class is a comprehensive class that covers the following Word skills: management of documents, inserting and formatting text, paragraphs, and sections; creating and managing tables and lists; creating and managing references; inserting and formatting graphic elements; and collaborative editing. This curriculum is ideal for improving your report writing and formatting skills.

Improve your Microsoft Word skills by learning to create more complex documents. Topics include working with graphics, creating a mail merge, creating labels, creating styles and templates, generating an index, and inserting headers and footers in multiple sections. Prerequisite: Learn Word in a Day. Purchase of textbook and USB flash drive required. Senior adult and disabled retiree course fee waivers apply. Transcript available.