This workshop provides Excel 2007 novices with a working understanding of the Excel environment. Each area of the Excel window will be covered. In addition, you will learn to edit and save an Excel 2007 workbook at the end of this workshop.

• Excel 2007 Environment
• Navigate within an existing spreadsheet
• Understand the cursor shapes
• Create and save a workbook
• Create formulas

Don't spend another day manually filtering information from your spreadsheets in order to find the answers to your most pertinent business questions. Utilize the built-in formulas that Excel has to offer and get accurate results in a snap! This Webinar focuses on how to work with formulas and functions in Excel worksheets. Formulas are equations that perform calculations on values in your Excel worksheet. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

Learn formulas that will help you with specific business tasks, such as:

• Calculating loan repayment
• Creating amortization tables
• Identifying the potential future value of investments
• Using Excel’s discounting functions to analyze cash flow values and rates of return

When working with spreadsheets, you may want to use the same layout or design multiple times. Templates are a way to take a spreadsheet and reuse it over and over again without going through the time-consuming steps to make copies of existing files. Templates are perfect for spreadsheets that are repeatedly needed, such as on a weekly, monthly or quarterly basis. Excel templates have the ".XLT" file extension and can contain formatting, text, graphics, styles, headers, footers, formulas and even macros. When templates are used to create a new spreadsheet, a copy is made, leaving the original template intact for future use.

You won't believe how easily templates can be used to improve productivity. Stop recreating the wheel! This webinar will walk you through the process of creating dynamic Excel Templates.

Almost everyone has seen or worked with a chart at one time or another--charts illustrate data, relationships, or trends, graphically. Like the saying“a picture is worth a thousand words” charts are often a better tool for presenting information than hard-to-read numbers. This Webinar covers just about everything there is to know about charts. The dazzling charts you will be able to create after you finish this course will impress both you and your colleagues.

• What is a Chart?
• Selecting Data
• Chart Types
• Create a Chart
• Format Your Chart
• Edit a Chart
• Create Chart Templates

Do you wish you could find a way to increase your accuracy in data manipulation and get it all done faster? These days, it seems there's more to do and less time in which to do it, so it's crucial to find ways to automate your every day tasks. Efficiency will help eliminate your daily grind. With so much information on your hands, it can be painstaking and time-consuming to sift through data and manipulate it to present exactly what you're looking for.

Macros are one of Microsoft Excel's most powerful, yet most underused, tools. Many users are familiar with the term but have never learned how to take advantage of all macros have to offer. They might sound complicated; within this one hour Webinar we will show you how to become a more proficient user with automating your tasks. You will be working smarter and faster than ever before!

Tables just may be the single most important feature you can learn in Word to help create more compelling, interesting and relevant documents. Tables can help present information in a more clean, interesting and compelling fashion. In fact, you may just hear someone say“you did that in word?” after looking at your new super document complete with tables. While some table elements are simple, others get more complex; this webinar is designed for the moderately experienced Word user.

Some of the things you will learn:

• Creating tables
• Format tables using the galleries
• Add rows and columns to your tables
• Insert graphics within your tables
• Add or change borders
• Resize and combining cells in your tables
• Creating forms with the table function

Nothing is worse than being handed a long, confusing document with poor referencing, or worse, inaccurate referencing. The Table of Contents tool is a huge time-saver and a necessary tool for long documents. Along with foot notes and cross-references, these functions make up a nice bundle of features that will make navigating long documents a snap, and might even help you in the creation process.

Some of the things you will learn:

• Introduction to styles
• Create a Table of Contents
• Use Table of Contents as a navigation tool within Word
• Update fields
• Create footnotes, endnotes and cross-references
• Convert note types

Creating Mail Merges can be an anxiety producing activity, but it doesn’t have to be. This time-saving tool does so much, in so little time. The key is unlocking how it works and the extent of its potential. Once we do that we can create beautiful, simple merges and not need a meditation session to re-center our being.

This workshop is designed for the intermediate Word 2007 user who is already familiar with basic Word 2007 document creation, and who has a need to create multiple documents that contain data from an external data source.

Some of the things you will learn:

• Creating a Form Letter
• Creating a Data File
• The ins and outs of the Mailings tab
• How to edit individual letters in a merge
• Mailing labels

Why use tabs? This workshop will answer that question as well cover how to set, move, and remove them. Using the tabs dialog box allows you to create fancy leader. Need to keep a paragraph together or have a paragraph always remain at the top of a page. This workshop will cover this and more.

You’ve been asked to put together a presentation using PowerPoint, and you have no idea how to begin. Get equipped with the skills to do the job. We’re not talking fancy; the goal is to prepare you with the basics, how to put content on slides and get ready to present a show. The bells and whistlescan come later.

• Interface Tour
• Create& Edit Slides
• Add Pictures from Computer
• Add ClipArt
• Animations& Transitions
• Run a SlideShow

Using Access 2007 Mail Merge Wizard is an efficient tool when you need to create merged letters, envelopes, labels, and email messages. In this webinar we will set up a mail merge using both tables and queries. We will walk through the steps using the Mail Merge Wizard working with existing Microsoft Word documents and create new documents. Matching fields between Microsoft Access and Word will also be covered.

In this Webinar, you will get acquainted with the Photoshop environment, and the technical fundamentals of editing bitmap images. We will demonstrate how to determine and modify the dimensions and resolution of source images. We will also demonstrate the use of several basic selection tools (possibly the most important tools in all of Photoshop), and how to use the tools to remove the background of an image.

• Overview of Photoshop Environment
• Introduction to Working with Bitmap Images
• Resize Images
• Explain Resolution and Methods of Modifying Image Resolution
• Use Basic Selection Tools

About the Presenter:  Matt Wohl is a Senior Applications Instructor with a background in Microsoft Office and Adobe’s design software. Matt has been an Instructor for 8 years.  He has created and delivered multiple“Train the Trainer” programs. As a designer, Matt first began using Adobe software in 1996, has worked for several advertising agencies and also as a freelance designer.  He’s led corporate implementations of new software and written courseware for all applications in the Office Suite. He currently specialized in classroom instruction as well as and designs and delivers corporate and open enrollment webinars.

Even the finest digital photographers need to spruce up their images. This Webinar focuses on the techniques Photoshop offers for correcting exposure and contrast problems as well as retouching elements of an image. We will walk through the correction and retouching of a photo for a brochure, covering adjustment layers, Levels correction, and retouching tools as we move through the process.

