Excel Quickstart $65 plus $10 Lab Fee OCCP243-02
During this fast paced seminar, participants are introduced to introductory level Excel skills including navigation, spreadsheet design, editing techniques, basic formulas and functions, creating effective lists, basic charting, and more. 3 Hours, Fri., 6/19/15, 9:00 a.m. – 12:00 p.m.
Excel: Formulas & Functions $65 plus $10 Lab Fee OCCP 246 02
If you are an Excel user but intimidated by the concept of formulas and functions, then this seminar is for you! Participants will learn about the mathematical aspects of Excel including how to create effective, error-free equations and use existing functions in order to simplify and automate calculations in spreadsheets. 3 Hours, Fri., 7/17/17, 9:00 a.m. – 12:00 p.m.
Linking Excel and Word $65 plus $10 Lab Fee OCCP 342 01
Oftentimes, it's helpful to use Excel and Word simultaneously to accomplish a task. For example, Excel data can be linked into a Word document (account balances into a financial report). You could type the data into your Word document, but this method requires manual updating every time the data changes in Excel. This seminar will show you how to use the many linkages that exist between the programs in order to save you time and help make your documents error-free. 3 Hours, Fri., 7/24/15, 9:00 a.m. – 12:00 p.m.
QuickBooks Basics $65 plus $10 Lab Fee OCCP 078 01
If you have ever felt overwhelmed and intimidated by accounting software, then this seminar is for you. QuickBooks Basics is perfect for new users who want to get started right, or experienced users who want to strengthen their foundation and get even more from the software. Taught by an experienced CPA. Topics include setting up the company file; defining and modifying the chart of accounts; processing accounts payable; adding new customers; processing invoices; making deposits; preparing a bank reconciliation; creating financial reports; and much more! 3 Hours, Thur., 9:00 a.m. – 12:00 p.m.
Excel: Pivot Tables & Charts $65 plus $10 Lab Fee OCCP 386 01
During this seminar, participants are introduced to macros plus other Excel tools that assist in manipulating data such as sorts, filters, subtotals, pivot tables, and pivot charts. 3 Hours, Fri., 8/7/15, 9:00 a.m. – 12:00 p.m.