Alameda County Training & Education Center Microsoft Courses

Promotional Offering for Oakland Chamber of Commerce
Computer Software Classes
July – September 2011

Microsoft Application Suite 2007

Access 2007
Fundamentals – September 8, 9:00 am – 4:30 pm $175
Learn how to maintain and manage large amounts of information, using a very efficient and powerful information management computer application, the Access 2007 relational database. Explore the functions of tables and queries. Create and modify simple forms and reports.

Excel 2007
Fundamentals – August 25, 9:00 am – 4:30 pm $175
Participants will learn basic spreadsheet skills and how to perform calculations, manipulate data, format a worksheet, print and manage worksheets.

Excel 2007
Formulas, Functions, & More – July 7, 9:00 am – 4:30 pm $175
The primary focus of this class is to use formulas, functions with large worksheets. We will cover how to create a formula using "if" statements, "ISError", "Or", "And" and many more formula creation techniques. We will cover functions such as "Vlookup", "Hlookup", "Round", "FV", "PMT" and many more. You will expand your knowledge of the management of larger spreadsheets, working with range names, and techniques to manipulate large worksheets. The end result will be the ability to create large budgets, lists, and information you need to manipulate Excel.

Excel 2007
Databases, Pivot & Data Tables –September 14, 9:00 am – 4:30 pm $175
Students will learn how to sort and manage data in lists; filter and query data, use database functions and import and export information and documents. Participants also will learn the basics about Pivot Tables, creating and formatting them. Discover the use of data series and data tables in this class.

Outlook 2007
Fundamentals – J