Finally, comprehensive Excel and Word training designed just for you! Get even more from QuickBooks by mastering beginner to advanced Excel & Word skills specifically chosen for small business owners and managers. Includes more than 6 hours of training. Earn 11 hours of CPE credit.

"I learned so much about using Microsoft Excel, Word, and QuickBooks. I can't wait to try some of the tricks I learned" Olga- Fairfax, VA

Excel
The Basics:
What are spreadsheets and workbooks?
Navigate in Excel
Entering/Editing cells
Adding/deleting rows and columns (adjacent and non adjacent)
Get help in Excel
Export tips
Export to new and existing workbooks
Align and move worksheets

Save Time:
Create Macros so Excel automatically completes a number of steps for you
Keyboard and mouse shortcuts
Fill series-tells Excel to complete a list of numbers, days, months etc. automatically
Printing techniques so you don't waste time trying to print sheets the way you want

Formatting:
Create the look you want
Merge and center cells
Add borders
Accounting vs. Currency styles
Format painter
Add tab colors
Add comments
Freeze panes (so column and row headings don't disappear when you scroll through reports)
Understand date formats and why dates sometimes appear as numbers

Real World Applications:
Create an amortization schedule quickly
Create expense reimbursement forms and speed up bank reconciliation
Create your own graphs of QuickBooks data

Summarizing Data:
Calculating mean vs. median
Pivot tables and charts
Group and sort data
Count function (to save you time)

Importing:
Import lists from Excel into QuickBooks
Data mapping
Import IIF files

Security:
Set passwords for workbooks
Protect worksheets
Lock individual cells from editing

Analyze Your Data:
"What If?" analysis
Goal seek

Formulas and Calculations:
Relative vs. absolute references (understand the difference and when to use each!)
Array and 3-D Formulas...and when to use them

Customize Excel:
Create your own toolbar and menu
Move and add toolbar and menu commands

Word
Send Letters from QuickBooks to Word:
Using the QuickBooks to Word link to prepare letters using QuickBooks information
Prepare envelopes for mailings automatically
Convert existing Word form letters into QuickBooks letters
Create invoice cover letters using Word

Work With Document Text:
Entering and formatting text
Cut/copy/paste text
Overtyping text
Selecting text

Format Word Documents:
Numbered lists
Bullet lists
Using tabs, tab stops, and indents
Inserting logos, text boxes, tables, Excel spreadsheets, and hyperlinks
Use clip art, WordArt, watermarks, and AutoShapes
Character and paragraph formatting
Line and paragraph spacing
Highlighting text
Using borders and shading
Margins, page breaks, and page numbers

Manage Documents:
Save, edit, and delete QuickBooks/Word letters
Work with different layout views
Use AutoRecover so you don't lose your work!
Create documents and templates
Printing documents
Password protect documents
Tracking changes made by multiple users

Master Powerful Word Tools:
Spell Checker
Grammar Checker
Use Styles for consistent formatting
Thesaurus
Use built-in templates for businesses
Work with Smart Tags

Customize Word:
Create Word menus and toolbars
Create your own menu and toolbar shortcuts
Enable/disable adaptive menus

Save Time:
Keyboard shortcuts
Find & replace
AutoCorrect

Duration
6 hours

Includes
1 DVD

Optional Recommended CPE
11

Price
Member $149 (Register through our Members Only Internet portal)
Nonmember Price $199

30 Day 100% Money Back Guarantee
If you are not completely satisfied with this learning DVD, return it within 30 days from the shipping date and you will receive a full refund (less the shipping and handling charges).

To order, click the Order button below.