Correction Tools

• Levels
• Brightness/contrast
• Hue Saturation

Adjustment Layers

Basic Retouching Tools

InDesign is a powerful print layout application. In this Webinar we will discuss the many applications for InDesign and learn how it integrates with Photoshop and Illustrator. We will take a comprehensive tour of InDesign's workspace, learning how key tools work and how to prepare for your first page layout.

• Overview of the InDesign Interface
• How to Integrate InDesign with Other Creative Suite Applications
• Place Text in InDesign
• Place Graphics in InDesign
• Explain Package Process

This Webinar is all about creating multi-page print documents. InDesign makes it easy to add pages, page numbering, organize your multi-page layouts, and use recurring elements on multiple pages using master pages. In addition, we’ll give an in-depth explanation of, text and image frames and show how these are flexible tools for creating these design features.
 * Facing Pages Layouts
 * Add Pages to a Layout
 * Explain Master Pages
 * Pages Panel
 * Page Numbering
 * Advance Text and Frame Options

As you'd expect from any page layout tool, Adobe InDesign has a wide array of options for typography, allowing you to make very specific typeface and text layout choices in your projects. You'll explore the ins and outs of various powerful type features in this Webinar, including Autoflow, placeholders, wrapping, and paragraph and character styles that you can apply to blocks of text with just a click. 

 * Autoflow
 * Placeholder text
 * Text wrapping
 * Paragraph Styles
 * Character Styles

Illustrator may be the least understood, and in some areas, most powerful of the Creative Suite. In this Webinar we will demonstrate the uses of Illustrator and the arsenal of features in the Illustrator tool kit. We’ll show how to create and save files, access basic palettes and drawing tools, manage your workspace, and select colors..

• Overview of the Illustrator Environment
• Create an Illustration
• Save Options
• Manage Your Illustrator Workspace
• Select Colors

True Illustrator mastery comes from the ability to quickly select and manipulate any detail in your artwork.

This Webinar will equip you for this task with a focus on the direct selection tool, anchor points, and the pasting and grouping of objects. You'll learn how to use drawing aids such as the ruler, guides, and smart guides. Drawing tools including the paintbrush, pencil, smooth, and eraser tools are explored along the way. The lesson culminates with tips on how to organize your work in layers and output your illustration in a useful format.

• In-Depth Selection Techniques
• Anchor Points
• Pasting
• Grouping Objects
• Rulers and Guides
• Drawing Tools

In this Webinar we tackle the path tools that can cause beginning Illustrator users fits. You'll learn how to paths straight, curved, open or closed paths and manipulate anchor points to create different effects. You'll also learn tips and techniques to smooth curve and how to use the carving tools such as scissors and knife. In addition we’ll cover how to arrange objects on your art board, group and space elements. Finally, we show the all-powerful Pathfinder palette as a means of creating new modified shapes from existing lines and objects.

• Explain Path Components
• Draw Paths with Pen and Pencil
• Edit Paths with Direct Select and Path Alteration Tools
• Dissect Paths with the Knife and Scissors Tool
• Explore Options of the Pathfinder Palette

Google Analytics is a powerful, free service from Google that allows you to track and understand your website visitors. The more you know about your customers, the better you can market and sell your services online. You can see where your website visitors came from before they landed on your website, see what kind of search keywords they used to find you, see how they traveled through your website, and much more.

This webinar introduces you to the concept of web analytics, covers the basics of setting up a Google Analytics account, and shows you how to place the tracking code into your web pages.

Word processing the Google way! We cover the basics, from creating documents and identifying interface components, to formatting documents using styles. In addition we look at how to work offline in another word processing application and upload it into Google Documents later on. This is a valuable primer for anyone looking to Google Documents to solve their word processing needs.

Change; Love, or hate it, it’s a way of life. Coming to understand can help you embrace it and the new possibilities that come along with that change. This is true of Microsoft Office 2007. Office 2007 has a whole new look and new features to go with it. This Webinar explores the new Office interface and the dynamic featuresof the Office Suite. While each application has new features, we will look at the common elements throughout the new interface. We will also go into Word, Excel and Outlook to point out some of the big changes. If you have Office 2007, this webinar is a must to get you on the path to embracing thechange. Word has exciting new features to help you create, manage, and distribute documents. Excel has Smart Art, tables, and improved conditional formatting. Outlook’s To Do Bar is a way to view dates, upcoming calendar appointments, and tasks all while looking at your email.

Some of the things you will learn:

• The Office Interface (The Office Button,
• Ribbons, Quick Access Toolbar, Contextual Tabs and Dialog Box Launchers)
• How to deal with documents from  earlier versions of Office
• How to use SmartArt
• New distribution features in Word
• Improved conditional formatting in Excel
• Benefits of the To-Do Bar in Outlook
• Improved Calendar and Task features
  

This workshop is for the Word users who need to create document templates in order toquickly produce similar documents. You will learn how to create a templates instead creating your work from scratch each time. In addition, users will learn to create time-saving forms with different field types for fast input and repetitive use.

Data, Data everywhere but what does it all mean.  Data tells a story and sorts and filters help define that story.  This function-packed workshop covers how to sort your data by multiple criteria, filter data using auto filter and custom filters and use conditional formatting to make it look good.

 * Sort Data
 * Create Subtotals
 * Use Find/Replace
 * Filter Options
 * Conditional Formatting

Word, the backbone of the Office Suite, and, for most of us, the application we spend most of our time in, no longer looks like Word. How dare they? Along with the new look comes some valuable and useful new functions. Many of the new features either save us time doing things we used to do, or help us share our documents with other users or applications in the Office Suite. This webinar explores the new user interface, galleries, review, prepare, and distribute documents.

Some of the things you will learn:

• What’s where in the new interface
• How to use galleries
• New Distribute options
• How to prepare a document for distribution

Excel manages numbers and other data. Users get comfortable with the certainty that comes from dealing with the concrete mathematical principles. It can get very unnerving when your comfortable world is discarded for a new unfamiliar one. Welcome to Excel 2007. All, or at least most, of our favorite functions are still there, but they may not be where we think. In addition, there are some great new features added to the Excel package. By the end of our webinar, you’ll start to feel that comfortable feeling, again.

What you will learn:

• The elements of the Excel 2007 interface
• How to work with files from older versions of Excel
• Enhanced conditional formatting
• Galleries
• Formatting your spreadsheets as a table
• AutoFill for functions

Microsoft Excel is a powerful tool for analyzing business data. Because of the increasing demands on their time, business professionals need to learn efficient and effective data forecasting methods that give them the answers they need.

Whether you’re running a small business or you work in a large corporation, you can use Excel to create worksheets for tracking and projecting sales. This Webinar will include the magic of using Excel, the best forecasting tool on the market and you will be introduced to the concepts of multiple case scenarios.

Microsoft SharePoint Designer 2007 is the new incarnation of Microsoft FrontPage. SharePoint Designer 2007 is the best web design product yet from Microsoft. This webinar provides an introduction and overview of SharePoint Designer 2007, highlighting what’s new and different compared to previous versions of FrontPage or Adobe Dreamweaver. Along the way, the basics of creating a site and web pages are covered.

Document Libraries are one of the core features of SharePoint. Document Libraries solve several pressing problems organizations experience with document management: security, version control, and group collaboration.

In this 60-minute webinar, we’ll go over the features of SharePoint Document Libraries and how to use them. Topics covered are uploading and creating documents in a library, editing documents from a library, document check-in and check-out, and version control.

Microsoft SharePoint is all about collaboration and sharing information with groups.Two chief ways this happens in SharePoint is in document collaboration and in the planning of meetings. SharePoint has powerful but easy-to-use document collaboration workspaces and meeting workspaces to get the job done.

Topic covered in this 60-minute webinar include setting up document and meeting workspaces, managing them, and controlling document publication versions and schedules

Tables just may be the single most important feature you can learn in Word to help create more compelling, interesting and relevant documents. Tables can help present information in a more clean, interesting and compelling fashion. In fact, you may just hear someone say“you did that in word?” after looking at your new super document complete with tables. While some table elements are simple, others get more complex; this webinar is designed for the moderately experienced Word user.

Some of the things you will learn:

• Creating tables
• Format tables using the galleries
• Add rows and columns to your tables
• Insert graphics within your tables
• Add or change borders
• Resize and combine cells in your tables
• Creating forms with the Table function

Are you tired of performing the same repetitive steps on document after document? Do you wish Word had an“easy” button? Then macros may be the tool for you. Macros allow users to record a series of actions within Word to be “played back” later. From simple to complex strings, macros help make you a more efficient user. This 60 Minute Webinar will help you save time by automating your tasks.

This workshop is for the advanced Word 2007 user.

Some of the things you will learn:

• How macros work
• How to record macros
• How to edit macros
• Create macros to be used in a single document
• Edit macros
• Delete macros

Don't spend another day manually filtering information from your spreadsheets in order to find the answers to your most pertinent business questions. Utilize the built-in formulas that Excel has to offer and get accurate results in a snap! This Webinar focuses on how to work with formulas and functions in Excel worksheets. Formulas are equations that perform calculations on values in your Excel worksheet. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

Learn formulas that will help you with specific business tasks, such as:

• Calculating loan repayment
• Creating amortization tables
• Identifying the potential future value of investments
• Using Excel’s discounting functions to analyze cash flow values and rates of return

Access reports are extremely powerful, and Access is considered by many to be the best report generator for Microsoft Windows-based databases. Learn efficient techniques for generating informative reports from your Access database. This is a beginner Webinar that focuses on the reporting features within Microsoft Access.

Some of the things you will learn:

• Define reporting
• Use Report Wizard
• Format reports
• Edit reports
• Create Group Report
• Create mailing labels

Creating Mail Merges can be an anxiety producing activity, but it doesn’t have to be. This time-saving tool does so much, in so little time. The key is unlocking how it works and the extent of its potential. Once we do that we can create beautiful, simple merges and not need a meditation session to re-center our being.

This workshop is designed for the intermediate Word 2003 user who is already familiar with basic Word 2003 document creation, and who has a need to create multiple documents that contain data from an external data source.

Some of the things you will learn:

• Creating a form letter
• Creating a data file
• The ins and outs of the Mailings tab
• How to edit individual letters in a merge
• Mailing labels

Are you tired of performing the same repetitive steps on document after document? Do you wish Word had an“easy” button? Then macros may be the tool for you. Macros allow users to record a series of actions within Word to be “played back” later. From simple to complex strings, macros help make you a more efficient user. This 60 Minute Webinar will help you save time by automating your tasks.

This workshop is for the experienced Word 2003 user.

Some of the things you will learn:

• How Macros work
• How to record Macros
• How to edit Macros
• Create Macros to be used in a single document
• Edit Macros
• Delete Macros

When working with spreadsheets, you may want to use the same layout or design multiple times. Templates are a way to take a spreadsheet and reuse it over and over again without going through the time-consuming steps to make copies of existing files. Templates are perfect for spreadsheets that are repeatedly needed, such as on a weekly, monthly or quarterly basis.

Excel templates have the ".XLT" file extension and can contain formatting, text, graphics, styles, headers, footers, formulas and even macros. When templates are used to create a new spreadsheet, a copy is made, leaving the original template intact for future use.

You won't believe how easily templates can be used to improve productivity. Stop recreating the wheel! This webinar will walk you through the process of creating dynamic Excel Templates.

Data, Data everywhere but what does it all mean. Data tells a story and sorts and filters help define that story. This function-packed workshop covers how to sort your data by multiple criteria, filter data using auto filter and custom filters and use conditional formatting to make it look good.

 * Single Level
 * Multiple Level
 * Data Form
 * Auto Filter
 * Advanced Filter
 * Retrieve Data from Access Database
 * Conditional Formatting

Do you wish you could find a way to increase your accuracy in data manipulation and get it all done faster? These days, it seems there's more to do and less time in which to do it, so it's crucial to find ways to automate your every day tasks. Efficiency will help eliminate your daily grind. With so much information on your hands, it can be painstaking and time-consuming to sift through data and manipulate it to present exactly what you're looking for.

Macros are one of Microsoft Excel's most powerful, yet most underused, tools. Many users are familiar with the term but have never learned how to take advantage of all macros have to offer. They might sound complicated; within this one hour Webinar we will show you how to become a more proficient user with automating your tasks. You will be working smarter and faster than ever before!

