« Back

Technology Enrichment

Filter by Campus: North County Center

Database

Word Processing

Create Custom Mailings with Microsoft Mail Merge

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.

Managing Complex Documents with Microsoft Word

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.

Spreadsheets

Microsoft Excel -Part 1

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.

Constructing Microsoft Excel Formulas

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.

Using Microsoft Excel Charts

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.

Cloud Technology

Accounting

QuickBooks I

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.

QuickBooks II

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.

Quickbooks - Online Version
Learn how the online version of QuickBooks can help you manage your business finances from almost anywhere using cloud technology. Throughout the course we will discuss the advantages and disadvantages of using QuickBooks online to manage your business. This hands-on course will cover topics like: income statements, balance sheets, tracking sales, expenses, accounts payable, accounts receivable, and more.