TeachUcomp, Inc.®
FREE Business Software Training Offer
TeachUcomp, Inc. is proud to offer you a training of your choice absolutely FREE. There is no purchase necessary and no credit card required. We're confident that you will be so happy with your training that you will come back to TeachUcomp, Inc. for all of your computer learning needs.
You will receive training in the application of your choice (choose from below), which includes audio/visual lessons, printable instruction manuals and practice exercises!
To take advantage of this special offer, simply complete the form below. It's that easy!
Want to see what's covered in your FREE training?
Click on the links below to view a complete syllabus.
Access | Excel | Crystal Reports | Peachtree | Project | QuickBooks
Train multiple employees for one price. Click here.
Getting
Acquainted with Access
1. The Access Screen
2. Overview of a Database
3. Working with Database Objects
4. Opening and Closing Databases
5. Database Objects
Creating
Relational Database Tables
1. Creating New Databases
2. Flow Overview of a Database
3. The "Flat-File" Model of Data Storage
4. The Relational Model of Data Storage
5. Tips for Creating a Relational Database
6. Creating Relational Database Tables
7. Assigning a Primary Key to a Table
Using
Tables
1. Using Datasheet View
2. Navigating in Datasheet View
3. Adding Records in Database View
4. Editing and Deleting Records in Datasheet View
5. Inserting New Fields
6. Renaming Fields
7. Deleting Fields
Field
Properties
1. Setting Field Properties
2. The 'Field Size' Property
3. The 'Format' Property for Date/Time Fields
4. The 'Format' Property for Logical Fields
5. Setting Default Values for Fields
6. Setting Input Masks
7. Setting Up Validation Rules and Responses
8. Requiring Field Input
9. Allowing Zero Length Entries
Joining
Tables in a Database
1. Using the Relationships Window
2. Enforcing Referential Integrity
3. Creating Lookup Fields
Indexing
Tables
1. Indexes
2. Creating Indexes
3. Designing a Multi-field Primary Key
4. Deleting Indexes
Queries
1. What Does a Query Do?
2. Using the Simple Query Wizard
3. Designing Queries
4. Joining Tables in a Query
5. Adding Criteria to the QBE Grid
6. Running A Query
7. How is Using the QBE Grid Writing SQL Code?
8. Sorting Query Results
9. Hiding Fields in a Query
10. Using Comparison Operators
11. Using 'AND' and 'OR' Conditions
Advanced
Queries
1. Using the 'BETWEEN...AND' Condition
2. Using Wildcard Characters in Criteria
3. Creating a Calculated Field
4. Creating 'Top Value' Queries
5. Function Queries
6. Parameter Queries
Advanced
Query Types
1. Make-Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The 'Find Duplicates' Query
7. The 'Find Unmatched' Query
Get it FREE NOW!
Creating Forms
1. What Are Forms For?
2. The Form Wizard
3. Creating AutoForms
4. Using AutoForms
5. Designing Basic Forms
6. Form and Report Design View
7. Viewing the Ruler and Gridlines
8. The 'Snap to Grid' Feature
9. Creating a Form in Design View
Form
& Report Controls
1. Selecting Controls
2. Deleting Controls
3. Moving and Resizing Controls
4. Sizing Controls 'To Fit'
5. 'Nudging' Controls
6. Aligning, Spacing and Sizing Controls
7. Formatting Controls
8. Viewing Control Properties
The
Control Toolbox
1. The Control Toolbox
2. Adding Label Controls
3. Adding Image Controls
4. Adding Line Controls
5. Adding Rectangle Controls
6. Adding Combo Box Controls
6. Adding List Box Controls
7. Setting Tab Order
Subforms
1. Creating Subforms
2. Displaying Subform Data
Reports
1. Using the Report Wizard
2. Creating AutoReports
3. Creating a Report in Design View
4. Sorting and Grouping Data in Reports
5. Creating Calculated Fields
Subreports
1. Creating Subreports
Charting Data
1. Creating Charts
2. Editing Charts
Macros
1. Creating and Using Macros
2. Macro Actions
3. Assigning Macros to a Command Button
4. Conditional Macros and Option Groups
5. Using Group Names in Macros
6. Creating Autoexec Macros
Switchboard Forms
1. Creating a Switchboard Form
2. Controlling Startup Behavior
Customizing Toolbars
1. Setting Toolbar and Menu Options
2. Creating Custom Toolbars
3. Creating Custom Popup Menus
Advanced Features
1. Linking Tables
2. Importing External Data
3. Setting a Database Password
4. Using the Help Files
The
Crystal Reports Environment
1. Starting Crystal Reports
2. The Menu Bar
3. Using Toolbars
4. The Design View
Creating
Data Connections
1. Creating a New Blank Report
2. The Database Expert
3. Access/Excel (DAO)
4. ACT!
5. Btrieve
6. Database Files
7. Exchange Message Tracking Logs
8. Field Definitions Only
9. File System Data
10. JDBC (JNDI)
11. Legacy Exchange (CR 11)
12. Mailbox Admin
13. Microsoft CRM (CR 10)
14. MS IIS/Proxy Log Files
15. NT Archived Event Log
16. NT Current Event Log
17. ODBC (RDO)
18. OLAP
19. OLE DB (ADO)
20. Outlook
21. Outlook/Exchange (CR 11)
22. Public Folder ACL
23. Public Folder Admin
24. Public Folder Replica
25. Web/IIS Log Files
26. xBase
27. XML
28. Creating Additional Data Connections and Selecting Tables
29. Making a “Favorite” Connection
Creating Basic
Reports
1. Adding Data Fields to a Report
2. Browsing Field Data
3. Selecting, Moving, and Resizing Fields
4. Using the “Size” and “Align” Commands
5. Creating Text Objects
6. Saving a Report
7. Previewing a Report
8. Refreshing the Report Data
Linking Tables
in a Report
1. Basic Table Structures and Terms
2. Linking Multiple Tables
3. Table Joins
4. Enforcing Table Joins and Changing Link Types
Basic Formatting
Techniques
1. Formatting Report Objects
2. The Format Editor
3. Drawing Lines
4. Drawing Boxes
5. Format Painter
6. Formatting Part of a Text Object
7. The Template Expert
8. Inserting Pictures
Record Selection
1. The Select Expert
2. Setting Multiple Filters
3. Editing the Selection Formula
Sorting and
Grouping Records
1. The Record Sort Expert
2. The Group Expert
3. Managing Groups
4. Summarizing Groups
5. Hierarchical Groupings
6. The Group Sort Expert
Printing Reports
1. Inserting Special Fields
2. Page Setup
3. Print Setup (CR 10)
4. Printing Reports
Get it FREE NOW!
Using
Formulas
1. Crystal Reports Formula Syntax
2. The Formula Workshop- Formula Editor Window
3. Creating Formula Fields
4. Crystal Syntax
5. Basic Syntax
6. Finding Function and Operator Assistance
Advanced Formatting
1. The Highlighting Expert
2. The Section Expert
3. Conditionally Formatting a Section
4. Conditionally Formatting a Field
5. Manipulating Multiple Sections
Summary Reports
1. Summarizing Report Data
2. Using the DrillDownGroupLevel Feature
Charting
1. The Chart Expert
2. Editing Charts
3. Setting General Chart Options
4. Changing Chart Titles (CR 10)
5. Formatting Selected Chart Items
6. Formatting a Data Series
7. Formatting a Chart Grid
8. Setting Chart Axes Options (CR 11)
9 . Adding Chart Trendlines
10 . Modifying a 3D Chart View
11. Using Chart Templates
12. Auto-Arranging Charts
Advanced Reporting
Tools
1. Using Running Totals
2. Creating Parameter Fields
3. Parameterized Record Selection
4. Entering Parameter Values
5. Creating Subreports
6. Creating Cross-Tab Reports
7. Report Alerts
8. Report Alert Functions
Advanced Formula
Creation
1. Evaluation Time Functions
2. Declaring Variables
3. Using and Displaying Variables
4. Using Array Values
5. Using “If… Then… Else…” Statements
6. Using the “Select/Case” Statement
7. Using “For” Loops
8. Using “Do… While” Loops
9. The IIF Function
Advanced Reporting
1. Creating a Report Template
2. Exporting Report Results
3. Exporting as HTML
4. Setting Default Options
5. Setting Report Options
Using Report
Wizards
1. Using the Report Wizards
2. Report Wizard Types
Advanced Database
Concepts
1. Viewing the SQL Code
2. Creating SQL Commands
3. Creating SQL Expression Fields
4. Using Table Aliases
5. Verifying the Database
6. Setting the Datasource Location
7. Mapping Fields
Getting
Acquainted with Excel
1. The Excel Environment
2. The Title Bar
3. The Menu Bar
4. The Standard Toolbar
5. The Formatting Toolbar
6. The Ribbon
7. The Microsoft Office Button
8. The Quick Access Toolbar
9. Scroll Bars
10. The Formula Bar
11. The Workbook Window
12. The Status Bar
13. The Task Pane
14. The Mini Toolbar
Creating
Basic Spreadsheets
1. Creating a New Workbook
2. Saving Workbooks
3. Closing Workbooks
4. Opening Workbooks
5. Selecting Cells
6. Entering Text Into Cells
7. Entering Numbers Into Cells
8. AutoComplete
9. Pick From List
10. Using the "Window" Command Group
11. Zooming the Spreadsheet
12. Managing Multiple Workbooks
13. Renaming Workbooks
14. Working with Excel File Formats
Using
Ranges
1. Using Ranges
2. Selecting Ranges
3. Selecting Multiple Non-Adjacent Ranges
4. Entering Information Into a Range
5. Using AutoFill
Creating
Formulas
1. Using Formulas
2. Formula Functions
3. Using AutoSum
4. Inserting Functions
5. Editing a Range
6. Using the Formula Palette
7. Using the Paste Function
8. Editing a Range
9. Formula AutoCorrect
10. AutoCalculate
Copying
& Pasting Formulas
1. Absolute References and Relative References
2. Cutting, Copying & Pasting
3. AutoFilling Cells
4. Drag & Drop Cutting, Copying & Pasting
5. Using Undo
6. Using Redo
Columns
& Rows
1. Selecting Columns & Rows
2. Changing Column Width & Row Height
3. AutoFitting Columns & Rows
4. Hiding/Unhiding Columns & Rows
5. Inserting & Deleting Columns & Rows
Formatting
Spreadsheets
1. Using the Formatting Toolbar
2. Using the Format Cells Dialog Box
3. The Number Tab
4. The Alignment Tab
5. The Font Tab
6. The Border Tab
7. The Patterns Tab
8. Clearing All Formatting from Cells
9. Copying All Formatting from Cells to Another Area
Conditional
Formatting & AutoFormatting
1. Conditional Formatting
2. AutoFormatting
Setting
Spreadsheet Layout
1. Working with Page Breaks
2. Viewing the Header and Footer
3. The Page Setup Dialog Box
Printing
Spreadsheets
1. Using Print Preview View
2. Printing Your Spreadsheet
Helping
Yourself
1. Using Screen Tips
2. Using the Office Assistant
3. Using the Help Pane
Creating
3D Formulas
1. Creating 3D Formulas
2. 3D Formula Syntax
3. Creating 3D Range References
Named
Ranges
1. Naming Ranges
2. Moving to a Named Range
3. Using Named Ranges in Formulas
4. Creating Names from Headings
5. Deleting Range Names
Spreadsheet
Tools
1. Moving between Spreadsheets
2. Selecting Multiple Spreadsheets
3. Inserting and Deleting Spreadsheets
4. Renaming Spreadsheets
5. Coloring Spreadsheet Tabs
6. Switching to Full Screen View
7. Splitting the Screen
8. Freezing Panes
9. Copying and Moving Entire Worksheets
10. Cutting, Copying and Pasting Data between Spreadsheets
11. Printing Multiple Spreadsheets
12. Hiding Spreadsheets
Using
Workspaces
1. Creating Workspaces
2. Opening and Closing Workspaces
3. Selecting Workbooks in a Workspace
4. Organizing a Workspace
Paste
Special
1. Paste Special Options
2. Pasting Linked Formulas
Sharing
and Reviewing Workbooks
1. Sharing Workbooks
2. Highlighting Changes
3. Reviewing Changes
4. The Reviewing Toolbar
5. Inserting Comments
6. Managing Comments
7. Reviewing Comments
8. Printing Comments
9. Sending Spreadsheets for Review
10. Compare and Merge Workbooks
Get it FREE NOW!
Auditing
Spreadsheets
1. Auditing Spreadsheets
2. The Formula Auditing Toolbar
3. Tracing Precedent and Dependent Cells
4. Tracing Errors
5. Error Checking
6. Using the Watch Window
7. Cell Validation
Outlining
Spreadsheets
1. Using Outlines
2. Applying and Removing Outlines
Consolidating
Spreadsheets
1. Using Data Consolidation
2. Consolidation Types
Creating
Spreadsheet Charts
1. Creating Charts
2. Moving and Resizing Charts
3. The Chart Toolbar
4. Formatting Chart Objects
5. Changing the Chart Type
6. Showing and Hiding the Legend
7. Showing and Hiding the Data Table
8. Shifting the Data Series
9. Angling Chart Text
10. Choosing a Chart Layout
11. Choosing a Chart Style
12. Printing Charts
13. Deleting Charts
Editing
and Formatting Charts
1. Changing Chart Sub-types
2. Changing the Data Range
3. Changing Chart Titles
4. Repositioning the Legend
5. Adding Data Labels
6. Adding Free-standing Text
7. Time-Scale Data Plotting
8. Formatting a Data Series
9. Changing the Data Series Plot Order
10. Chart Axis Formatting
11. Formatting Data Markers
12. Adjusting Perspective in 3D Charts
13. Custom Chart Types
PivotTables
1. Creating PivotTables
2. Manipulating a PivotTable
3. Using the PivotTable Toolbar
4. Changing Data Field Properties
5. AutoFormatting PivotTables
6. Displaying a PivotChart
7. Setting PivotTable Options
8. Page Display Options
9. Adding Subtotals to PivotTables
10. Sorting and Filtering Fields
Lists
1. Creating a List
2. Adding and Editing Records
3. Inserting Records and Fields
4. Deleting Records and Fields
The
Data Form
1. Using the Data Form
2. Adding and Deleting Records in the Data Form
3. Finding Records in the Data Form
Sorting
Data
1. Sorting Data
2. Custom Sort Orders
3. Sorting Options
AutoFiltering
Data
1. AutoFilter
2. Using the Top 10 AutoFilter
3. Using the Custom AutoFilter
4. Turning Off the AutoFilter
Advanced
Filtering of Data
1. Creating Advanced Filters
2. Using 'And' and 'Or" Conditions in Criteria
3. Using Wildcard Characters in Criteria
4. Copying Filter Results to a New Location
5. Using Database Functions
Data
Tables
1. Data Tables
2. The Formula Reference Table
3. Structuring a Single-variable Data Table
4. Structuring a Double-variable Data Table
5. Creating the Data Table
Lookup
and Logical Functions
1. Lookup and Logical Functions
2. Lookup Functions
3. Logical Functions
4. Nesting Logical Functions
5. Masking Error Display in Worksheets
6. Using the AND and OR Functions
Scenarios
1. Creating and Displaying Scenarios
2. Editing and Deleting Scenarios
3. Merging Scenarios
4. Creating Scenario Reports
5. Using Goal Seek
Security
Features
1. Unlocking Cells
2. Worksheet Protection
3. Workbook Protection
4. Password Protecting Excel Files
Making
Macros
1. Recording Macros
2. Running Macros
3. Deleting Macros
4. The Personal Macro Workbook
Customizing
Toolbars
1. Setting Toolbar and Menu Bar Options
2. Creating Custom Toolbars
3. Adding Buttons to Toolbars
4. Adding Macro Buttons to Toolbars
5. Adding Button Dividers to Toolbars
6. Removing Toolbar Buttons
7. Resetting and Deleting Toolbars
Getting Acquainted with Peachtree
1. The Peachtree Environment (2007-2009)
2. The Peachtree Navigation Centers (2007-2009)
3. The Peachtree Environment (2003-2006)
4. Using the Menu Bar
5. Using the Main Application Toolbar (2004-2006)
6. Learning Common Business Terms
Setting Up a Company
1. Creating a Peachtree Company
2. Setting Customer Defaults
3. Setting Vendor Defaults
4. Setting Inventory Defaults
5. The Payroll Setup Wizard
6. Setting Payroll & Employee Defaults
7. Setting Job Defaults
8. Making a Backup
9. Restoring from a Backup File
Using the General Ledger
1. General Ledger Default Settings
2. Adding Accounts
3. Deleting Accounts
4. Adding Account Beginning Balances
5. Adding General Journal Entries
6. Basic General Ledger Reports
7. Entering Account Budgets (2007-2009)
8. Entering Account Budgets (2003-2006)
9. The Cash Account Register
Starting Accounts Receivable
1. Setting Up Accounts Receivable Defaults
2. Adding Customers
3. Adding Customer Beginning Balances
4. Setting Statement and Invoice Defaults
5. Sales Orders & Invoicing
6. The Sales Orders Window
7. The Sales/Invoicing Window
8. The Receipts Window
9. Statements and Finance Charges
10. Selecting Deposits
11. Changing a Record ID
Starting Accounts Payable
1. Setting Up Accounts Payable Defaults
2. Adding Vendors
3. Adding Beginning Balances for Vendors
4. The Purchase Orders Window
5. Entering a Drop Shipment
6. Select for Purchase Orders
7. The Purchases/Receive Inventory Window
8. The Payments Window
9. The Select For Payment Window
Adding Inventory
1. Adding Inventory
2. Removing Inventory
3. Entering Inventory Beginning Balances
4. Building and Unbuilding Assemblies
5. Making Inventory Adjustments
6. Changing Item Prices
Creating Payroll
1. Adding Employees
2. Adding Employee Beginning Balances
3. Paying a Group of Employees
4. Paying an Employee
5. Creating a Flat Rate Payroll Field
6. Creating a Calculated Payroll Field
7. Payroll Formulas
8. Elements of Payroll Formulas
Account
Management
1. Writing Checks
2. Voiding Checks
3. Reconciling the Bank Accounts
4. Changing the Accounting Period
Using Sales Tax
1. The Sales Tax Wizard (2008-2009)
2. Sales Tax Authorities (2003-2007)
3. Sales Tax Codes & Exempt Sales (2003-2007)
4. Collecting Sales Tax
5. Paying Sales Taxes
Get it FREE NOW!
Using Quotes
1. Entering Quotes
2. Converting Quotes
Job Tracking
1. Setting Up a Job
2. Setting Job Defaults
3. Entering Beginning Balances for Jobs
4. Making Purchases for a Job
5. Invoicing for Job Purchases
6. Job Tracking
Time and Billing
1. Adding Time Ticket Employees
2. Entering Activity Items
3. Entering Charge Items
4. Entering Time Tickets
5. Entering Expense Tickets
6. Billing Time and Expense Tickets
Changing System Settings
1. Changing Posting Methods
2. Posting/Unposting
3. Using the Purge Wizard
4. Using the Year-End Wizard
5. Memorized Transactions
Reporting
1. The Cash Manager
2. The Collection Manager
3. The Payment Manager
4. The Financial Manager
5. Find on Report (2005-2009)
6. Pre-Set Reports
7. Report Groups
8. Modifying Reports
9. Exporting Reports to Excel
10. Importing & Exporting Data
11. Exporting to PDF (2005-2009)
12. Modifying Screen Templates
13. Modifying Forms
The
Internal Accounting Review
1. Using the Internal Accounting Review (2006-2009)
Action Items
1. Events
2. To-Do Items
3. Alerts
Options
1. Changing Global Options
2. Changing the System Date
Assets and Liabilities
1. Assets and Liabilities
2. Creating an Other Current Assets Account
3. Subtracting Value from an Other Current Assets Account
4. Creating a Fixed Assets Account
5. Accumulated Depreciation
6. Liability Accounts
7. Paying on a Long Term Liability
8. Equity
Credits
1. Entering Credit Memos
2. Applying Credit Memos
3. Entering Vendor Credit Memos
Help
1. Using the Contents
2. Using the Index
3. Using the Search Feature
Getting
Acquainted with Project
1. About Project
2. The Project Environment
3. The Title Bar
4. The Menu Bar
5. The Standard Toolbar
6. The Formatting Toolbar
7. The Scroll Bars
8. The Entry Bar
9. The Status Bar
10. The Project Guide
Project Basics
1. Opening Projects
2. Closing Projects
3. Creating New Projects
4. Saving Projects
5. Using the Project Guide
6. Changing Project Views
7. Planning a Project
Tasks
1.Creating Tasks
2. Editing and Deleting Tasks
3. Setting Task Duration
4. Linking Tasks
5. Marking Milestones
6. Using Phases and Summary Tasks
7. Using Task Notes
Resources
1. Project Resources Overview
2. Creating Work Resources
3. Creating Material Resources
4. Creating Cost Resources
5. Entering Costs for Project Resources
6. Scheduling Work Resources
7. Creating New Base Calendars
Resource and Task Management
1. Assigning Work Resources to Tasks
2. Assigning Material Resources to Tasks
3. Assigning Cost Resources to Tasks
Get it FREE NOW!
Tracking Project Tasks
1. Creating Project Baselines
2. Updating Multiple Tasks in a Project
3. Updating Tasks Individually
Basic Project Reporting
1. Formatting Project Views
2. The Gantt Chart Wizard
3. Applying Text and Bar Styles
4. Basic Reports
5. Creating Custom Views
Advanced Task Management
1. Setting Task Lead and Lag Time
2. Using Task Constraints
3. Task Types
4. Setting Deadlines
5. Interrupting Tasks
6. Creating Recurring Tasks
7. Entering Fixed Costs
8. Critical Paths
Advanced Resource Management
1. Applying Multiple Resource Rates
2. Advanced Resource Availability
3. Using Work Contours
4. Material Resource Consumption Rates
5. Delaying Resource Assignments
Advanced Project Tracking
1. Monitoring Resource Allocation
2. Leveling Overallocated Resources
3. Monitoring Project Costs
4. Monitoring Project Statistics
Advanced
Project Tools
1. Using the Organizer
2. Making Macros
3. Customizing Toolbars
4. Creating and Linking Resource Pools
5. Using and Updating Resource Pools
6. Consolidating and Linking Multiple Projects
Earned Value Analysis
1. Using Earned Value Analysis
Getting
Around in QuickBooks
1. The Home Page
2. The Centers
3. The Menu Bar and Keyboard Shortcuts
4. The Navigators
5. The Open Window List
6. The Icon Bar
7. Customizing the Icon Bar
8. Using the Shortcuts List
9. The Chart of Accounts
10. Accounting Methods
11. Financial Reports
Creating a QuickBooks
Company File
1. Using the EasyStep Interview
2. Returning to the Easy Step Interview
3. Creating a Backup File
4. Restoring a Backup File
5. Setting Up Users
6. Single and Multiple User Modes
7. Closing Company Files
8. Opening a Company File
Using Lists
1. Using Lists
2. The Chart of Accounts
3. The Customers & Jobs Tab
4. The Customer Job List
5. The Employees Tab
6. The Employee List
7. The Vendors Tab
8. The Vendors List
9. Using Custom Fields
10. Sorting List
11. Inactivating and Reactivating List Items
12. Printing Lists
13. Renaming Lists
14. Merging List Items
Setting Up Sales
Tax
1. The Sales Tax Process
2. Setting Up Your Tax Agencies
3. Setting Up Your Tax Rates
4. Creating a Sales Tax Group
5. Setting Sales Tax Preferences
6. Indicating Who and What Is Taxed
Setting Up Inventory
1. Setting Up Inventory
2. Creating Inventory Items
3. Creating a Purchase Order
4. Receiving Items with a Bill
5. Entering Item Receipts
6. Matching Bills to Item Receipts
7. Adjusting Inventory
Setting Up Other
Items
1. Service Items
2. Non-Inventory
3. Other Charges
4. Subtotals
5. Groups
6. Discounts
7. Payments
8. Changing Item Prices
Basic Sales
1. Selecting a Sales Form
2. Creating an Invoice
3. Creating a Sales Receipt
4. Finding Old Invoices
5. Previewing Invoices
6. Printing Invoices
Using Price Levels
1. Using Price Levels
Creating Billing
Statements
1. Setting Statement Preferences
2. Entering Statement Charges
3. Applying Finance Charges and Creating Statements
Payment Processing
1. Recording Customer Payments
2. Entering a Partial Payment
3. Applying One Payment to Multiple Jobs
4. Entering Overpayments
5. Entering Down Payments or Prepayments
6. Applying Customer Credits
7. Making Deposits
Handling Refunds
1. Creating a Credit Memo and Refund Check
2. Refunding Customer Payments
Entering and Paying
Bills
1. Setting Billing Preferences
2. Entering Bills
3. Paying Bills
4. Early Bill Payment Discounts
5. Entering a Vendor Credit
6. Applying a Vendor Credit
Using
Bank Accounts
1. Using Registers
2. Writing Checks
3. Writing a Check for Inventory
4. Printing Checks
5. Transferring Funds
6. Reconciling Accounts
7. Voiding Checks
Get it FREE NOW!
Paying
Sales Tax
1. Sales Tax Reports
2. Using the Sales Tax Payable Register
3. Paying Your Tax Agencies
Reporting
1. Graph and Report Preferences
2. Using QuickReports
3. Zooming in on a QuickReport
4. Using Preset Reports
5. Modifying and Filtering a Report
6. Memorizing a Report
7. Memorized Report Groups
8. Printing Reports
9. Printing Forms
10.Exporting Reports to Excel
11. Saving PDF Files
Using Graphs
1. Using Graphs
Customizing Forms
1. Creating New Form Templates
2. Using the Customize Window
3. Customizing Form Templates
4. Using the Layout Designer
Estimating
1. Making Estimates for a Job
2. Duplicating Estimates
3. Invoicing From Estimates
4. Updating Job Statuses
5. Inactivating Estimates
6. Making Purchases for a Job
7. Invoicing for Job Costs
8. Using Job Reports
Time Tracking
1. Time Tracking
2. Weekly Timesheets
3. Time Enter Single Activity
4. Invoicing from Time Data
5. Using Time Reports
6. Tracking Vehicle Mileage
7. Charging Customers for Mileage
Payroll
1. The Payroll Process
2. Creating Payroll Items
3. Setting Employee Defaults
4. Setting Up Employee Payroll Information
5. Writing Paychecks to Employees
6. Voiding Paychecks
7. Tracking Your Tax Liabilities
8. Paying Your Payroll Tax Liabilities
9. Adjusting Payroll Liabilities
10. Entering Liability Refund Checks
11. Process Payroll Forms
12. Tracking Workers Compensation
Using Credit Card
Accounts
1. Creating Credit Card Accounts
2. Entering Credit Card Charges
3. Reconciling and Paying Credit Cards
Working with Asset
and Liability Accounts
1. Assets and Liabilities
2. Using an Other Current Asset
3. Removing Value from Other Current Asset Accounts
4. Creating Fixed Asset Accounts
5. Setting the Original Cost of the Fixed Assets
6. Tracking Depreciation
7. Liability Accounts
8. The Loan Manager
8. The Fixed Asset Item List
Equity Accounts
1. Equity Accounts
2. Recording an Owner's Draw
3. Making a Capital Investment
Writing Letters
With QuickBooks
1. Using the Write Letters Wizard
2. Editing Letter Templates
Company Management
1. Viewing Your Company Information
2. Setting Up Budgets
3. Using the To Do List
4. Using Reminders and Setting Preferences
5. Making Journal Entries
6. Synchronizing QuickBooks with Outlook or ACT!
7. Using the Cash Flow Projector
Using QuickBooks
Tools
1. Archiving and Condensing Data
2. Exporting Data
3. Importing Data
4. Updating QuickBooks
5. Using the Calculator
6. Using the Portable Company Files
Using the Accountant's
Review
1. Creating an Accountant's Copy
2. Using the Accountant's Copy
3. Importing Changes to Your Company File
Using Decision
Tools
1. Using Decision Tools
Using the Help
Menu
1. Using the Help and Support Center
APPENDIX A - Contractor
Edition
A.1 - The Job Costing Center
A.2 - The Contractor Menu and Navigator
A.3 - Improved Job Costing and Reporting
A.4 - Tracking and Printing Change Orders
A.5 - Custom Help Topics
© TeachUcomp, Inc. All Rights Reserved.