Microsoft Excel is a powerful tool for analyzing business data. Because of the increasing demands on their time, business professionals need to learn efficient and effective data forecasting methods that give them the answers they need.

Whether you’re running a small business or you work in a large corporation, you can use Excel to create worksheets for tracking and projecting sales. This Webinar will include the magic of using Excel, the best forecasting tool on the market and you will be introduced to the concepts of multiple case scenarios.

Bulleted lists, clip art and photos are just the beginning when creating a PowerPoint presentation. Many of us are aware of PowerPoint’s strength and flexibility for designing presentations. However, far fewer take advantage of ability to create effective and eye-catching diagrams and charts. PowerPoint has built in tools to create stunning organization charts and process diagrams as well as a charting tool for mapping numeric data. In this workshop we will create several types of basic diagrams, format the diagrams and edit their content. We will also use the charting function and data sheet to enter data in PowerPoint and create visually attractive charts. If your data already exists in Excel, no problem. We’ll show you how to create a chart in Excel, incorporating your Excel data, and paste it into your PowerPoint presentation.

Some of the topics covered in this event include:

• Defining Diagrams and Charts
• Creating a Process Diagram
• Creating an Organization Chart
• Formatting a Diagram
• Editing a Diagram
• Creating a Chart in PowerPoint
• Importing an Excel Chart into PowerPoint

Explore the powerful new features in the Windows Vista operating system, including, the new user interface, search, and organizational tools. We also provide useful tips on using Windows Internet Explorer 7 and illustrate practical desktop techniques that help you to be more productive right away. Join us for this informative session to see how Windows Vista represents a breakthrough in user experience.

You’ve been asked to put together a presentation using PowerPoint, and you have no idea how to begin. Get equipped with the skills to do the job. We’re not talking fancy; the goal is to prepare you with the basics, how to put content on slides and get ready to present a show. The bells and whistlescan come later.

• Introduction to PowerPoint
• Working with AutoShapes
• Working with ClipArt
• Using Design Templates
• Using Animation& Timings

Access reports are extremely powerful, and Access is considered by many to be the best report generator for Microsoft Windows-based databases. Learn efficient techniques for generating informative reports from your Access database. This is a beginner Webinar that focuses on the reporting features within Microsoft Access.

Some of the things you will learn:

• Define reporting
• Use Report Wizard
• Format reports
• Edit reports
• Create Group Report
• Create mailing labels

Easily handle even the most impossible projects without the stress, frustration and worry. Learn how to unleash the power of Microsoft Project and complete all your projects, large and small, on time and on budget. This innovative webinar will walk you through many of the software's incredible, built-in features and you will learn how to use them to improve the way you manage tasks.

Just imagine, in one hour you will be able to build a project outline, create and modify task relationships, assign resources to tasks, work with different views and tables, create a baseline and track project progress, manage an active project, work with resource needs and communicate project information effectively.

Networking is the set of communication skills required to build relationships, inform others, and learn from and about co-workers and clients. Managing the impression you make and maximizing your‘like-ability’ are the keys to making every networking opportunity consistently profitable. First impressions really are important. The way you greet people can set the tone for the entire interaction that follows. If you make a poor initial impression, you may spend the rest of your time overcoming it.

In this interactive webinar you will be given tips on putting your best foot forward with the right handshake, effective introductions, and presenting and requesting business cards with confidence. You’ll master the principles of impression management by exploring perceptual tendencies, the ins-and-outs of small talk, and the subtleties of social diplomacy.

Also, remember why you’re attending. Be sure to be well prepared to create business opportunities through pre-contact planning: personal objective, agenda items, questions to ask, and referrals to get.

Appreciate the simple skills of authentic client communication by knowing how to tap into the autobiographical urge of others. Asking the right questions at the right time builds your emotional foundation with existing, or prospective, clients. Overcome the obstacles that hold us back from making the invaluable connections that make us memorable. Give others the opportunity to tell their story and realize that money flows in the direction of biographical knowledge.

Conversing with your clients at the office, a conference, a sporting event, or any other venue is always an opportunity to create and strengthen the relationship, or to inadvertently weaken it. It’s the conversations we have that build relationships. Understanding the ingredients of good conversation, knowing what to say and when, directing and redirecting the interaction, and being capable when it becomes difficult, are the hallmarks of excellent conversation management.

Learn the necessary techniques to gently promote business by comfortable transitioning conversations from social to business. Make sure your attendance at professionally endorsed social events leads to business every time.

Remember, our personal and professional successes are, to a large extent, dependent on our ability to get others to agree with our position. We sometimes achieve this agreement by chance; however, with careful use of certain strategic communication techniques we can learn to develop the kind of rapport with people that consistently creates the results we want.

Interactions at work with colleagues, supervisors, and clients don’t always go as smoothly as we’d like. One’s ability to maintain control in difficult to control situations is the hallmark of excellent communication’s ability.

This highly regarded 60 minute webinar uncovers the often hidden motivations of why we act the way we do, and provides practical, easy to implement, strategies to turn negatives into positives and strengthen interpersonal relationships.

Join us for this illuminating professional development experience and learn the relevant skills of Dealing with Difficult People and Situations.

When you begin the task of designing your own marketing materials, you may think that Photoshop is the tool for you. Others may and claim its InDesign or Illustrator. The reality is that each of these applications plays a definite and unique role in the design process. This webinar will uncover the benefits of each application and which to use when, and why. In the process we will also cover some basic principles of graphic design.

• Explanation of the Creative Suite Applications
• Definition of Raster vs. Vector Images
• Outline of Graphic Design Workflow

Crystal Reports is a powerful tool for analyzing information. It allows you to design and generate reports from a wide range of data sources with the goal of examining your data in an organized, meaningful way. This Webinar assumes that you have no previous experience with Crystal Reports. You will be introduced to basic database reporting, formatting, as well as grouping& sorting, and much more.“Designing a Basic Report” is your first step on the way to using Crystal Reports to its full potential.

What you will learn:

• Crystal Reports Overview
• The Work Area
• Basic Formatting
• Basic Grouping& Sorting
• Summary Functions
• Inserting Objects into Reports
• Previewing& Exporting Reports

