§ Studio is opposite general-audience, multiple-concepts, full day training; Studio is for a target audience, with a specific need, in 2 hours time. Instead of teaching material not needed for their job, Studio teaches exactly the features they need to do their job while often leaving with a finished product. It saves them time and saves you training dollars. Studio not only results in a trained employee, but because of its problem-solving approach to training, Studio results in improved job effectiveness and overall efficiencies

§ Use of experienced highly skilled instructors knowledgeable at advanced levels capable of handling most any scenario

§ Designed for the busy professional to fit into their schedule with a suggested duration of 2 hours

§ Foundational Studios are available for the basics then a student can choose elective courses based on their job, project or need at the time, without “wasting” time on not needed material.

§ Studio saves time and money; Studio reduces job related problems because it makes information accessible and meaningful. Studio is a duration that benefits you and the student, not the trainer

§ It is real-world application training

§ It is empowering and it is significant; it is what makes The Solutions Group so unique.

How to Schedule Large Groups

Because of the focused content, most any class size is possible if the individuals are working with similar data or with the use of generic data files; however, if individuals are managing different data or data at different levels of development, or with unique challenges and objectives, the groups should be carefully scheduled. Consider the following ways to effectively schedule groups for Studios. Use the following checklist to create effective Studio groups.

1. All are managing a similar type of data at the same level of development

2. All are tasked to do a similar thing or

All have a similar job description or

All are from the same workgroup

3. All are at the same skill level or have the same product knowledge

4. All agree to bring work that is at the same level of development or

All agree to train using generic data files or to develop the same templates (i.e. like is done in the foundational studios)

When to Schedule Individuals or Small Groups

1. The nature of the work, data or individual(s) requires a small class.

Excel ™Studios

Overview

1 Efficiency Management Studio

2 Foundational Studios

4 Spreadsheets and Charting Studios

4 Database Studios

Target Audience - Data Administrators

Pre-requisites – 2 Foundational Excel Studios

Delivery - Instructor-led, job / project specific with optional student provided data/documents.

Duration: 2 Hours

Studio EE.1 – Efficiency Management Solutions

An overview of using select Excel features in typical job / project scenarios

Identifying and discussing your job / project specific data

Proposing and detailing a Solution and time permitting, begin the work

Follow with: Additional targeted Excel Studios as determined

Studio EF.1 – Foundations - Spreadsheet Basics

Creating and Editing Basic Spreadsheets

Studio EF.2 – Foundations - Additional Spreadsheet Features and Formatting

Enhancing a Spreadsheet with Formatting

Studio ES.1 – Linking Workbooks

Creating workbook formulas that link to central office workbooks (like payroll)

Linking worksheets and creating custom forms for reporting

Studio ES.2 – Charting Your Data

Create, modify and customize charts to graphically represent your worksheet data

Enhancing worksheets and charts by adding graphic objects, headers and footers

Studio ES.3 – Advanced Spreadsheet Functions and Analysis Tools One

If statements

Conditional formatting

Using control tables and Lookups and Data Validation Techniques

Select Date and Text functions

Studio ES.4 – Advanced Spreadsheet Functions and Analysis Tools Two

Creating Scenarios, Using Solver and Goal Seeking

Calculating Histograms and Moving Averages

Studio ED.1 – Exporting Data from DHCP

Querying DHCP for specific data

Exporting / saving to and cleaning data in Excel

Follow with: ED4 Organizing Your Data

Studio ED.2 – Creating Hospital Surveys

A specific application of working with an Excel form, list and pivot tables

Create and protect survey data entry forms

Using the Forms Design Palette

Create a command macro to submit survey to a database

Follow with: ED4 Organizing Your Data

Studio ED.3 – Creating Custom Forms in Outlook to collect data for analysis in Excel

Additional Pre-requisite: Introduction to Outlook.

A specific application of working with an Excel list and pivot tables.

Creating a custom Outlook form for data entry.

Saving the custom form either for your use or for use hospital wide.

Exporting data from Outlook to an Excel format.

Opening the data in Excel.

Applications include: Time cards, incident reports, purchase orders, CPT procedures performed, surveys, expense reporting, etc.

Follow with: ED4 Organizing Your Data.

Studio ED.4 – Organizing and Analyzing Your Data

Making the transition from worksheets to list management (database).

Importing data from a text file (optional).

Working with a list.

Using Pivot table reports to statistically analyze your data.

Access ™Studios

Overview

1 Efficiency Management Studio

2 Foundational Studios

3 Design Studios

5 Queries and Reports Studios

Target Audience – Database Designers / Developers

Pre-requisite - 2 Foundational Access Studios

Delivery - Instructor-led, job / project specific with optional student provided data/documents.

Duration: 2 Hours

Studio AE.1 – Efficiency Management Solutions

An overview of using Access in typical job / project scenarios to store and access data

Identifying and discussing your job / project specific data

Proposing and detailing a Solution and time permitting, begin the work

Follow with: Additional targeted Access Studios as determined

Studio AF.1 – Foundations - Database Basics, Table and Forms

Database Terminology

Creating, Editing and Entering Data in Tables and Forms

Studio AF.2 – Foundations - Asking Questions of the Data

Creating and Running Queries and Reports

Studio AD.1 – Principles of Table Design, Relationships and Advanced Table Design

Normalizing Data

Analyzing table relationships

Establishing and testing referential integrity

Adding Properties to table fields

Viewing related records in a table

Studio AD.2 – Advanced Form Design

Customizing the Form Design

Performing Calculation on the Form

Adding Combo and List Boxes

Adding other Unbound and Bound Controls including photos and charts

Using Sub forms

Creating a Merge Letter

Studio AD.3 – Maintenance and Sharing

Backing up, Converting, Compacting, Repairing

Using passwords and sharing a database

Studio EQR.1 – Advanced Query Techniques One

Creating Multi-table queries

Calculating numbers and text using expressions

Using typical functions

AND and OR Criteria

Using Wildcards

Parameter Queries

Using Totals to count, sum and average

Studio AQR.2 – Advanced Query Techniques Two – Data Management

Getting External Data to make a Table or append a table

Sending tables and queries to Excel

Using Action Queries including Make Table, Append, Update and Delete

Studio AQR.3 – Advanced Reporting

Creating Grouped Reports and Sub-Reports

Creating a Cover Sheet, Controlling White Space and Page Breaks

Working in Design View

Creating a Mailing Labels Report

Using Cross Tab Query Reports and Pivot Table Reports for statistical analysis

Studio AW.3 – Creating Web Pages

Creating static and dynamic data access pages to share information over intranet or the web

PowerPoint ™Studios

Overview

2 Foundational Studios

4 Design Studios

2 Presentation Studios

1 Web Studio

Target Audience – Designers and Presenters

Pre-requisite – 2 Foundational PowerPoint Studios

Delivery - Instructor-led, job / project specific with optional student provided graphics/data/documents.

Duration: 2 Hours

Studio PF.1 – Foundations - PowerPoint Basics

AutoContent Wizard

Working with Views and Navigating

Creating and Editing Slides

Using Clip Art and Applying a Design Template

Running the Slide Show

Studio PF.2 – Foundations - Enhancing a Presentation

Using the Drawing Tools

MS Graph and WordArt

Working with the Master Slide

Slides Transitions, Slide Timings and Animations

Studio PD.1 – Linking

Linking to Excel and / or Word documents, spreadsheets and charts

Hyper linking to slides, documents, and web pages

Creating custom shows (branching) within the same presentation

Create an Agenda Slide and Summary Slide

Studio PD.2 – Specialized Features

Indents and tabs

Find and Replace

Creating Slides from a Word Outline

Exporting Slides to Word

Inserting Slides from another Presentation

Using Spell Check, AutoCorrect and Style Checker

Studio PD.3 – Creating and Using Custom Templates

Working with Master Slides and Slide Color Schemes

Creating Design Templates without content

Creating AutoContent Templates

Distributing Templates

Using Templates

Studio PD.4 – Multimedia

Working with Clip Art, Photographs, Graphic Files

Working with Movies and Sounds

Custom object animation

Studio PP.1 – Sending and Transporting a Presentation

35 mm slide format

Emailing slides or a whole presentation

The PowerPoint Viewer Application and when to use it

Issues related to Fonts and Images

Packing a presentation for use on another computer

Studio PP.2 – Presentation Tips

Using Pre-set Slide Timings

Navigation and slide show controls using your mouse and keyboard.

Annotating slides with comments.

Creating a list of action actions (to do items), who will do them and due date

Creating meeting minutes as you go

Sending action items and meeting minutes to participants

Studio PW.1 – Web Based Presentations

