|
|
Upcoming Software Training Events
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 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
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.
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!
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
2007. 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 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
Advanced Course Reference Manual
Like every other application in Microsoft Office suite, PowerPoint is loaded with
features. So many, in fact, that even veterans don't know where to find them all.
Microsoft solved this problem in PowerPoint 2007 by redesigning the user interface
with a tabbed toolbar that makes features easy to locate and use. PowerPoint 2007
also boasts improved graphics, additional templates, the ability to save custom
layouts, and improved collaboration through SharePoint. One thing Microsoft hasn't
improved is its poor documentation. To learn the ins and outs of all the features
in PowerPoint 2007, Microsoft merely offers online help. If you're familiar with
previous versions of the program, you may be lost the first time you fire up the
new PowerPoint; or you would be if it weren't for PowerPoint 2007: The Missing Manual.
This book, written specifically for this version of the software, not only offers
the basics of how to create, save, set up, run, and print a basic bullets-and-background
slideshow, but takes you into the world of multimedia, animation, and interactivity.
You'll learn how to add pictures, sound, video, animated effects, and controls (buttons
and links) to their slides, along with ways to pull text, spreadsheets, and animations
created in other programs. You can also create your own reusable design templates
and learn to automate repetitive tasks with macros. Learn how to take advantage
of advanced functions (such as adding custom background images) that existed in
previous PowerPoint versions, but were so cleverly hidden that few people ever found
them.
This new book, written specifically for PowerPoint 2007, not only offers the basics
of how to create, save, set up, run, and print a basic bullets-and-background slideshow,
but takes readers into the world of multimedia, animation, and interactivity.
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 2007 Illustrated Series book covers the essential information
that you need to know now for Microsoft Publisher 2007. Our signature two-page spread
design has been updated and refreshed to take full advantage of the new features
of the Office 2007 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 2007-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 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.
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.
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!
|
|
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
|
Every company large and small wants to boost sales, control spending, and keep auditors
at the IRS happy. A growing number of these firms are turning to QuickBooks accounting
software to not only speed up their bookkeeping efforts, but manage their businesses
more effectively.
With QuickBooks 2009: The Missing Manual, financial managers will quickly learn
how to use the program's tools to implement and maintain critical accounting processes.
This fully updated guidebook covers everything in a friendly, witty style that will
engage novices and experts alike. Beginners will appreciate the clear guidance on
setting up QuickBooks to simplify their financial management tasks. Experienced
users will learn how to work around the program's idiosyncrasies.
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
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!
|
|
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!
|
|
|