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 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.

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.

Class 1: This class includes an overview of the Excel tool bar, how to create a spreadsheet and how to use AutoFill and AutoSum. Additionally, this introduction to Excel will teach you how to create a simple formula, how to format Text and Numbers and how to preview and print your work. Class 2: Learn how to customize your toolbar, basic functions, how to use AutoCalculate, working with Rows and Columns, using multiple sheets, and arranging multiple files in class two. Class 3: This course includes topics that are incredibly helpful when working with Excel. Some of the most popular tools are arranging multiple files and freeze panes. In addition, you will learn more features about printing, formulas and comments. Class 4: This class will take you into more intermediate and advanced topics. Linking is a feature that is used throughout Excel. Additional topics include using a named range, conditional formatting, quick analysis and protecting cells.

Class1: There are so many tips and tricks in Excel that we need 2 classes to cover them. Learn how to best utilize highlighting and navigating shortcuts, working with sheets and FlashFill to increase proficiency. Class 2: Learn how to use Sorting, Filtering, Tables and Subtotals. Even if you have used Sorting and Filtering before, you will learn tips and tricks on how to work with them proficiently. Class 3: Learn to create a graph and how to customize it. You will also learn how to import/export your graph into other applications such as Word or PowerPoint. Class 4: Have you ever heard the term Pivot Table and wondered what it was? In this class you will explore features a Pivot Table has to offer. When you use a Pivot Table you combine so many features into one e.g. Sorting, Filtering, Subtotals, consolidation and more. This is the Mack Daddy of summarizing large amounts of data into a clear and concise table of information.

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: Learn how to use Word. This class will include an overview of the screen, how to create & save a document. Additionally, this introduction to Word will teach you how to format text, paragraphs, and lists, use tools for spellcheck and printing options. Class 2: Improve your Word proficiency. In this class you will learn how to add page number and headers & footers, insert tables, and add interest with adding pictures, screenshots and SmartArt. Class 3: 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 4: 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.

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.

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.

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.

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.