Saving as Web Page

Uploading HTML and images to your server

Creating the URL that launches your presentation

Collaborating on the Web using Microsoft NetMeeting (requires IRM installation of NetMeeting)

Software and setup required to schedule an on-line web broadcast

Outlook ™Studios

Overview

1 Efficiency Management Studio

2 Foundational Studios

2 Specialized Features Studios

2 Design Studios

Target Audience – Support Personnel, Managers and those that want more than the basics.

Pre-requisite – OF.1 Email Basics

Delivery - Instructor-led, job / project specific.

Duration: 2 Hours

Studio OE.1 – Efficiency Management Solutions for Managers and Workgroup leaders

An overview of using Outlook in typical job / project scenarios to store and access data

Identifying and discussing your job / project specific data

Proposing and detailing a Solution or training path and time permitting, begin the work

Follow with: Additional targeted Outlook Studios as determined

Studio OF.1 – Foundations - Email Basics

The Outlook Window and Email

Studio OF.2 – Foundations - Additional Outlook Features

Using Calendar, Tasks, Journal and Notes

Studio OS.1 – Outlook Specialized and Advanced User Features One

Working with the Outlook Window including Folder Management

Customizing Menus and Toolbars

Outlook User Options / Preferences

Email Sending Options

Inserting Items

Using Signatures

Out of Office Assistance

Studio OS.2 – Outlook Specialized and Advanced User Features Two

Finding

Creating Rules to Organize Incoming Mail

Archiving and Importing an Archive

Working with Contacts and Creating Distribution Lists

Mail Merge

Assigning and Tracking Tasks

Studio OD.1 – Customizing Views and Creating Forms in Outlook

Customizing Current Views

Creating New Fields

Creating New Forms to store data

Publishing Forms

Gathering Data

Exporting data to Excel for Analysis

Studio OD.2 – Sharing Outlook with Others

Creating, Editing and Sharing Work Calendars and Task Schedules stored in your Outlook

Sharing your Email and Calendar with others

Word ™Studios

Overview

2 Efficiency Management Studios

2 Foundations Studios

2 Letters Studios

2 Table Studios

3 Style and Templates Studios

2 Graphic Studios

5 Long Document Studios

1 Forms Studio

1 Macro Studio

Target Audience – All Users

Pre-requisites – Foundational Word Studios

Delivery - Instructor-led, job / project specific with student provided data/documents.

Duration: 2 Hours

Studio WE.1 – Efficiency Management Solutions for Short Documents

An overview of using select Word features in short documents such as: letters, tables, simple documents

Identifying and discussing your job / project specific data

Proposing and detailing a Solution and time permitting, begin the work

Follow with: Additional targeted Word Studios as determined

Studio WE.2 – Efficiency Management Solutions for Long Documents

An overview of using select Word features for long documents such as: manuals, reports, etc.

Identifying and discussing your job / project specific final output needs

Proposing and detailing a Solution and time permitting, begin the work

Follow with: Additional targeted Word Studios as determined

Studio WF.1 – Foundations - Generating Simple Letters

Creating and Editing Letters

Formatting Text Efficiently

Using Tabs - when to use them and when not to use them

Streamlining with AutoText and AutoCorrect

Studio WF.2 – Foundations - Generating Tables

Laying Out a Table on a Vertical Sheet

Laying Out a Table on a Horizontal Sheet

Formatting a Table

Ease of Drag-and-Drop

Studio WL.1 – Streamlining Your Letters with Mail Merge

Adapting Your Letters into a Merge

Merging Data

Managing Merge Updates and Edits

Printing Letters and Envelopes

Studio WL.2 – Streamlining Your Letters with Advanced Mail Merge

Preparing and Using Data from another source such as Excel

Advanced Merge Features

Finding Certain Records for Printing

Studio WT.1 – Effectively Formatting Tables

Formatting Table Properties

Split Table

Formatting with Tables and Borders Toolbar

Formatting with Borders and Shading

AutoFit and Distributing Rows and Columns

Merging and Splitting Cells

Studio WT.2 – Advanced Table Features

Using Split Screen

Repeating Header Row

Overcoming Difficult Formatting – Columns to the right, end of row mark, etc.

Advanced Table Formatting – Vertical Text, AutoFormat, Merge Cells

Sorting within the Table

Converting Text to Table and Table to Text for greater manageability

