3 HOUR HANDS ON SESSIONS

All our Classes Can Be Customized so Participants Get the Most Value from Each Session

As little as 3 hours is all it takes to begin to effectively utilize 2007’s powerful new and expanded features. Become familiar with the new layout, learn how it operates and where the functions are located and grouped. Plus get introduced to the many new capabilities 2007 offers and see how much your productivity can be increased.

Software Savvy provides “hands on” instruction at your office. We come to you! We load exercise files on each computer to use during the class and provide handouts for reference after the class.

Here is an example of the many items covered in a course, this one for Excel 2007:

What’s New in Excel 2007

• Microsoft Office Button
• Tab Bar and Ribbons
• Contextual Ribbon Tabs
• Dialog Box Launcher
• Quick Access Toolbar
• Mini Toolbar
• Help
• More Rows and Columns
• Faster Calculations
• Status Bar
• New View
• Resizable Formula Bar
• Improved Formulas
• Sorting
• Themes and Styles
• Table Enhancements
• Filtering
• Table Auto Expansion
• Structured Referencing
• Rich Conditional Formatting
• New Look for Charts
• Chart Element Pickers
• Shared Charting
• PivotTables
• External Data
• XML-based File Format
• Earlier Version Compatibility
• PDF and XPS Formats

Discover many time saving functions as you learn how to maneuver around Excel. Topics include: how to freeze headings, adjust column widths, create formulas, use AutoSum, save spreadsheets (location), formatting numbers and text, how to change information without retyping, Collect & Paste (using Clipboard), Undo/redo, add and customize worksheets, margins and page orientation, create schedules using Autofill, create charts.

Intermediate topics include more work with formulas, emphasizing multiple operator formulas,  Absolute and Relative Referencing, naming ranges, conditional formatting, Autocalculate, copying information quickly, Autoformat, more work with sheets, create a multi-sheet sales forecast, 3D linking (bringing numbers in from other sheets and totaling them), sorting, filtering, subtotals and more work with charts

Advanced topics include more 3D work (consolidating numbers), protecting spreadsheets, hiding columns and rows, splitting the screen, setting print areas, using comments, pivot tables, IF statements, lookup functions and some logical functions and setting up templates.

Discover many time saving functions as you learn how to maneuver around PowerPoint. Topics include: quick ways to navigate your presentations, the different views, creating new presentations from scratch or using the Wizard, how to add and delete slides, applying and changing background colors and design templates, change bullet styles, use numbered lists, insert clipart and pictures, set up Notes Pages, create Organization charts, introduction to Slide Master and how to use the drawing tools.

Intermediate topics include rearranging and hiding slides, Summary slide, transitions, more detail on Slide Master, headers & footers, color schemes, Word tables, using the tools on the Picture toolbar, WordArt, advanced 3D and shading and animation effects.

Advanced topics include adding clipart to the Gallery, hyperlinks, action buttons, pen notations during a slide show, navigating a slide show, speaker notes, handouts, charts and graphs, importing from Word and Excel, timings, adding movies and sound, merging presentations, saving presentations to CD (called Pack & Go).

Discover many time saving functions as you learn how to maneuver around Outlook. Topics include: meanings of different icons in the Inbox, set importance levels in email, create and send attachments, flag emails for follow-up, flag email as junk mail, set up folders to organize your email, use color to differentiate incoming email, create multiple contacts from same company, forward contact information, schedule recurring meetings, get reminders on upcoming appointments, reschedule appointments easily, set up tasks with and without due dates, update tasks and create notes.

Advanced topics include creating signatures, search for email, print email, sort columns, use color to organize email, filter mail, use junk mail, set up distribution lists, adjust calendar screen layouts, schedule events, customize task view, assign tasks, create and use categories, mail merge, share calendars and plan a meeting.

Discover many time saving functions as you learn how to maneuver around Word. Topics include: open multiple documents simultaneously, easy and fast ways to highlight text, collect and paste (using the Clipboard), save documents (location), set margins and page orientation, formatting, borders and shading, change case, Format Painter, quick ways to space text, Bullets and numbered lists, Spell Check, AutoCorrect, AutoText, Headers and Footers, Preview documents before opening, Non-printing characters, Labels and Envelopes, Tables. 

Intermediate topics include how to use non-printing characters, change the layout of your page, using Drag & Drop, create borders, different forms of indents, special character effects, viewing two documents simultaneously, labels and envelopes, templates, Thesaurus, tabs, symbols, tables, mail merge, using graphics in Word and organizing your documents in folders.

Advanced Word topics include more extensive work on Tables, mail merge, using Styles, columns, add sections to a page, set up forms, bookmarks, footnotes and endnotes, Index and Table of Contents, macros, track changes, more graphics work, and utilizing the Drawing Toolbar and hyperlinks.

