Applied Office

Microsoft Access 2003 - Beginning : About the Class This full-day class provides participants with an introduction to Microsoft Access databases, covering tables, queries, forms, and reports. Participants will create their own database to track customer data and run reports for basic analysis. The class will cover best-practices for creating tables and table relationships (including lookup menus), query features such as criteria and sorting, and a primer on building forms and reports using wizards (including the label wizard) and customizing them. This class assumes no prior knowledge of more...

Microsoft Access 2003 - Intermediate : About the Class This full-day class builds on your understanding of Microsoft access by covering intermediate and some advanced topics. Learn more about table relationships and integrity. Learn how to write complex queries including Update, Delete, and Append queries. Learn how to enhance forms and reports with subforms, tabs, and subreports. And, learn how to use Visual Basic for Applications (more...

Microsoft Access 2007 - Starting a Database : This hands-on class provides participants with a basic introduction to Microsoft Access databases, covering simple tables, queries, forms, and reports. Participants will create their own database for a fictitious customer listing and run reports for basic analysis and mailing address labels. The differences between Access and Excel will also be discussed. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the more...

Microsoft Excel - Functions and Formulas : Beginning with a quick review on basic Excel arithmetic, participants will learn all about Formulas and Functions in Microsoft Excel 2007. After covering SUM, AVERAGE, and a handful of other basic functions, you'll learn how to: a manage and link multiple worksheets a use absolute cell references and named ranges a write expressions that span and summarize multiple worksheets a create conditional formulas using IF a work more...

Microsoft Excel 2003 - Creating Charts : About the Class This quick, fun class will teach you how to create charts in Excel in a variety of ways and customize them with color, logos, annotations, and icons. Learn how to embed them alongside your data or go full-page for maximum impact. Whether you want pies, columns, lines, or bars, you'll feel confident the next time you want to create a chart. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the Pacific campus in a more...

Microsoft Excel 2003 - Formulas and Functions 1 : About the Class Beginning with a quick review on basic Excel arithmetic, participants will learn all about Formulas and Functions in Microsoft Excel. After covering SUM, AVERAGE, and a handful of other basic functions, you'll learn how to manage and link multiple worksheets, absolute cell references, named ranges, and expressions that span and summarize multiple worksheets. Knowledge of Excel more...

Microsoft Excel 2003 - Formulas and Functions 2 : About the Class Build on your knowledge of Formulas and Functions with this intermediate class that introduces functions such as VLOOKUP, IF, SUMIF, and more. Learn how to work with dates and times. Build more complex worksheets that automate your work and save you and your employees considerable time. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University more...

Microsoft Excel 2003 - Locking a Workbook : About the Class Participants will learn how to create spreadsheets to be used by other employees and reduce error through data validation, cell locking, and automated assistance. They will learn how to password-protect parts of the spreadsheet, or the entire workbook, to create a solution or template that can be used throughout the organization. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the Pacific campus in a state-of-the-art hands-on computer lab and include:  more...

Microsoft Excel 2003 - Pivot Tables : About the Class Participants will use Excel's pivot tables to quickly summarize thousands of records in just a few clicks. The Pivot Table feature sorts, counts, and totals data and lets users quickly review that data in a variety of ways. Participants will be able to turn a long list of payroll transactions or scientific data into something useful. Basic experience with Excel is expected. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University more...

Microsoft Excel 2003 - Tips and Tricks : About the Class This fast-paced class is intended for users who are looking to get more out of Excel. A wide variety of shortcuts and features will be demonstrated to the class, including keyboard time-savers, series fills, format styles, function tricks, and more. This class assumes prior knowledge of basic Excel skills. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the Pacific campus in a state-of-the-art hands-on computer lab more...

Microsoft Excel 2003 for Beginners : About the Class This class will provide a foundation for anyone new to Microsoft Excel. Basic operations will be covered including entering and changing data, simple formatting, the SUM function, and printing. Participants will create their own annual budget report, with AutoSum and proper formatting, and then create a basic chart. Then learn precisely how formulas work starting from the basics. Learn simple arithmetic, SUM, AVERAGE, COUNT, and a more...

Microsoft Excel 2007 - Beginners : This class will provide a foundation for anyone new to Microsoft Excel. Basic operations will be covered including: a entering and changing data a simple formatting (font, colors, borders, column sizes) a Auto Sum a printing and page settings a creating a simple chart Participants will create their own annual budget report, with AutoSum and proper formatting, and then create a basic chart. The follow-up to this class is on Thursday: Excel - Formulas and more...

Microsoft Excel 2007 - Tips Tricks and Formatting : This fast-paced, hands-on class is intended for users who are looking to get more out of Excel. A wide variety of shortcuts and features will be demonstrated to the class, including keyboard time-savers, series fills, format styles, function tricks, and more. This class assumes prior knowledge of basic Excel skills. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the Pacific's satellite campus in a state-of-the-art hands-on computer lab and include: * class notes * a more...

Microsoft Excel 2007 for Beginners : This hands-on class will provide a foundation for participants new to Microsoft Excel. Basic operations will be covered including entering and changing data, simple formatting, the SUM function, and printing. Participants will create their own annual budget report, with proper formulas and formatting, and then create a simple chart. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the Pacific's satellite campus in a state-of-the-art hands-on computer more...

Microsoft Excel 2007 Formulas Level 1 : This hands-on class helps participants learn precisely how mathematical expressions and functions work, starting from the basics (simple arithmetic, SUM, and AVERAGE) to the more complex (IF, financial formulas, etc). Absolute references are also discussed. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the Pacific's satellite campus in a state-of-the-art hands-on computer lab and include: * class notes * a more...

Microsoft Excel 2007 Formulas Level 2 : This hands-on class builds on the prior a Level Ia class with more practice using absolute references, named ranges, and a variety of functions. Experience writing basic formulas is required. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the Pacific's satellite campus in a state-of-the-art hands-on computer lab and include: * class notes * a Quick Reference Card * a Certificate of more...

Microsoft Office 2007 - Overview : About the Class Whether you're a user of Microsoft Word, Excel, or PowerPoint, if you've upgraded to Office 2007 you know there are new features just waiting to be used, and there's new shortcuts that you're dying to learn. This class, intended for users at all levels, will introduce you to Office 2007 with a whirlwind of tips, tricks, new features, and more. Ask your questions about compatibility issues, too! This class is not hands-on. ~~~~~~~~~~~~~~~~~~ About the more...

Microsoft Office 2007 - Overview : Whether you're a user of Microsoft Outlook, Word, Excel, or PowerPoint, if you've upgraded to Office 2007 you know there are new features just waiting to be used, and there's new shortcuts that you're dying to learn. This class, intended for users at all levels, will introduce you to Office 2007 with a whirlwind of tips, tricks, and new features, such as: a customizing the Ribbon to suit your needs a giving photos a little flare in more...

Microsoft Office 2007 for Beginners : Intended for beginner users transitioning from Office 2003 to Office 2007, participants will learn about the new interface, features and more in this hands-on class. Time will be spent explaining the Office Ribbon, Office menu, short cut keys, and document compatibility issues. Then, features new to Microsoft Office 2007 will be used throughout Word, Excel, and more...

Microsoft Office 2007 for Intermediate Users : Intended for intermediate and advanced users transitioning from Office 2003 to Office 2007, participants will quickly review the new interface, and then focus on features new to Microsoft Office 2007 in this hands-on class. In Word, walk through the improved mail merge feature and learn about styles and themes. In Excel, discover the powerful tables feature and revised pivot table and charting tools. And in PowerPoint, more...

Microsoft Office 2010 - New Features : In this demonstration-only session, you will discover new features unique to Office 2010 including ribbon customization, the new Backstage view, photo editing and improvement options, and more. Applications covered include Outlook, Word, Excel, and PowerPoint. This class is perfect for those who have recently upgraded, or plan to. It is not hands-on. ~~~~~~~~~~~~~~~~~~ About the Location Classes are more...

Microsoft Outlook 2003 : About the Class Are you using Outlook to its full potential? You'll start learning the basics about email then move quickly into intermediate topics like inbox management, sending appointments, sharing calendars, keeping track of your tasks, and setting reminders. Learn how to manage appointments faster, find your emails faster, take advantage of keyboard shortcuts, and more. Experience with Outlook is required. Bring your questions! ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the more...

Microsoft PowerPoint - All You Need : Learn how to create a simple, effective slide show from scratch using Microsoft PowerPoint 2007. This beginning class will cover all of the basics including: a inserting, rearranging, and deleting slides a adding clip art, photos, and shapes to your slides a changing the layout of a slide with two clicks a brainstorming using the efficient outline mode a using professionally-created templates to add the final touch a pasting data and charts from Microsoft Excel 2007 a save slides to a PDF, CD, or more...

Microsoft PowerPoint 2003 for Beginners : About the Class Learn how to create a simple, effective slide show presentation using Microsoft PowerPoint. This beginning class will cover all of the basics including adding clip art and shapes to your slides, editing text, using the efficient outline mode to brainstorm your ideas, and using a professionally-created template to add the final touch. Participants will also learn how to easily save their slides to a CD for distribution. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful more...

Microsoft Powerpoint 2007 for Beginners : Learn how to create a simple, effective slide show presentation using Microsoft PowerPoint. This beginning-level, hands-on class will cover all of the basics including adding clip art and shapes to your slides, editing text, using the efficient outline mode to brainstorm your ideas, and using a professionally-created theme to add the final touch. Presentation and organization concepts are also reviewed. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the Pacific's satellite more...

Microsoft Powerpoint 2007 for Intermediate Users : Go beyond the basics to wow your audience while delivering a powerful message in this hands-on class on Microsoft PowerPoint 2007. Topics covered include photo editing, inserting charts and tables, animation, creating looping presentations, editing the master slide, and more. The class rounds out with a discussion on what makes slides powerful to an audience, including a before-and-after comparison of what not to do. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the more...

Microsoft Publisher 2003 : About the Class In this fun, creative class, you will learn how to create flyers, brochures, newsletters, calendars, and other eye-catching pieces using Microsoft Publisher. Whether you're starting with hundreds of free templates or from scratch, you'll be on your way to professional desktop publishing. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the Pacific campus in a state-of-the-art hands-on computer lab and include: * more...

Microsoft Word 2003 - Forms and Tables : About the Class Learn how to create professional-looking forms (handwritten and electronic) using Microsoft Word, in this class focusing on tables. Discover how to "lock down" a form for on-screen data entry, automatically adjust height based on user-input, and calculate totals based on entered amounts. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the Pacific campus in a state-of-the-art hands-on computer lab and include:  more...

Microsoft Word 2003 - Intermediate Formatting : About the Class Take your understanding of Word to another level and create better-looking documents with intermediate and advanced layout. Learn how to properly use and configure tabs (including decimal tabs), columns, and text boxes to give you absolute control over your text. Improve your documents' appearance with Page Borders, Paragraph Borders and Shading. Finally, learn how to work with photos and watermarks. ~~~~~~~~~~~~~~~~~~ About the more...

Microsoft Word 2003 - Mail Merge : About the Class Find out how easy it is to create mailing labels, form letters, personalized envelopes, or a customized email. This class explores the ways that Word can be used to create merged documents with data pulled from a variety of sources such as Excel, Access, and Outlook. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the more...

Microsoft Word 2003 - Styles : About the Class This intermediate class on Microsoft Word introduces participants to creating styles. Styles are used to give a consistent appearance within and between documents. Anyone who has difficulty managing large documents or maintaining consistency should take this class. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University of the Pacific campus in a state-of-the-art hands-on computer lab and include: * class notes * a more...

Microsoft Word 2003 for Beginners : About the Class This class is for those who have little or no experience using Microsoft Word. Learn simple word-processing concepts to be more efficient and create professional-looking documents. Topics include font and paragraph formatting, bullets and numbered lists, page headers and footers, copy-and-paste, spell check and thesaurus, printing options, and more. Also offered July 20. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at the beautiful University more...

Microsoft Word 2007 - Intermediate : A full-day class to take you to the next level of creating compelling documents with ease! This hands-on class will help you understand how to: a control paragraph formatting like a pro a use tabs to their full advantage a take advantage of the Styles feature -- a MUST for large documents a mail merge (form letters, labels, and certificates) a add headers, footers, and cover pages to your document a create an automatic Table of Contents Bring your questions and get them answered in the Q&A portion of the class! Prior experience with Word (any version) is required.

Microsoft Word 2007 for Beginners : Learn word processing from the ground up in a class that focuses on results and not just typing. Using Microsoft Word 2007 in this hands-on class, participants will learn how to control text and paragraph formatting, set page margins and columns, insert clip art and images, and other necessary features. Youa ™ll download and customize templates such as a resume, use spell check and other research tools, and review copy-and-pasting. Attendees must be familiar with the keyboard and mouse. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at more...

Microsoft Word 2007 Intermediate Document Formatting : This intermediate, hands-on class on Microsoft Word introduces participants to creating styles and using them for better, cleaner document control. Additional concepts will be reviewed including page headers and footers, page formatting, and more. Anyone who has difficulty managing large documents or maintaining consistency should take this class. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the Pacific's satellite campus in a state-of-the-art hands-on computer lab more...

Workshop Facebook and Twitter for Business : Help bring your business or organization into social media with this hands-on workshop. Build and promote a Facebook page with a photo album, events, fans, and more, then learn how to promote it. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at University of the Pacific's satellite campus in a state-of-the-art hands-on computer lab and include: * class notes * a Quick Reference Card * a more...