Studio WST.1 – Styles

Establishing Repetitive Formatting as a Character Style

Establishing Repetitive Formatting as a Paragraph Style

Redefining and Deleting Styles

Using Styles to Create an Outline

Studio WST.2 – Advanced Styles

Using the AutoFormat feature

Repeating Styles

Linking Styles

Managing Styles with the Organizer

Modifying Styles for Printing in Outline and Page Layout Views

Studio WST.3 – Creating Your Templates

Turning Your Document into a Template

Creating a Custom Template of Your Choice

Modifying the Template

Retrieving and Using Your Template

Customizing the Normal Template to Your Specifications

Studio WG.1 – Using Graphic Effects in Word

Using Symbols

Using WordArt

Drawing in a Document

Dealing with Inline Graphics and Separate Page Graphics

Working with Clip Art and Graphic Effects

Multiple Selecting, Moving, and Editing Graphics

Using Text Boxes and Text Wrap

Studio WG.2 – Newspaper Columns in Word

Formatting Text into Newspaper Columns

Column Control

Editing and Reformatting Multiple Columns

Adding Graphics on the Page

Studio WLD.1 - Producing Your Long Documents

Analyzing Your Document Layout

Managing Sections to Control Layout

Managing Headers and Footers with Previous Command

Organizing and Managing Page Numbering

Studio WLD.2 - Producing Your Long Documents

Creating and Assigning Styles within Your Long Document

Applying and Cleaning Up Your Layout

Generating the Outline

Generating the Table of Contents

Incorporating and Controlling Headers and Footers

Using Mixed Margins

Printing Sections of Your Long Document

Studio WLD.3 - Producing Your Long Documents

Using Bookmarks

Generating a Custom Index

Using Captions

Generating a Table of Figures

Inserting and Managing Footnotes or Endnotes

Using Hidden Text

Revisions and Markings

Tracking Changes

Using AutoSummarize for Summaries and Key Points

Studio WLD.4 - Producing Your Long Documents

Setting Up the Master Document

Working with the Master Document

Working with Subdocuments

Formatting the Master Document and Subdocuments

Protecting shared master documents from unauthorized access

Creating Cross-References

Saving the Master Document

Studio WLD.5 - Producing Your Long Documents

Final Compilation of Your Document from Cover to Cover

Final Detailing and Formatting

Printing an Unformatted Draft

Final Pagination and Printing

Studio WF.1 – Forms

Creating a Form from Scratch or Your Existing Document

Adding Form Fields

Adding Combo and List Boxes

Displaying Field Codes

Locking Your Form and Making It a Template

Printing Your Form

Printing Data Only

Studio WM.1 – Record Macros

Creating and Assigning Record Macros

Editing and Testing Record Macros

Deleting a Record Macro

Creating Custom Record Macros for Your Document

FrontPage ™Studios

Overview

2 Foundational Studios

3 Design Studios

1 Specialized Features Studios

Target Audience – Designers

Pre-requisite – Basic Computer Skills

Delivery - Instructor-led, job / project specific with optional student provided graphics/data/documents.

Duration: 2 Hours

Studio FF.1 – Foundations – The Basics

Working with Views and Navigating

Creating a New FrontPage Web (Site)

Applying a Theme and adding Navigational Bars

Working with Text and Tables

Studio FF.2 – Foundations - Enhancing your Web Site

Working with Pictures and Hyperlinks

Using an animation effect and page transitions

Creating a Scrolling Marquee

Creating a Hit Counter and Search Form

Manage Files and Folders and Spell Check

Final Case Study

Studio FD.1 – Basic Design

Intermediate Table Techniques

Customizing Individual Web Pages

Working with Shared Borders, Page Banners and Navigation Bars

Studio FD.2 – Forms Design

Creating Web Forms Including a Search Form, Feedback Form and Custom Form.

Working with Form Properties

Using the Form Page Wizard

Create a Hover Button

Studio FD.3 – Database Design and Publishing a Web Site

Importing an Access Database into FrontPage

Create a database query in a FrontPage web

Save a form in an Access Database

Add a data access page

Publish a Completed Web Site to a Server

Web Permissions

Studio FS.1 – Specialized Features

Working with Tasks

Using Templates and Wizards

Importing elements from another web site

Link to Word Documents

Importing Web Pages

Including Microsoft Office components

Modify HTML tags

Using File Check-out / Check-in feature