The introductory Access class will give the participants a good basic knowledge of Tables, Forms, Queries and Reports. They will set up and use tables, understand data types, set up Primary keys, create relationships, enforce referential integrity, use subdatasheets, create basic forms, find records, create selection queries and an introduction to Reports.

The intermediate Access class goes into more detail with Tables, Forms, Queries and Reports. The will use default values, input masks, data validation, lookup wizards, import and export data from Excel and Word, create a form with a subform, use criteria in queries, create action queries, create more complex reports with option groups and calculations, create and use a switchboard.

Advanced Access includes modifying lookup fields, using cascading updates and deletes, more action queries, summarizing and grouping queries, importing tables from another database, linking tables in another database, action buttons on forms, modifying switchboards, using more calculations on reports, creating a report with a subreport and macros.

Discover many time saving functions as you learn how to maneuver around ACT! contact screen, fast ways to input records, edit drop down lists, enter information into sublayouts, schedule activities and easily reschedule, modify field names to customize ACT! to your business, fast ways to lookup information, sorting contacts, selectively retrieving contacts, attaching files, creating groups, writing letters, mail merge, labels and an introduction to Reports.

Advanced ACT! shows different kinds of lookups, creating subgroups, modify the contact list screen, create your own form letters, set up your preferences, use email in ACT!, customize reports and do database maintenance.

This course starts with opening and modifying publications, then creating new ones, setting up your page layout, drawing new boxes, coloring them, using borders, import from Word, connect text boxes, change margins, use format painter, insert pictures and tables, WordArt, spell check, add new pages, use Design Gallery and border art.

Create publications from previously saved ones, use Master Pages, apply new designs, use styles, edit pictures, crop, use templates inside publications, use continued notices, personal information sets, hyperlinks, import from Word, sort and filter data.

Personalize your QuickBooks screen, navigate between different companies, set up preferences, create and edit accounts and items, enter customers and vendors, enter bills and invoices, write checks, print checks, transfer money between accounts.

Receive payments, make deposits, set up credit cards and enter transactions, reconcile bank accounts, memorized transactions, statements, reports.

We work on specifics with you

We work on specifics with you

All classes are 3 hours in length and can be customized to ensure we meet your particular requirements.

QUICK TIPS & SHORTCUT CLASSES

(45 Minutes Each)

Get those presentations done faster and make them more exciting! Navigate easily through all your slides, easily create new presentations, change bullets and spacing on slides, use numbered lists, create presentations using the Wizard, change designs on slides, quickly insert ClipArt, pictures, sound and movie clips, how to hide slides in a presentation, duplicate slides, quickly add logos or other items to all slides, use transitions and animation effects.

How efficient are you with Outlook? Is your inbox too full? Need organization? Learn what all those different icons mean in your inbox, how to delete multiple emails, ways to identify important emails, label bad emails as Junk mail, organize your email into folders, how to find particular emails and identify email from specific people. And that’s just the email part!
Contacts: Fast way to add contacts and send email to them, forward and receive contact info with no retyping and set up Distribution Lists.
Calendar: Use the Date Navigator, set up recurring meetings, quick ways to change dates and times of meetings.

Word can be used as an electronic typewriter, or it can be an efficient tool where you can get things done fast and efficiently. Which will be it? In this course you will learn different viewing methods, multiple fast ways to add and delete text, how to highlight text efficiently, better ways to move information around, quickly change spacing, multiple ways to indent paragraphs, quickly format multiple pieces of text, spell check individual words, take the frustration out of bullets, setup commonly misspelled words so they correct themselves, setup and use standard paragraphs, adjust documents prior to printing, get to a page fast in a long document.

Learn the fast and easy ways to perform basic functions in Excel. People who are self-taught tend to do things the long way. We can shave off multiple keystrokes and multiple minutes of computing time. Add that up over time and you will be saving significant computing time. You will get your projects done faster and so much more efficiently.  This course details time saving methods for navigating your spreadsheets, input, adjusting columns and rows, copying formulas and text, adjusting spreadsheet size, printing, how to make information stand out, and bringing numbers to other sheets. Very important basic information to enable you to computer faster! Designed for the Intro to Intermediate Excel user who needs to do things quicker!

Now for more advanced functions. Learn important functions you’ll use in every spreadsheet, how to selectively retrieve data, keep other people from changing your formulas, quick ways to create new spreadsheets, moving sheets to other workbooks, creating multi-sheet spreadsheets fast, and bringing forward totals, quick charts, changing charts, jazzing up charts, selectively choosing data for charts. Designed for the Intermediate Excel user.

Immerse yourself in Autosum, Absolute vs Relative referencing, common Statistical Functions, Text Functions, IF Statements, VLookup Function and Financial Functions. Short description, lots of information!