|
|
Windows Vista Classes
Key Features Windows Vista
Learn how to do the most common Windows tasks using the revised interface in Windows Vista. Particular attention will be given to time saving new features such as the expanded file organizing and searching capabilities.
Office 2007 Classes
Getting Productive with Access 2007
Learn the key changes specific to Access 2007, such as multi-value fields, and using Rich text format in Memo fields.
"Getting Productive with Office 2007" should be taken prior to this course to gain familiarity with the changes common to all Office 2007 programs.
Getting Productive with Excel 2007
Learn the key changes specific to Excel 2007, such as increased capacities, additional formatting options and improved printing capabilities.
"Getting Productive with Office 2007" should be taken prior to this course to gain familiarity with the changes common to all Office 2007 programs.
Getting Productive with Internet Explorer 7
Learn how to do the make use of the most common features of Internet Explorer 7 using the revised interface in Windows Vista. Particular attention will be given to time saving new features such as tabbed browsing and searching capabilities.
Getting Productive with Outlook 2007
Learn the key changes specific to Outlook 2007, such as the "To-Do Bar", Instant Search and extended color coding options.
"Getting Productive with Office 2007" should be taken prior to this course to gain familiarity with the changes common to all Office 2007 programs.
Getting Productive with PowerPoint 2007
Learn the key changes specific to PowerPoint 2007, such as more extensive animation and multi-media capabilities, the change from Masters to Layouts and tools for creating photo albums.
"Getting Productive with Office 2007" should be taken prior to this course to gain familiarity with the changes common to all Office 2007 programs.
Getting Productive with Word 2007
Learn the key changes specific to Word 2007, such as enhanced spelling and grammar checking, new formatting tools and improved graphics capabilities.
"Getting Productive with Office 2007" should be taken prior to this course to gain familiarity with the changes common to all Office 2007 programs.
Getting Productive with Office 2007
Master the new Office 2007 interface and learn how to unlock its productivity enhancement features. Also learn how to create files that can be used by people that don't have Office 2007.
Excel Classes
Preparing Annual Summaries with Excel
Annual summaries require using techniques you may not need at any other time. This class will cover key techniques such as summing across multiple sheets, calculating percent increase/decrease and creating lists of unique items.
Formatting Basics for Excel
Learn essential formatting skills for working with data in Excel, including how to deal with leading zeros, long text, and numeric data. The course also includes tips that can prevent confusion and help you avoid some frustrating problems.
Formula Basics and Frequently Used Functions
Learn the basics of how to create formulas in Excel, including the most frequently used functions. You will also learn how to have Excel help you find functions that will perform calculations you need.
Excel Basics
Learn essential Excel skills including key terminology, navigating within Excel and how to format data. The course also includes tips that can prevent confusion and help you avoid some frustrating problems.
Working with Dates and Times in Excel
Need to know how many work days remain between today and an upcoming deadline? How many hours until that deadline? Having trouble adding time to dates? Need to change the display of dates? Need to know what week of the fiscal year this is? This class will help you use dates more effectively in your spreadsheets. You’ll learn how formatting can save your day. You’ll be introduced to the functions DATEDIF, NETWORKDAYS, EOMONTH, EDATE and many others.
Top Ten Tips for Excel Formulas
Ten simple yet powerful techniques that will help you create formulas more quickly and effectively with less frustration.
Creating Charts
Learn how to create and format the most common types of charts in Excel.
Advanced Charts
This session covers advanced chart techniques that allow you to create charts such as a "floating bar" chart.
Summarizing Data
You will learn how to use three Excel tools that can help you develop meaningful summaries of large quantities of data.
Introduction to Conditional Calculations
Learn to create formulas that perform tests and provide different results depending on the outcome of the tests. Functions such as IF, AND, OR and NOT will be covered.
Performing Conditional Counts and Sums
The COUNTIF and SUMIF functions provide a simple yet powerful way to selectively summarize data.
Common Statistical Calculations
Learn how to calculate Average (mean), Median, Standard Deviation and other common statistical measures in Excel.
Common Financial Calculations
Learn how to calculate Present Value, Future Value, Internal Rate of Return and other common financial measures in Excel.
Working with Large Amounts of Data
Excel provides several tools to allow you to quickly find or view the data you need within a large amount of data. You will learn to use the Find and Filter features, plus how to copy only the information you need.
Dealing with Error Returns in Calculations
Learn how to prevent, intercept or make use of error messages in Excel calculations.
Working with Imported Data
Learn to use Excel's tools for working with data from other programs. This includes the Text Import Wizard, Text-to-columns and dealing with problems commonly encountered with imported data.
Excel: Printing Basics
There are many print options in Excel that allow great flexibility. This session will cover page set-up, print areas, scaling, repeated information and other printing issues.
Simplifying Calculations with Named Ranges
Learn how to use convenient names like "MonthlyTotal" in the place of cell references in calculations.
Using the Advanced Features of Named Ranges
Named ranges can do more than simply represent a range or static data. Learn how to use advanced features such as performing calculations within named ranges.
Word Classes
Top Ten Tips for Word
Ten simple yet powerful techniques that will help you produce better documents more efficiently.
Getting the Headers, Footers and Page Numbers You Want.
Headers, footers and page numbers have caused a lot of frustration for many people. A little coaching on header and footer basics can help you get the document you want without the frustration.
Mail Merges Made Easy
Mail merging is a powerful tool, but creating customized letters and labels doesn't have to be difficult. This session will cover the how-to and what-not-to of mail merging with Word.
Formatting documents effectively
This session will cover how to use formatting options for text and paragraphs to achieve the look you want. You will also learn how to combine formatting options into styles so they can be easily repeated within and between documents.
Using Tables Effectively
Tables can often help you arrange information in a way that communicates more clearly. Just a few tips can clarify how to get tables to do what you want.
Automating document creation.
Word includes powerful features to help you create documents with less typing. This session will cover how to use AutoText, AutoCorrect, AutoFormat and AutoSummarize to create document more quickly and easily.
Document automation with fields
Many of Word's automation features work by creating fields for you. Learning how to work with fields directly will give you greater control over these features and allow you to access additional automations available only by working directly with fields.
Creating On-screen Forms
Learn to create reusable and distributable forms that can be filled out on-screen, saved or e-mailed.
Using Word's Proofing Tools to catch mistakes
Learn to use Word's proofing tools (spelling and grammar) more effectively to catch mistakes in your documents. We will also cover common problems that prevent the tools from working, what kinds of mistakes the tools can't catch and how to turn the tools
Working with large documents
Learn how to use Word's tools for dealing with the challenges of large documents. This will include creating a table of contents, footnotes and cross references. You will also learn some ways to avoid having large documents slow your computer to a crawl.
Working with frequently changed or multi-editor documents
Keeping track of the changes made to a document over time and by various editors can be readily accomplished with tools such as Track Changes and Versions.
PowerPoint Classes
PowerPoint Basics
Learn essential skills to create the slides you want, including slide layouts, adding objects, and trimming pictures. Also adding a covered summary slide.
Top Ten Tips for Working with PowerPoint
Ten tips that can help you avoid frustration and get the presentation you want.
Creating a Custom Template for Your Presentations
How to use the Title Master, Slide Master, backgrounds and other elements to create a standard presentation. Understanding these is also helpful when working on presentations created by others.
Making Clear Presentations that Command Attention
Knowing what to do is as important as knowing how to do it. Learn how to determine what to do in PowerPoint to effectively hold and direct the audience's attention.
Using Animation in PowerPoint
Learn how to use builds, actions and animations to add more interest and variety to your PowerPoint presentations.
Printing from PowerPoint
PowerPoint offers several unique printing options. Problems frequently encountered when printing from PowerPoint will also be covered.
New Features in PowerPoint 2002/2003
PowerPoint had the most significant changes of any of the Office XP (2002) applications. The changes carried over into PowerPoint 2003. Learn about those that will affect you most if you have used earlier versions.
Access Classes
Planning Your Database
Tables laid out in a way that makes sense to people may not make sense to Access. This course will help you make tables that Access can work with.
Retrieving Data - Introduction
Learn to create queries using one or more tables, basic criteria and calculations. The emphasis will be on retrieving data, but other query types will be introduced.
Retrieving Data - Intermediate
Learn more about joining tables, advanced criteria, creating calculated expressions and using parameters.
Retrieving Data - Advanced
This session will introduce advanced query types such as Find Unmatched, Union and self-joining. More advanced calculations will also be covered.
Form Basics
Learn the essentials for creating forms that work. Controls, Subforms, form properties and other topics critical to designing a working form will be covered.
Using Forms to Select Data
You can use selections made on a form to determine what data is selected. This course will cover the techniques needed to build such forms and their related queries.
Report Basics
Learn the essentials for creating reports that work. Controls, Subreports, report properties, printing issues and other topics critical to designing a working report will be covered.
Outlook Classes
Getting Started with Microsoft Outlook
How to do the most common tasks and set the most commonly requested options in Outlook. This includes creating messages, calendar items, contacts, distribution lists and tasks. Options covered include message format, delayed sending and setting defaults.
Top Ten Tips for Microsoft Outlook
Ten “I wish I’d known!” tips for using Outlook. When will message recall not work? How can I use Outlook to improve my follow-up? Why is my mailbox so huge when there is nothing in it? … and seven more.
Dealing with Large Volumes of e-Mail in Outlook
How to automatically organize your e-mails and easily find the e-mail you want. Also how to keep everything you want to and still avoid "your mailbox is full" errors.
Getting the most out of Outlook Contacts
Learn to use Outlook tools such as Categories, Filters and Views to make working with your Contacts list easier.
Getting the Most Out of Your Outlook Calendar
Learn multiple ways to create appointments, coordinate schedules with other Outlook users, move around quickly and other topics to help you get your calendar to work for you.
Sending Personalized Holiday Greetings with Word and Outlook
Are you making a list and checking it twice, wanting to send a greeting that's nice? Word can work with Outlook Contacts or several other types of lists to prepare individualized greetings for print or e-mail. In this class you will learn how to utilize this feature and how to avoid common pitfalls.
Moving Around Efficiently in Outlook
How to customize the Outlook bar and make use of features that allow you to move around conveniently in Outlook.
Project Classes
How MS Project Uses Time
How MS Project defines and uses time affects almost every aspect of the program. Sometimes “a day is not a day.” This confuses both novice and advanced users. In this class, we will describe how MS Project defines “a day,” how to configure Calendar and Schedule options, how MS Project schedules tasks and calculates related costs, and much more.
Project Basics
Learn essential tools to get you started with Project. Key terms and ways to avoid frustrating problems are also covered.
MS Project, Gantt Views, and Printing
The Gantt View is MS Project’s most popular feature. In this class, we will discuss how to print a Gantt View, including how to work with legends, footers, headers, timelines, navigate the Page Setup features, change paper size and settings, and much more.
Top Ten Tips for MS Project
Ten easy to use techniques to help unleash the power of MS Project. Topics such as resources, costing and views are covered.
Visio Classes
Visio Basics
Learn essential tools to allow you to get started with Visio. Key terminology and ways to avoid frustrating problems are also covered.
Visio Organization Charts Made Easy
Learn essential skills to build an Organization Chart. Gain an understanding of the Shapes, terminology and formatting options provided by Visio.
Top Ten Tips for Visio
Learn ten time savers in Visio that are easy for someone who is new to Visio, but hard enough to find that even experienced Visio users don't know them all.
Creating flowcharts in Visio
With a proper understanding, you can create impressive flowcharts in Microsoft Visio. In this class we teach you the basic flowchart symbols and how to use them appropriately, how to create on-page references and off-page references with hyperlinks, how to print and save flowcharts.
Notes Classes
Getting the Most Out of Notes Mail
This class covers setting preferences and options, working with the Address Book, delegation, using rules, archiving and the Out of Office Agent.
Getting Organized with Notes
Learn to use the features of Notes Calendar and To Do list to help you get and stay organized. This includes setting preferences and options, scheduling resources, archiving and delegation.
Making Lotus Notes Documents and E-Mails that Communicate More Clearly
Learn to use Lotus Notes formatting options to improve the appearance and communication power of e-mails and other documents created in Notes, as well as some DOs and DON'Ts for communicating through electronic documents.
Using Notes When You Aren't in the Office
Demystify using locations and replicas to stay connected and productive while you are out of the office.
Customizing the Notes Interface
Notes offers great flexibility in putting the information you need most within easy reach. Learn to customize the home page and use bookmarks.
Finding the Information You Need in Notes
Many Notes databases offer views and search features that allow you to quickly find the information you need. Learn how to find which features are available and how to use them.
Importing and Exporting Data with Notes
Learn to bring elements from other applicatons into Notes documents, import entire documents from other applications and export data from Notes for use in other applications. Importing information into your Address Book is included.
Organizing Information in Notes with Folders and Views
Notes offers some powerful, yet easy to use, tools for organizing your mail or other Notes data.
|
|
