Applied Office
Applied Office is a California business (based in Lodi, California) with over 15 years of experience providing training on Microsoft software.
Applied Office is owned by David Diskin, a certified Microsoft Office "Master", and can help your business or government agency by providing instructor-led, on-site training on the applications that you use every day:
* Microsoft Word
* Microsoft Excel
* Microsoft Access
* Microsoft Outlook
* Microsoft Project
* and more...
Clients of Applied Office include Lodi Memorial Hospital, Teichert Construction, University of the Pacific, various departments within the State of California, and the County of San Joaquin.
Applied Office is based in Lodi, CA, USA
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
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...
: 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 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...
: 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 (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...
: 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...
: 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...
: 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...
: 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...
: 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...
: 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...
: 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 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...
: 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 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...
: 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 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...
: 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 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...
: 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...
: 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...
: 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 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...
: 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...| Head Office | Training and Seminar Locations |