Now that you know the basics, it’s time to get into the nitty gritty of reporting. In this 60-minute Webinar you will be introduced to the Report Wizard, custom grouping, fields, and other more advanced features of this dynamic reporting tool.

What you will learn:

• Report Wizard - Multiple Tables
• Grouping Expert
• Create Custom Grouping
• Fields - Dimensions vs. Metrics
• Select Expert
• Export Options

In this final installment of our Crystal Reports series you will be introduced to more complex report writing features. You will look closely at report options, grids and layout options, and many other Crystal Reports features that will equip you with the skills you need to take your reporting skills to the next level. This 60-minute Webinar is for the intermediate Crystal Reports user.

What you will learn:

• Report Options
• Grids& Layout Options
• Section Expert
• Colors/Fonts/Borders
• Graphic Files
• Drawing Lines
• Field Options
• Special Fields 

Time is a finite resource– we all have the same amount to work with. Why are some of us so much more effective than others? These days we hear the terms- doing more with less, fewer people but the same amount of work, faster, quicker, better! Most of us already have trouble with effective time management but now strong time management skills are more important than ever.

In this 60 minute webinar, we’ll discuss the difference between time management and behavior or choice management. We’ll help you identify your most productive times and how to best fill these finite time blocks. Learn how to establish priorities and identify critical task. Leave this webinar with tools for directing your energies toward things that will move you closer to your personal and professional goals.

Join us for this webinar designed to broaden your thinking for approaching your leadership role. We’ll focus on specific steps and techniques for leading your team toward your most productive business goals. This powerful webinar examines the 12 key questions for effective employee development from the book: First, Break All the Rules. We’ll examine some of the top recognized leaders and whatis the difference between managing and leading? Leave this hour will specific ideas on implement ting your leadership vision to see positive performance changes right away.

It seems the days of expecting to get good customer service are gone– with budget cuts, fewer employees, and lower profitability, what business has time?  This environment creates the opportunity for companies who provide consistent, better than expected customer service to win.  We want to create fanatical customers!

In this webinar, we’ll discuss how to search for opportunities to exceed our customers’ expectations. We’ll also discuss some key tactics and phrases for making the client feel empowered and happy with their experience. Spend this hour discussing how to brand yourself consistently and discover techniques for becoming a solution focused customer service provider.  Leave this webinar with the confidence and motivation to make a difference for both internal and external customers.

Are your accounting records always up-to-date? Or do you spend hours when you get your bank statement typing in all the credit card transactions that came into your account during the month? Many small companies turn to QuickBooks to keep their company finances on track. QuickBooks makes accounting easy with some great tools that will help you organize your finances. With QuickBooks you can easily track sales and expenses, create professional documents, and instantly see your account history with any customer or vendor. In this 60 minute Webinar students will learn the fundamentals of working with QuickBooks 2009.
 
This webinar covers the following QuickBooks topics:
* Creating a QuickBooks Company
* Entering Account Opening Balances
* Setting up your Chart of Accounts
* Orientation to QuickBooks
* How to set-up your data in QuickBooks and get started the right way
* Using QuickBooks for billing customers
* Receiving payments and making deposits
* Monitoring customer payment status
* Entering and paying bills
*  Introduction to financial statements
* Writing a QuickBooks Check
* Entering a Handwritten Check
* Printing checks
* Using Bank Account Registers
* Transferring Funds Between Accounts
* Reconciling Checking Accounts

You have questions. We have answers… to where your favorite Office 2003 tools are now located on the Ribbon Bar in the Office 2007!

In this 30-minute webinar we will look closely at the new Office Interface (The Office Button, Ribbons, Quick Access Toolbar, Contextual Tabs and Dialog Box Launchers)!

While each application has new features, we will look at the common elements throughout the new interface.  If you are new to Office 2007, this webinar is a must!  Let us help you get up to speed on all of the upgrades and get comfortable with the new look.

 * Office Button
 * Ribbons Explained
 * Quick Access Toolbar
 * Contextual Tabs
 * Dialog Box Launchers

There’s a saying, if a database has business-altering data but you can’t share the information, will anyone hear it? OK, we may be paraphrasing but reporting on information in your database is a crucial component of having and maintaining a database. In this session we’ll cover the purposes and benefits of reporting as well as describe the sections of database reports as used in Crystal Reports.

If you are new to reporting, or Crystal Reports, this webinar will get you headed in the right direction.

• Why Reports?
• What Does Crystal Reports Do?
• How Does Crystal Reports Work
• Introduction to Report Sections

Proficient users in Excel can still discover new features and tools to accomplish more each day. In this 60-minute webinar, Excel expert Dennis Taylor will demonstrate numerous little-known features, and shortcuts that will save you time in your busy day. These must have Excel Skills for today's highly effective worker will help you stay more organized and on task with Excel. You will learn new shortcuts that will impress even the most experienced Excel users. This webinar will give you tips on mastering formats, commands, functions and formulas. You will learn new ways to make your spreadsheets communicate your message and look professional. You will feel more confident with how to develop clean presentations and you will learn navigation tips so you can effortlessly move through worksheets& workbooks.

Join us to discover these essential Excel tips and techniques that will save you time, which will save you money.

Question and Answer Session - Hear expert answers to your specific Excel questions at the end of the 60 minute presentation.

Included in this Webinar:

• Copy/Move/Paste Techniques
• “No commands” approach
• Convert formulas to values
• Multiple-cell formula entry
• Navigation Techniques
• Scope out workbooks quickly
• Switch sheets with mouse/ keystroke
• Move up/down/across worksheets
• Switch workbooks
• Formula Tips
• Displaying Formulas
• Absolute/Mixed cell references
• Tracking Dependent and Precedent Cells
• Using row/column references in formulas
• Efficient Data Entry
• Current Date/Time; Months, Days, Quarters series
• Value series
• Custom lists
• Chart Creation Tips/Techniques
• Formatting Tips
• Multiple line entry
• Rotating text– toolbar options
• SS#, Phone, Date, and Time Formats
• Operational Tips
• Insert/Delete/Hide with speed

About the Presenter:Dennis Taylor is the author of“Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 12 years. Dennis has over 20 yearsof training and consulting experience. As a former employee of Amoco Oil, IBM, Lexmark, Texaco, Levi Strauss, StorageTek, the Federal Government, and the University of Colorado, he has taught over 3,000 seminars and classes attended by over 15,000 students.

