|
|
Software Training Courses
Select a course header for more information
More Information Coming Soon!
More Information Coming Soon!
More Information Coming Soon!
More Information Coming Soon!
More Information Coming Soon!
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
|
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
|
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
|
Basic Course and Intermediate Course Reference Manual
Step-by-Step, Full-Color Graphics!
Get started using Microsoft Office Excel 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 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
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
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: 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.
Venues:
|
Location Coming Soon!
Cedar Rapids, Iowa
Dates Coming Soon!
|
|
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!
|
|
Location Coming Soon!
Sioux City, Iowa
Dates Coming Soon!
|
|
Basic Course and Intermediate Course Reference Manual
Step-by-Step, Full-Color Graphics!
Start using Outlook 2010 right away--the QuickSteps way. Color screenshots and clear
instructions make it easy to ramp up the latest release of Microsoft's powerful
communications application. Follow along and quickly learn how to send, receive,
and manage e-mail; enter contacts; schedule appointments; track tasks; keep a journal;
use notes; manage files and folders; and set up instant messaging. Get up to speed
on Outlook 2010 in no time with help from this practical, fast-paced guide.
Use these handy guideposts:
- 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
Advanced Course Reference Manual
Experience learning made easy-and quickly teach yourself how to manage your communications
with Outlook 2010. With STEP BY STEP, you set the pace-building and practicing the
skills you need, just when you need them! Topics include managing e-mail messages;
organizing your inbox, contacts, and task lists; managing and sharing your calendar;
scheduling meetings and using collaboration features; working away from the office;
customizing Outlook; and more.
Venues:
|
Location Coming Soon!
Cedar Rapids, Iowa
Dates Coming Soon!
|
|
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!
|
|
Location Coming Soon!
Sioux City, Iowa
Dates Coming Soon!
|
|
PowerPoint Basic
- Getting Started with PowerPoint
- The New PowerPoint Ribbon
- The New Office Button
- The New Quick Access Toolbar
- Normal Slide View
- Zoom Tools
- Navigating a Slideshow
- Getting Help
- Creating a Presentation
- Inserting Slides
- Choosing a Slide Layout
- Arranging Slides
- Deleting Slides
- Saving a Presentation
- Entering Content
- Using Placeholders
- Using the Clipboard
- Spell Check & Thesaurus
- Find & Replace Text
- Formatting Text
- Applying Character Formats
- Applying Paragraph Formats
- Formatting Placeholders
- Formatting Slides
- Page Setup & Slide Orientation
- Presentation Themes
- Color Themes
- Font Themes
- Background Styles
- Inserting Artwork
- Inserting Clip Art and Pictures
- Drawing Shapes
- Inserting WordArt
- Introducing SmartArt
- Formatting Artwork
- Resizing Artwork
- Rotating Artwork
- Croping Artwork
- Editing Artwork
- Using Styles
- Changing the Shape
- Adding Borders
- Adding Special Effects
- Grouping and Ungrouping Objects
- Arranging Objects
- Animating Your Presentation
- Adding Slide Transitions
- Adding Placeholder Animations
- Slide Sorter View
- Preparing to Deliver a Presentation
- Previewing Your Presentation
- Creating Speaker Notes
- Printing Notes Pages
- Printing Handouts
|
PowerPoint Advanced
- Adding Tables to a Presentation
- Creating a Table
- Formatting Tables
- Inserting a Microsoft Excel Worksheet
- Inserting Charts into a Presentation
- Creating a Chart
- Editing Chart Data
- Formatting a Chart
- Pasteing a Chart from Microsoft Excel
- Adding Multimedia to Presentations
- Inserting Movies
- Playing Music
- Customizing the PowerPoint Environment
- Customizing the Quick Access Toolbar
- Personalizing the PowerPoint Interface
- Customizing How Documents Are Saved
- Adusting Advanced PowerPoint Options
- Customizing a Design Template
- Setting Up a Slide Master
- Customizing Slide Layouts
- Creating Custom Themes
- Adding Headers and Footers
- Modifying the Notes Master
- Modifying the Handout Master
- Customizing a Slide Show Presentation
- Setting Up a Custom Show
- Annotating a Presentation
- Creating a Presenter-Independent Slide Show
- Setting Up a Slide Show to Repeat Automatically
- Collaborating on a Presentation
- Reviewing a Presentation
- Publishing Slides to a Slide Library
- Shareing a Presentation
- Securing and Distributing a Presentation
- Securing Presentations
- Packaging a Presentation
- Publishing a Presentation as a Web Page
|
Basic Course Reference Manual
Step-by-Step, Full-Color Graphics!
Create great-looking presentation slides right away using Microsoft Office PowerPoint
. Color screenshots and clear instructions show you how to use the new and improved
capabilities featured in this powerful presentation program. Follow along and learn
to work with the new Office interface and ribbon, create slides, and add text, tables,
charts, graphics, sound, and video. Plus, it's easy to flip straight to the information
you need using the color-coded tabs, detailed index, and chapter "How to" lists.
Get the book that gets you started using PowerPoint 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
Advanced Course Reference Manual
Experience learning made easy-and quickly teach yourself how to create dynamic presentations
with PowerPoint. With STEP BY STEP, you set the pace-building and practicing the
skills you need, just when you need them! Topics include creating great-looking
slides using templates or your own designs; creating sophisticated charts and diagrams;
using animation, sound, and other special effects; creating presentations simultaneously
with others over the Web; delivering presentations; and other core topics.
Venues:
|
Location Coming Soon!
Cedar Rapids, Iowa
Dates Coming Soon!
|
|
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!
|
|
Location Coming Soon!
Sioux City, Iowa
Dates Coming Soon!
|
|
Publisher Basic
- Getting Started with Publisher
- Creating a Tri-fold Brochure
- Publisher Toolbars
- Publisher Task Pane
- Boundaries and Layout Guides
- Using Rulers
- Inserting Pages
- Zoom Tools
- Getting Help
- Entering & Editing Layout
- Creating Placeholders
- Connecting Text Boxes
- Cut, Copy, Paste
- Undo & Re-do
- Spell Check
- Find & Replace
- Formatting Layout
- Font Selection Guidelines
- Font Size & Font Color
- Bold, Italic, Underline
- Text Alignment
- Line Spacing& Indentation
- Bullets & Numbering
- Styles, Color Schemes & Font Schemes
- Backgrounds
- Design Elements
- Insert Pictures & Clip Art
- Drawing Objects
- Inserting Word Art
- Resizing & Cropping Elements
- Rotating an Element
- Wrapping Text Around an Element
- Layering Elements
- Placing a Border Around an Element
- Editing an Element
- Publishing Your Publication
- Saving Your Work
- Print Preview
- Printing Your Publication
- Saving as a PDF
- Sending to a Commercial Printer
- Working with Templates
- Creating Award Certificates
- Creating Business Cards
- Creating Calendars
- Creating Gift Certificates
- Creating Greeting Cards
- Creating Letterhead
|
Publisher Advanced
- Getting Professional with Publisher
- Creating a Newsletter
- Selecting a Newsletter Template
- Creating & Editing Styles
- Creating & Editing Font Schemes
- Creating & Editing Color Schemes
- Saving as a New Publisher Template
- Master Pages
- Viewing Master Pages
- Selecting Items for the Master Page
- Headers and Footers
- Inserting Page Numbers
- Inserting Date & Time
- Publisher Tables
- Creating a Publisher Table
- Selecting a Table Format
- Inserting & Deleting Rows & Columns
- Merging & Spliting Cells
- Formatting Tables
- Inserting an Excel Worksheet
- Charts & Graphs
- Insert a Microsoft Graph Chart Object
- Edit Chart Information
- Format Graph
- Insert an Excel Graph
- Mail Merge
- Create an Address Book in Excel
- Connect to the Address Book
- Using Merge Fields
- Preview the Merged Recipients
- Print a Merged Publication
- Creating a Website
- Selecting a Website Template
- Choosing a Color Scheme
- Choosing Navigation Options
- Selecting Website Pages
- Working With Hyperlinks
- Navigation Bar Properties
- Creating Hyperlinks
- Editing Hyperlinks
- Publishing a Website
- Web Page Preview
- Saving as a Website
- Using FTP in Publisher
- Viewing Your Site in a Browser
|
Basic Course Reference Manual
This Microsoft Office Illustrated Series book covers the essential information that
you need to know now for Microsoft Publisher. Our signature two-page spread design
has been updated and refreshed to take full advantage of the new features of the
Office software. This practical, easy to navigate book provides you with the essential
knowledge you need to succeed at both work and beyond.
About the Author: Elizabeth Eisner Reding has authored many books for Course
Technology on a variety of software programs, including Adobe Photoshop, Microsoft
Office, and Microsoft Publisher. Living in New Mexico with her husband, she spends
her free time designing and creating stained-glass decorative pieces, water gardening,
mountain biking, and collecting Southwestern art.
Advanced Course Reference Manual
The smart way to learn Microsoft Office Publisher-one step at a time! Work at your
own pace through the easy numbered steps, practice files on CD, helpful hints, and
troubleshooting tips to master the fundamentals of communicating your message effectively
with the latest version of Office Publisher.
You'll learn how to create professional-looking marketing and business materials,
such as cards, flyers, and newsletters, by working with layout and design tools.
You'll even learn how to export publications to PDF format for easy distribution
and how to publish presentations to the Web.
With STEP BY STEP, you can take just the lessons you need or work from cover to
cover. Either way, you drive the instruction, building and practicing the skills
you need, just when you need them! Includes an easy-search companion CD with hands-on
practice files, a complete eBook, a bonus quick reference to the new user interface,
and more!
Key Book Benfits:
- Includes coverage of the fundamentals for designing effective business and marketing
communications
- Features easy-to-follow lessons and hands-on skill-building exercises
- Includes an easy-search companion CD with practice files, a complete eBook, and
other resources
Venues:
|
Location Coming Soon!
Cedar Rapids, Iowa
Dates Coming Soon!
|
|
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!
|
|
Location Coming Soon!
Sioux City, Iowa
Dates Coming Soon!
|
|
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
|
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
|
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
|
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 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.
Advanced Course Reference Manual
Experience learning made easy-and quickly teach yourself how to create impressive
documents with Word. With STEP BY STEP, you set the pace-building and practicing
the skills you need, just when you need them! Topics include using styles and themes;
sharing, printing, and publishing documents; editing images from within Word; using
SmartArt® diagrams and charts; creating references, footnotes, indexes, and tables
of contents; collaborating with multiple people at the same time on the same document;
and turning your ideas into blogs, Web pages, and more.
Venues:
|
Location Coming Soon!
Cedar Rapids, Iowa
Dates Coming Soon!
|
|
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!
|
|
Location Coming Soon!
Sioux City, Iowa
Dates Coming Soon!
|
|
More Information Coming Soon!
QuickBooks Basic:
- Course Introduction
- Basic Accounting Principles
- Cash vs. Accrual Accounting
- Navigating QuickBooks
- Getting Help
- Chart of Accounts
- Introducing QuickBooks Lists
- Accounts & Sub Accounts
- Inactivating & Activating Accounts
- Accounts Receivable
- Customer Center
- Inventory & Service Items
- Sales Receipts
- Memorizing Sales Receipts
- Invoicing
- Memorizing Invoices
- Statements & Finance Charges
- Credit Memos & Refunds
- Receiving Payments
- Making Deposits
- Accounts Payable
- Vendor Center
- Purchase Orders
- Receiving Items
- Entering Bills
- Credit Memos & Discounts
- Paying Bills
- Adjusting Inventory
- Banking
- Check Register
- Handwritting vs. Printing Checks
- Memorizing Checks
- NSF & Bounced Checks
- Voiding vs. Deleting Checks
- Petty Cash
- Account Reconciliation
- Locate Discrepancies
- Online Banking
- Standard Reports
- Finding Transactions
- Budgeting
- Profit & Loss
- Balance Sheet
- Protecting Your Finances
- Password Protection
- Back-up & Restore
|
|
QuickBooks Advanced:
- Personalization:
- Customizing QuickBooks
- QuickBooks Preferences
- Users & Security
- Custom Forms
- Custom Letters
- Chart of Accounts
- Inactivating & Activitating Accounts
- Merging Accounts
- Asset & Liability Accounts
- Classes: Funds, Departments, or Locations
- General Journal Entries
- Payroll
- Employee Center
- Payroll Items
- Tracking Time
- Manual Payroll
- Payroll Subscriptions
- Payroll Liabilities
- Accounts Receivable
- Price Levels
- Creating Estimates
- Receiving Down-Payments
- Progress Invoicing
- Set-up Sales Taxes
- Adjust Sales Taxes
- Paying & Reporting Sales Taxes
- Advanced Reporting
- Customizing Reports
- Memorizing Reports
- Using Excel & Word
- Analyzing Financial Data
- Forecasting Cash Flow
- Creating A Business Plan
- Expanding QuickBooks
- Bill Pay Services
- Online Backup Service
- Remote Access
- Shipping Manager
- QuickBooks Customer Manager
- QuickBooks Invoice Manager
- QuickBooks Point-Of-Sale
- QuickBooks Merchant Services
- QuickBooks Remote Access
- QuickBooks Time Tracker
- QuickBooks Web Services
- QuickBooks Marketplace Add-Ons
|
QuickBooks Financial Software has become the preferred accounting software for the
small business market. QuickBooks 2010 On Demand is a task-based reference book,
designed to appeal to the QuickBooks user who wants the answer to questions in a
hurry. The book is highly visual, with screen shots and callouts describing each
step of particular tasks.
Accompanying the task steps are cross-references to related sections of the book,
tips and short cuts, introductory text, and sidebars that expand on more technical
areas of the program. From the starting moments of taking the QuickBooks program
out of the box for the first time, through setup of a company, to beginning and
ongoing tasks, monthly and less frequent periodic tasks, special features unique
to QuickBooks Pro, and aspects of using QuickBooks online, this book provides direction
that is quick to find and easy to understand.
Whether the user is experienced with QuickBooks and just needs a quick answer to
a nagging question, or a novice who doesn't know where to begin, this book provides
a unique and detailed resource that can be kept by the your side for easy reference.
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:
|
Location Coming Soon!
Cedar Rapids, Iowa
Dates Coming Soon!
|
Mason City Chamber of Commerce
25 West State Street
Mason City, Iowa
July 28 - 29
Registrations Now Being Accepted
|
|
Rochester Area
Chamber of Commerce
220 South Broadway, Suite 100
Rochester, Minnesota
Dates Coming Soon!
|
Location Coming Soon!
Sioux City, Iowa
Dates Coming Soon!
|
Need to learn HTML fast? This best-selling reference's visual format and step-by-step,
task-based instructions will have you up and running with HTML in no time. In this
completely updated edition of our best-selling guide to HTML, Web expert and best-selling
author Elizabeth Castro uses crystal-clear instructions and friendly prose to introduce
you to all of today's HTML and XHTML essentials.
You’ll learn how to design, structure, and format your Web site. You'll create and
use images, links, styles, lists, tables, frames, and forms, and you'll add sound
and movies to your site. Finally, you will test and debug your site, and publish
it to the Web. Along the way, you'll find extensive coverage of CSS techniques,
current browsers (Opera, Safari, Firefox), creating pages for the mobile Web, and
more.
Visual QuickStart Guide--the quick and easy way to learn!
- Easy visual approach uses pictures to guide you through HTML and show you what to
do.
- Concise steps and explanations get you up and running in no time.
- Page for page, the best content and value around.
- Companion Web site at offers examples, a lively question-and-answer area, updates,
and more.
About the Author:
Elizabeth Castro has written all five best-selling editions of HTML for the World
Wide Web: Visual QuickStart Guide. She is also author of Perl and CGI for the World
Wide Web: Visual QuickStart Guide and XML for the World Wide Web: Visual QuickStart
Guide—both best-sellers! Liz was the technical editor for Peachpit’s The Macintosh
Bible, Fifth Edition, and she founded Pagina Uno, a publishing house in Barcelona,
Spain.
Venues:
|
Location Coming Soon!
Cedar Rapids, Iowa
Dates Coming Soon!
|
|
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!
|
|
Location Coming Soon!
Sioux City, Iowa
Dates Coming Soon!
|
|
|