A database is a collection of information that is related, and can be a fantastic tool when built correctly and understood by the user. The course will explain correct database design, structure and creation. Table structure is discussed along with working with data such as retrieving, formatting and printing, database vocabulary, common mistakes, database “what ifs,” and more. This course is most successful if you can bring with you to class a project that needs better organization.
Improve your word processing skills and take advantage of all the great features the newest version of Microsoft Word has to offer. You will create, revise, and save documents for future use and also learn the interface, creating and using autocorrect entries, spell and grammar check, thesaurus, and find and replace features. In addition, you will insert and remove page breaks, adjust margins, change line spacing, set, modify and remove tabs, cut, copy, & paste text, and create a mail merge for letters, labels or envelopes. Price includes textbook.
Learn advanced word processing skills. You will work with tables creating, sorting, performing calculations, and adjusting properties, and also to create and edit documents which include Word Art, clip art, drop caps, auto shapes, text boxes and other objects. Use your creative side as you format a newsletter quickly trying out format changes using built-in and custom styles. Create and edit templates to give your work a consistently professional look. Prerequisite: MS Word Part I. Price includes textbook.
Creating Custom Mailings with MS Word Mail Merge Learn how to design form letters with merge fields; create data lists in Word or use data from Excel or Access; sort and select data records; create mailing labels. Prerequisite: Word experience.
Come down and learn how to conquer page numbers, headers and footers, tables of contents, foot/endnotes, styles and more to make working with large documents easier. Prerequisite: Word experience.
Explore the use of columns, tabs, picture position, grouping, backgrounds, borders and more in Word to create business cards, labels, flyers, brochures, invitations, and tri-fold marketing materials. Prerequisite: Word experience.
Use Microsoft Excel to manage, display, and save numerical data. You will receive instruction on the newest Microsoft Excel interface, entering data into cells, viewing data, and printing out worksheets. We also will be covering formatting numbers and text; using the format painter; inserting, deleting, and modifying rows and columns; creating and using formulas with fixed and relative referencing; creating and modifying charts. Price includes textbook.
Advance your skills even more! You will learn how to manage multipage worksheets; freezing headings and splitting worksheet windows; adding graphics to worksheets; creating, saving and using templates; locking and unlocking cells; applying worksheet protection by setting a password; attaching a digital signature; creating and managing multiple-sheet workbooks; copying formatting between worksheets; using linked formulas; creating hyperlinks to areas within the workbook and to other documents and so much more! Prerequisite: Working knowledge of Windows & MS Excel Part I. Price includes textbook.
This class provides more complex skills than those presented in our Level 1 and Level 2. Topics covered include PivotTables and macros, financial functions, data analysis, auditing and additional functions, advanced formatting and analysis tools, collaboration, and more. Prerequisite: Working knowledge of Windows and MS Excel I & II. Price includes textbook.
Do you want to learn how to build more complicated formulas, use functions and combine them in powerful ways? Learn to troubleshoot formulas using the auditing tools, document the formulas that you create, and use named ranges and cells in your formulas to better understand the purpose of the formula. Prerequisite: Excel experience.
Do you know Excel supports a wide variety of standard types of charts and graphs? What are you waiting for! Create effective charts today that clearly and accurately convey the meaning of your data. Prerequisite: Excel experience.
Quickbooks I—Desktop Version Our CPA instructors have been in the business of accounting for several years and will demonstrate the many different ways it can help your small business. This hands-on course will offer you background on accounting principles and financial statements so that you can make sure you are capturing the right data. Some of the topics to be covered include: income statements, balance sheets, tracking sales, expenses, preparing bank reconciliations, and much more. Price includes textbook. Please register 1 week prior to class start date to ensure book arrival.
This course will expand on the basic topics covered in QuickBooks I. You will receive more in depth instruction on the following topics: invoices, sales receipts, voiding/deleting checks, credit memos, paying bills, receiving and adjusting inventory, setting up payroll, managing payroll, reporting and paying sales tax, petty cash, finding transactions FAST, creating custom invoices, online banking and much more. Prerequisite: Quickbooks I. Price includes textbook. Please register 1 week prior to class start date.