Have you always wondered how people create some of those clever little animations you see on websites? Or, have you been asked to create an interactive graphic and have no idea where to start? If so, this is the Webinar for you! Learn how to morph an image into text and vice versa. Learn how to quickly and easily make an animated movie for your website in this 60-minute Webinar.

This webinar covers the following Flash topics:

• Importing a bitmap image into Flash
• Creating and Modifying Text in Flash
• Converting Text to Shapes
• Converting Shapes to Text
• Create Animation with Frames and Keyframes
• Create a Motion Tween Animation
• Create a Shape Tween Animation

About the Presenter:Annie Denny is a Software Applications Instructor with a long background in Microsoft Office applications as well as the Macromedia suite.  With 12+ years of training experience, she brings a wealth of real-world application knowledge to the classroom.  In addition, Annie continues to maintain several independent websites.  She has also written curriculum for dozens of instructor-led courses, as well as customized private courses and online Webinars.

Know the basics in Flash already? Need to go more in-depth with animation? How about adding audio to your movies? It’s time to use some of the advanced functionality of Adobe Flash CS4. It is a powerful tool used predominantly on the web. Getting a handle on it may just be easier than you think! Learn how to design and develop more complex Flash projects in this 60-minute Webinar.

This webinar covers the following Flash topics:

• Adding Motion to Flash Animations
• Applying 3-D Transformation to Objects
• Applying Effects to Objects
• Importing Audio
• Controlling Audio

About the Presenter:Annie Denny is a Software Applications Instructor with a long background in Microsoft Office applications as well as the Macromedia suite.  With 12+ years of training experience, she brings a wealth of real-world application knowledge to the classroom.  In addition, Annie continues to maintain several independent websites.  She has also written curriculum for dozens of instructor-led courses, as well as customized private courses and online Webinars.

Windows 7 is new from the ground up. In this session we will uncover many of the new features that distinguish this version of Microsoft’s operating System from its predecessors. Windows 7 offers new features to view and organize open windows, search for files and programs and even control the number of notifications we see. We’ll demonstrate all this and much more as we reveal the workings of this eagerly awaited upgrade. Whether you’re already using Windows 7 or planning on making the switch, let us guide you on your way.

• Windows Search
• Aero Peek, Snap and Shake
• Notification Control
• Improved Task Bar
• Internet Explorer 8 Web Slices
• User controls

Excel has well over 300 functions - surely you don’t need to know them all, but you might easily be overlooking significant analytical tools that give you tremendous capabilities to tackle a myriad of statistical, mathematical, and financial challenges.

This 60 minutes webinar gives you exposure to those "buried" functions and gives you new and powerful tools, such as array formulas, that will make your usage of Excel even more powerful and efficient.

Also included are some of those valuable formula and function tips that you may have picked up in the Excel Power Tips and Shortcuts webinar– quick formula copying methods, creative use of Ctrl to create formulas in multiple locations simultaneously, and a host of others. 

Specific functions that will be covered include: IF, AND, OR, MATCH, INDEX, , FREQUENCY, TREND, GROWTH, TRANSPOSE,  PROPER, UPPER, TRIM, LEFT, RIGHT, INDIRECT, OFFSET, MOD, WEEKDAY, NETWORKDAYS, and DATEDIF.

Power Tips
 * Quick cell value changes without formulas
 * Displaying Formulas and selecting formula cells
 * Multiple cell formulas with the Ctrl key
 * Debugging tools and 3-D formulas

Power Functions
 * Extended uses of the IF and VLOOKUP Functions using AND, OR, NOT
 * MATCH and INDEX functions for complex 2-way lookups

Array Formulas
 * Simple applications
 * Counting unique entries in a range
 * Condense long IF functions substantially
 * MATCH and VLOOKUP array formulas

Special Array Functions
 * FREQUENCY
 * TEND and GROWTH
 * TRANSPOSE

COUNTIF, SUMIF, AVERAGEIF and new 2007 functions

Specialized Text Functions
 * PROPER, UPPER
 * TRIM, LEFT, RIGHT
 * Concatenation without CONCATENATE

The INDIRECT Function
 * Used with Data Validation for multi-layered pick list scenario

The OFFSET  and MOD Functions

Date Functions
 * WEEKDAY– extract day of the week
 * NETWORKDAYS– Calculate working days in a time frame
 * DATEDIF– Excel’s powerful (but undocumented) date calculator

Windows Movie Maker enables you to create home movies and slide shows on your computer, complete with professional-looking titles, transitions, effects, music, and even narration. And when you’re ready, you can use Windows Movie Maker to publish your movie and share it with your friends and family. Our free 30 minute Webinar is designed to introduce new users to the latest version of Movie Maker. This Webinar shows you how to use some of Movie Maker's many features to create exciting movies from captured video, digital photos, graphic files and more.

This webinar covers the following Movie Maker topics: 
  * Importing Video and Pictures
  * Editing Video Clips
  * Adding Special Effects
  * Inserting Transitions
  * Exporting the Finished Movie

About the Presenter:  Annie Denny is a Software Applications Instructor with a long background in Microsoft Office applications as well as the Macromedia suite.  With 12+ years of training experience, she brings a wealth of real-world application knowledge to the classroom.  In addition, Annie continues to maintain several independent websites.  She has also written curriculum for dozens of instructor-led courses, as well as customized private courses and online Webinars.

Swish is a powerful new tool that utilizes Flash to help you create advanced Flash animations with ease. It includes over 350 preset multimedia effects as well as over 180 ready-to-use components and vector shapes. Images, graphics, sound and video can be imported from all popular formats. Presentations can be exported to Flash as well as Video, EXE, GIF Animation or Image Sequencing. Swish contains powerful scripting language for advanced users as well as many tools to control motion, draw shapes and edit text. This free 30 minute webinar will introduce you to the ultimate Flash creation tool.

 * Create a New Animation
 * Adding and Modifying Text
 * Importing Images
 * Resizing Images
 * Adding Text Effects
 * Adding Image Effects
 * Inserting Keyframes
 * Testing in a Browser
 * Exporting the Movie

