Upcoming Software Training Events

Basic, Intermediate & Advanced Courses

This course series will teach both new and seasoned users how to master Microsoft Excel. Participants will move quickly through entry level skills to cover advanced features.

This course is broken down into three levels: basic, intermediate and advanced. The basic course is intended for users who are new to Excel and want to learn how to start using Excel. The intermediate and advanced courses are for current users of Excel who want to expand their knowledge base and utilize the advanced features of Excel. Please be sure you have a thourough understanding of the basic skills before registering for the intermediate or advanced courses.

Fast Facts
Registration Cost: $  99.95 (One Class) $189.95 (Two Classes)           $269.95 (Three Classes)	Time: 9:00a.m. to 5:00p.m.
	Class Size: Max 12 Students
Registration Includes: Certificate, Lunch & Reference Manual	Computer: One Per Student

Excel Basic Getting To Know Excel Navigating Excel Saving Workbooks Opening Workbooks Using Templates Understanding Workbooks Workbook vs. Worksheet Cell References The Formula Bar Formatting Data Cut, Copy, Paste Font Formats & Alignment Number Formatting Styles Editing Data Spell Check Reference Materials Inserting Rows & Columns Sizing Rows & Columns Deleting Rows & Columns Basic Formulas Sum, Average & Count Min and Max Finding Data Sort & Filter Find & Replace Printing Your Work Print Preview Printer Settings AND MUCH MORE...

Excel Intermediate Illustrations & Text Pictures & Clip Art Shapes & Smart Art Word Art & Text Boxes Advanced Data Entry Filter & Outlining Relative Cell Referencing Absolute Cell Referencing Filling Cells Moving Data Custom Formulas Charts Selecting Data Chart Types Styles & Layouts Page Layout View Themes & Page Setup Headers & Footers Security Protecting Workheets Sharing Workbooks Tracking Changes Customizing Excel Quick Access Toolbar Status Bar Excel Options AND MUCH MORE...

Excel Advanced Data Connections Using External Data Data Tools Advanced Formulas Defined Names Financial, Logical, Text, Date & Time, Math & Trig, and Lookup & Reference Formulas Formula Auditing PivotTables Introducing PivotTables PivotTable Shells Formatting A PivotTable Compound Fields Calculated Fields Custom Names Calculated Names Subtotals & Grand Totals Sorting & Grouping PivotCharts PivotChart Shells Dragging Fields PivotChart Filters Moving PivotCharts Macros Recording Macros Using Macros Assigning Shortcuts AND MUCH MORE...

Basic Course and Intermediate Course Reference Manual

Step-by-Step, Full-Color Graphics!
Get started using Microsoft Office Excel 2007 right away--the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features available in this premier spreadsheet program.

Follow along and learn to work with the new Office interface and ribbon, create workbooks, use Excel's XML file formats, enter and edit data, use formulas and functions, create charts and tables, analyze data, and more. Plus, it's easy to flip straight to the information you need using the color-coded tabs. Get the book that gets you started using Excel 2007 in no time.

In each chapter:

Shortcuts for accomplishing common tasks

Need-to-know facts in concise narrative

Helpful reminders or alternate ways of doing things

Bonus information related to the topic being covered

Errors and pitfalls to avoid

(due to availability issues, actual book may be substituted for one of equal value.)

---

Advanced Course Reference Manual

Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use.

Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do with them. Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions.

Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

About the Author
Matthew MacDonald is an author and programmer extraordinaire. He's the author of Excel: The Missing Manual, Creating Web Sites: The Missing Manual, the forthcoming Access 2007: The Missing Manual, and over a dozen books about programming with the Microsoft .NET Framework.

(due to availability issues, actual book may be substituted for one of equal value.)

Venues: Mason City Chamber of Commerce 25 West State Street Mason City, Iowa November 12, 2008 - Basic November 13, 2008 - Intermediate November 14, 2008 - Advanced Rochester Area Chamber of Commerce 220 South Broadway, Suite 100 Rochester, Minnesota Dates Coming Soon!	Register Today: One-Class:  BasicIntermediate Advanced 2-Classes:  Basic & Intermediate Intermediate & Advanced 3-Classes:  All Clases

Basic, Intermediate & Advanced Courses

This course series will teach both new and seasoned users how to master Microsoft Word. Participants will move quickly through entry level skills to cover advanced features.

This course is broken down into three levels: basic, intermediate and advanced. The basic course is intended for users who are new to Word and want to learn how to start using Word. The intermediate and advanced courses are for current users of Word who want to expand their knowledge base and utilize the advanced features of Word. Please be sure you have a thourough understanding of the basic skills before registering for the intermediate or advanced courses.

Fast Facts
Registration Cost: $  99.95 (One Class) $189.95 (Two Classes)           $269.95 (Three Classes)	Time: 9:00a.m. to 5:00p.m.
	Class Size: Max 12 Students
Registration Includes: Certificate, Lunch & Reference Manual	Computer: One Per Student

Word Basic Getting To Know Word Navigating Word Using the Office Ribbon Opening Documents Saving Documents Using Templates Formatting Text Cut, Copy, Paste Font Formatting Text Alignment Line Spacing Outlining Font Styles Paragraph Markers Editing Text Spell Check Reference Materials Find & Replace Highlighting Text Document Views Types of Views Using the Ruler Window Management Headers & Footers Page Numbering Printing Your Work Print Preview Printer Settings AND MUCH MORE...