These days, Excel users are doing less data entry and a lot more downloading data from other sources. Whether that data is coming from Access, some other data base software, or a poorly designed Excel worksheet, it isn’t always in the best of shape.
Excel has a variety of functions, commands, and techniques that let you quickly re-structure data, remove unwanted characters, get rid of empty cells, rows, and columns, and prepare data for efficient analysis. This webinar will use Excel 2007, but will demonstrate techniques in Excel 2003 for those features that have been altered.

What you will learn:

  * The Text to Columns command– a powerful, yet simple command sequence that lets you quickly split data (improperly grouped into one column) into multiple columns; includes techniques for handling Julian dates another unusual groupings.
  * How to transpose data– a simple copy technique to convert data from a row/column into a column/row layout.
  * How to remove duplicate data  - use either Excel’s new 2007 command (Remove Duplicates) or the Advanced Filter in Excel 2003 to eliminate duplicate records.
  * The Find/Replace command sequence, including using special wild cards.
  * Critical Text functions– (LEFT, RIGHT, and MID) for character extraction; REPLACE and SUBSTITUTE for character swapping; CLEAN and TRIM functions to remove unwanted characters; PROPER and UPPER for quick uppercase/lowercase conversion
  * Concatenation techniques for pulling together data from different locations
  * Sorting techniques to eliminate blank rows or columns from data
  * Techniques for learning how to:
         * Convert text data to values
         * Remove trailing minus signs while converting data into negative values
         * Fill in missing title data from columns containing first entries only 
         * Alter any kind of date data into a more useful computational form

Visio is entrenched firmly between two worlds. On one hand, it’s a Microsoft Office application and looks similar to Word. On the other hand, it is a design program and works more like other design software. Regardless of your need for Visio, this webinar will uncover just how Visio operates. From the interface to templates and from Drawing types to page layout, this session is designed to give you the tools you need to get started.

 * Overview of the Interface
 * Creating Documents from Templates
 * Using the Visio Tools
 * Introduction to Organization Charts
 * Introduction to Flow Charts

About the Presenter:Matt Wohl is a Senior Applications Instructor with a background in Microsoft Office and Adobe’s design software. Matt has been an Instructor for 8 years. He has created and delivered multiple “Train the Trainer” programs. As a designer, Matt first began using Adobe software in 1996, has worked for several advertising agencies and also as a freelance designer. He’s led corporate implementations of new software and written courseware for all applications in the Office Suite. He currently specializes in classroom instruction as well as designs and delivers corporate and open enrollment webinars.

Process, process, process. Every business has it’s own set of processes for just about everything. Visio is a great tool for creating flow charts to set, evaluate or explain your internal processes. In this session we’ll discuss some basics behind how flow charts work, look at types of flow charts, add shapes and connectors and give the chartattractive formatting when it’s complete.

 * Basic Flow Chart Philosophy
 * Types of Flow Chart (basic, cross-functional)
 * Adding Shapes
 * Adding Connectors
 * Moving/Changing Shape
 * Adding Text
 * Change Themes

Every company has some type of organizational structure. At some point it will likely become necessary to create a chart accurately displaying your company’s structure. Due to the fact that every organization is unique, there are many ways to customize, tweak and bend Visio to create a chart that represents exactly how you and your colleagues co-exist. In this session we will show you how to create a basic organization chart and then take your chartto the next level customizing its different properties to meet your needs.

 * Organization Chart Theory
 * Adding Shapes
 * Changing Shapes
 * Change Shape Properties
 * Customize Fields
 * Format Chart

About the Presenter:Matt Wohl is a Senior Applications Instructor with a background in Microsoft Office and Adobe’s design software. Matt has been an Instructor for 8 years. He has created and delivered multiple “Train the Trainer” programs. As a designer, Matt first began using Adobe software in 1996, has worked for several advertising agencies and also as a freelance designer. He’s led corporate implementations of new software and written courseware for all applications in the Office Suite. He currently specializes in classroom instruction as well as designs and delivers corporate and open enrollment webinars.

Microsoft Publisher is a great page layout tool designed to easily and effectively create and publish professional materials in-house. In this 60 minute Webinar, you will learn how to plan, format, edit and print a project with this powerful piece of software. We will start by covering the Publisher interface and some of the basic tools. Then we will work on different projects using a variety of methods, tools and commands.

This webinar covers the following topics:

 * Creating a New Publication
 * Changing Publisher Options
 * Adjusting Page and Print Setup Options
 * Adding Text to a Frame
 * Inserting and Navigating Pages
 * Moving and Resizing Object and Frames
 * Drawing Lines and Other Objects
 * Inserting Pictures and Clip Art
 * Formatting and Printing

Whether you are using newsletters to share information with family and friends or to attract new business and customers, Microsoft Publisher’s newsletter function provides total layout and design flexibility. Publisher provides an easy-to-use interface that allows you to select the design layout and color scheme, format text and insert images quickly and easily to create a custom newsletter.

This 60 minute Webinar covers the following topics:

 * Exploring the Newsletter Templates
 * Modifying a Template
 * Creating Pages from Scratch
 * Inserting Text and Frames
 * Inserting Pictures and Clip Art
 * Moving and Nudging Objects
 * Using Text Overflow
 * Formatting Text and Headings
 * Working with Bullets and Numbering
 * Paragraph and Line Spacing
 * Spell Checking and Autocorrect
 * Using the Design Checker
 * Printing your Newsletter

Have you ever seen a great flyer, or a fantastic newsletter and wondered how it was created? Microsoft Publisher is one of many page layout programs available for just this purpose. In this 30-minute Webinar, we will look at many different examples of Publisher projects that can be easily and quickly created such as:

 * Flyers
 * Newsletters
 * Business Cards
 * Menus
 * Calendars
 * Labels and Envelopes
 * Brochures
 * Programs
 * Greeting and Invitation Cards
 * Catalogs
 * Award Certificates

Applications like Dreamweaver and SharePoint Designer allow users to create web pages in design views. However, to create fully functional designs that meet your needs it’s essential to have a working knowledge of Hyper Text Markup Language. In this session we will discuss what HTML is and how it works. From there we will discuss commonly used tags and the differences between HTML and XHTML.

 * What is HTML
 * The Difference Between HTML and XHTML
 * How HTML Works
 * Tag Syntax
 * Create Links
 * Introduction to Creating Tables

When you begin the task of designing your own marketing materials, you may think that Photoshop is the tool for you.  Others may and claim its InDesign or Illustrator.  The reality is that each of these applications plays a definite and unique role in the design process.  This webinar will uncover the benefits of each application and which to use when, and why.  In the process we will also cover some basic principles of graphic design.

  * Explanation of the Creative Suite Applications
  * Definition of Raster vs. Vector Images
  * Outline of Graphic Design Workflow

About the Presenter:
Matt Wohl is a Senior Applications Instructor with a background in Microsoft Office and Adobe’s design software. Matt has been an Instructor for 8 years. He has created and delivered multiple “Train the Trainer” programs. As a designer, Matt first began using Adobe software in 1996, has worked for several advertising agencies and also as a freelance designer. He’s led corporate implementations of new software and written courseware for all applications in the Office Suite. He currently specializes in classroom instruction as well as designs and delivers corporate and open enrollment webinars.

While Dreamweaver is part of the Creative Suite, it definitely marches to the beat of its own drum. In this session we discuss the fundamentals of web design and explore how Dreamweaver handles these tasks. This is a great introductory webinar for anyone looking into web design or Dreamweaver.

 * Web Design Basics
 * Explore the Dreamweaver Interface
 * Defining a site
 * Create a Web Page
 * Create Page Content
 * Formatting

Web pages are the building blocks of your site. In this session we discuss how to work in both design and code view to understand how these pages are created. Furthermore, we’ll cover how to add tables and images to a page and save your page as a template to create pages with a similar layout in the future. This webinar is designed for people with some, but limited experience in Dreamweaver CS 4.

 * Code View
 * Images
 * Basic tables
 * Create Links
 * Page Templates

Do you need to create a flow chart? Visio can help. Do you need to create a map to an event? Visio can help. Do you need to create an organization chart? Visio can help. Do you need to create a new office floor plan? I think you get the idea. Visio is a powerful design tool that provides companies with the ability to express multiple business functions with graphical charts and diagrams.

 * Application Overview
 * Discuss the Visio Functions
 * Where do I start?

It seems like just yesterday Microsoft launched Office 2007. However, it’s been three years and it’s time for a new version of the application suite. Office 2010 is built off the Office 2007 design, but don’t let that fool you. This is a new set of applications with new tools. If you’re looking to make the move to 2010, have already purchased the suite, or justcurious about the new features, let us be your guide to the future of Microsoft Office.

 * Interface Changes
 * What’s New in Word
 * What’s New in Excel
 * What’s New in Outlook

Are you wondering where your money is going? Let Excel help you stay on track by creating a budget. Whether it is for home or work Excel has the right tools to keep you on budget. A budget helps you compare your income with your expenses and plan for long range financial goals.

Topics covered include track your income and expenses, create a spreadsheet, build formulas, and test your new budget.
 * Budget Overview
 * Setup of worksheet
 * Build Formulas
 * Test Budget

About the Presenter:  With 8+ years of experience teaching the Microsoft Office Suite, David Thibault, Director of Education for KnowledgeWave Training in South Burlington, VT uses his upbeat, high energy teaching style in the classroom and online.  David has led corporate implementations of new software and written courseware for all applications in the Office Suite and 3rd party software.  He continues to specialize in classroom instruction as well as delivers corporate and open enrollment webinars.  His years in the field managing consulting projects have ranged from rollouts to upgrades and mentoring services, giving him the“real-world” knowledge that brings so much value to his classroom and online lessons.

Although Excel is not typically described as database software, many Excel users maintain large lists of data and they need the tools to manage that data efficiently. This session focuses Excel’s many powerful and easy-to-use database commands and methods critical to anyone who maintains an Excel database. This session explores many of Excel’s techniques needed to modify, build, and manage an Excel database, including: validating data, using Excel’s Form feature, sorting, adding subtotals, filtering, and advanced filter.

Note: This session will use Excel 2007 as the primary platform for demonstrating these features, but will note the differences from Excel 2003 and will show some features in that version as well.

Topics include:

Data Validation - prevent bad data entry - keep out bad data before it ever gets into a database
 * Restrict cell content by forcing users to pick entries from a pick list
 * Restrict cell content by value, text, or data/time
 * Restrict cell content by formula
 * Use auditing tools to check the validity of existing data
Sorting
 * Use multiple-key sorts from the menu or from button commands
 * Sort based on re-arranging rows or re-arranging columns
 * Sort based on cell colors or in random order
 * Sort data based on customized lists
Creating automatic subtotals with the Subtotals command
 * Set up single and multiple-level subtotals
 * Expand and collapse displays quickly with grouping and outlining symbols
Data Form - Build and maintain a database with the Form feature
Using the powerful Filter command to view just the data you want to see
 * Set up filtering to see and print a subset of data
 * Create compound selection criteria for filtering data
 * Use Excel 2007 greatly expanded special filtering tools for Text, Number, and Date fields
 * Use the Advanced filter for extended filtering needs

About the Presenter:Dennis Taylor is the author of“Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 12 years. Dennis has over 20 yearsof training and consulting experience. As a former employee of Amoco Oil, IBM, Lexmark, Texaco, Levi Strauss, StorageTek, the Federal Government, and the University of Colorado, he has taught over 3,000 seminars and classes attended by over 15,000 students.

You are on your way to becoming a Dreamweaver master! Now that you have the basics under your belt, it’s time to explore advanced formatting techniques in Adobe Dreamweaver CS4. In this 60-minute webinar, you will learn how to develop websites with advanced functionality.

In this course, you will use the advanced features of Dreamweaver to design and develop professional-looking websites.
  * AP Elements
  * Creating Forms
  * Working with Spry Elements
  * Embed Media

If you’ve been wondering what this whole Google thing is about, then this is the place to start.  Far beyond a search engine, Google has created a suite of applications and services individuals and businesses.  From email and calendars to word processing and spreadsheets, Google has an app for that.

*Getting Started
Once you’re ready to dive into the world of Google, it’s time to create an account and get the lay of the Google landscape.  This session will show you how to set up a Google account and where some of the basic applications you will use are located and how they work.
*File Sharing
One of the great features of Google Apps is the ability to share files with other Google users.  In this session we discuss the benefits of file sharing and the different methods for using this valuable tool.  We also cover creating shared folders, to share entire document collections.
*Revisions
One of the great advantages of using Google Documents is the built-in ability to track revisions to documents.  We will take a look at how to track revisions of shared documents in the Google Documents environment.