Word Intermediate Page Layout Margins & Hyphenation Columns & Tabs Page & Section Breaks Backgrounds Watermarks Borders & Colors Page Themes Illustrations & Text Pictures & Clip Art Shapes & Smart Art Word Art & Text Boxes Symbols, Dates & Times Bookmarks & Hyperlinks Charts Chart Templates Selecting & Editing Data Chart Styles & Layouts Labels & Gridlines Backgrounds Tables Word Tables Excel Spreadsheets Table Design & Layout Send Document E-mail & Fax Documents Save as Web Page Convert to PDF AND MUCH MORE...

Word Advanced Mail Merge Data Sources Merge Fields Custom Letters Envelopes & Labels Document References Table of Contents Footnotes & Captions Citations & Bibliography Document ndex Table of Authorities Security Protecting Documents Sharing Documents Tracking Changes Using Comments Customizing Word Quick Access Toolbar Status Bar Word Options Macros Recording Macros Using Macros Assigning Shortcuts Advanced Features Digital Signatures Document Encryption Compatibility Checker AND MUCH MORE...

Basic Course and Intermediate Course Reference Manual

Learn to use Microsoft Office Word the QuickSteps way!

Since its introduction, the Word user interface has grown to contain more than 250 menu items, 30 toolbars, and 20 task panes. Now the interface has been completely rebuilt in Word 2007 to vastly improve and simplify the user experience. This full-color, step-by-step guide helps you get acclimated quickly to the new interface and take full advantage of the powerful new capabilities.

(due to availability issues, actual book may be substituted for one of equal value.)

---

Advanced Course Reference Manual

Microsoft Word has grown considerably in power, sophistication and capability over the past decade, but one thing that hasn't changed since the early '90s is its user interface. The simple toolbar in version 2.0 has been packed with so many features since then that few users know where to find them all. Consequently, more and more people are looking for "insider" tips that will allow them to use these advanced and often hidden features.

Microsoft has addressed this problem in Word 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even though you will be able to find advanced features, you might not know what to do with them.

Word 2007: The Missing Manual, written specifically for this version of the software, explains basics like how to create documents, enter and edit text, format, print, and fax. You will will also learn how to create sophisticated page layouts, insert forms and tables, use graphics, and create book-length documents with outlines and Master Documents. Coverage also includes how to share documents with other people and programs, create web pages, automate documents with fields, and automate tasks with macros and the Visual Basic scripting language. This book shows you how to do it all.

(due to availability issues, actual book may be substituted for one of equal value.)

Venues: Mason City Chamber of Commerce 25 West State Street Mason City, Iowa January 14, 2009 - Basic January 15, 2009 - Intermediate January 16, 2009 - Advanced Rochester Area Chamber of Commerce 220 South Broadway, Suite 100 Rochester, Minnesota Dates Coming Soon!	Register Today: One-Class:  BasicIntermediate Advanced 2-Classes:  Basic & Intermediate Intermediate & Advanced 3-Classes:  All Clases

This course series will teach both new and seasoned users how to master QuickBooks accounting software. Participants will move quickly through entry level skills to cover advanced features of QuickBooks Pro.

This course is broken down into 2 two-day classes: Basic and Advanced. Advanced students should have a grasp on the Basic course topics before registering for the Advanced class. Please review the Class Schedule before registering.

Fast Facts
Duration: Basic (Two Days) Advanced (Two Days)	Class Size: Max 12 Students	Reference Manual: Optional ($21.95)
Time: 10:00a.m. to 4:00p.m.	Computer: One Per Student	Price: $199.95 Per Class

Basic - Day 1: Navigating QB Customizing QB Back-up Restore Account List Check Register Vendor List Inventory Items Entering Bills Paying Bills

Basic - Day 2: Customer List Service Items Sales Receipts Invoicing Payments Deposits Reconciliation Budgeting Reports

Advanced - Day 1: Company Files Customizing QB Users & Security Classes: Funds,     Departments,     Locations Assets Liabilities Tracking Time Payroll Payroll Liabilities

Advanced - Day 2: Price Levels Estimating Progress Invoicing Sales Tax Custom Forms Custom Letters Custom Reports Analyzing Data

This reference manual was created specifically for this course by our expert Instructors. The manual contains over 600 screen shots with step-by-step instructions for each lesson taught in the course.

Buy Now: 

---

I loved the hands on common sense visual approach to learning QuickBooks. I learned at my own pace and there was no such thing as a "dumb question." I also learned how to customize QuickBooks features to accomodate my own style of bookkeeping needs. Also, if I had one question for the future, I was encouraged to just call.

A great course and well worth attending.

N. O'Brien
Mason City - July 2008

---

This course was designed well. It was very informative on how to operate QuickBooks. I have used QuickBooks for four months and learned many new operations.

Anonymous
Clear Lake - July 2008

---

Very good for extra learning or even brushing up in QuickBooks. Very informational and answered my questions about this program and some of the short cuts which is always helpful.

L. Salz
Clear Lake - July 2008

---

Venues: Mason City Chamber of Commerce 25 West State Street Mason City, Iowa Dates Coming Soon! Rochester Area Chamber of Commerce 220 South Broadway, Suite 100 Rochester, Minnesota Dates Coming Soon!	Register Today: Class:  Basic (Mason City) Advanced (Mason City)Basic (Rochester) Advanced (Rochester)    Reference Manual: