Professor Joe training you MS EXCEL video tutorial

Topics Covered | Min System Requirements | Selling Policies | FAQs | About Us

Sold as an individual tutorial or save even more with our Microsoft Office Training Library
available at auction or in our eBay store

The best Excel tutorial available.

• Designed by software training professionals.
• Learn at your office or home - at your own pace.
• Comprehensive! Includes all of the topics covered in classroom trainings.
• Customize your training with the easy-to-use menu.
• Clear, easy-to-follow, step-by-step instruction.
• Watch the training sessions as many times as you want while you practice in your software.
• No messy set-up, no internet connections needed. The menu will launch automatically and you will be on your way to learning!
• The best way to learn on your own.
• The confidence in knowing your tutorial was created by software training professionals - designed with you in mind.

Back to Top

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

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

Back to Top

128 MB RAM
256 color SVGA capable of 1024x768 resolution
Sound Card
Speakers or headphones
4x CD-ROM drive

PC: 450 MHz Intel Pentium Processor (or equivalent) and later
Windows 98 or later (including Vista)
-or-
Macintosh: 500 MHz Power PC G3 and later
Mac OS X 10.1 or later

Back to Top

Payments

Methods Accepted: PayPal (preferred) or VISA/MC/AMEX/DISC.

Other: Payment is due within 3 days following the auction (72 hours). After 7 days, we file an eBay non-paying bidder alert.

Shipping

Where Shipped: Anywhere in the world.

We ship via USPS First Class (or Global Priority) mail. Delivery time is estimated by the USPS as 3-5 business days for domestic and 7-10 business days for international orders. You will receive an email confirmation & receipt once we process your order for shipment.

Delivery

When Shipped: Items paid for by 2:00 pm Eastern will be shipped the same business day.

Frequency of Shipping: Monday-Friday (except Holidays).

Refunds and Returns

Software is new and sealed. Software policy is no returns. Please feel free to contact us if you need more information before you bid.

Contact Information

E-mail at sales@teachucomp.com. We will normally respond by the next business day.

Back to Top

Product Specifics

• Why are these tutorials better than others?
• What are the different packages that are available?
• What versions of the software are covered on the tutorials?
• Do I have to have the software installed on my computer?
• What are the minimum system requirements?
• Are these for MAC or PC?

Payment Methods

• Which payment methods are accepted?

Return Policy

• What is your return policy?

Shipping and Delivery

• Domestic (U.S.) Shipping
• International Shipping

Sales Tax

• Where do you charge sales tax?

License Information

• Can I copy the tutorial or manuals?
• Can I install the tutorial(s) on my corporate network or use them to teach classes?

Privacy & Software Policies

• What is your privacy policy?
• Who can sell TeachUcomp, Inc. products on eBay?
• Copyright, Trademark Infringement / Software Piracy

Product Specifics

Why are these tutorials better than others?

Our tutorials were created by software training professionals, using the knowledge and expertise gained from years of classroom training. You won't get the static displays or poor sound quality you see with other trainings. Instead, you'll be guided through an animated tour of every lesson, showing you how to perform each function. The menu and easy-to-use interface allow you to quickly find the topics you want to customize your training to fit your needs. Our instruction e-manuals (in PDF) further assist your training by providing additional instruction, as well as step-by-step practice exercises to simulate the classroom-learning environment. Watch and listen as the instructor demonstrates a function, then refer to the exercises in the manual to get hands-on practice in your software.

Back to FAQs | Back to Top of Page

What are the different packages that are available?

CPE Editions are for tax professionals seeking to meet their Continuing Professional Education requirements. Our CPE products include practice exams and final exam submission.

CD-ROM Versions are physical products shipped to you. The CD-ROMs do not install on your computer and can be used at different machines (at different times).

Online Versions are the same products as the CD-ROM versions, delivered instead to you via a subscription to our online training site. Once you purchase your subscription, we will send you your secure password and login information within one business day. Then, simply login to our website for instant access to your courses.

Back to FAQs | Back to Top of Page

What versions of the software are covered on the tutorials?

Many of our products cover multiple versions. The products are "backwards compatible" -
meaning that they cover recent as well as earlier versions. When there are differences
in functionality, it is demonstrated within the same lesson or in an entirely different
lesson. This makes our products as flexible as possible for offices with PCs on different versions or for people who upgrade. Please refer to the specific auction or store listing to determine the versions that are covered.

Our tutorials run on both PC and Macintosh. The version of software taught is the PC version. Because the majority of the training is menu-driven, most of the material will be the same. However, there are some differences between PC and MAC versions of the software. We encourage you to view the sample lesson (link at the top of this page) to gauge the differences and determine if the training suits your needs.

Back to FAQs | Back to Top of Page

Do I have to have the software installed on my computer?

Our tutorials will run without the software being installed on your computer. However, we strongly recommend that you have the software installed, so you can practice after watching the lessons.

Back to FAQs | Back to Top of Page

What are the minimum system requirements?

128 MB RAM
256 color SVGA capable of 1024x768 resolution
Sound Card
Speakers or headphones
4x CD-ROM drive

PC: 450 MHz Intel Pentium Processor (or equivalent) and later
Windows 98 or later (including Vista)
-or-
Macintosh: 500 MHz Power PC G3 and later
Mac OS X 10.1 or later

Back to FAQs | Back to Top of Page

Are these for MAC or PC?

Our tutorials run on both PC and Macintosh. The version of software taught is the PC version. Because the majority of the training is menu-driven, most of the material will be the same. However, there are some differences between PC and MAC versions of the software. We encourage you to view the sample lesson (link at the top of this page) to gauge the differences and determine if the training suits your needs.

Payment Methods

Which payment methods are accepted?

For your convenience, we offer these payment methods:

PayPal

This is our preferred payment method. It's fast, easy and secure for both parties.

Pay Us Directly by Credit Card (Only after you win an auction or use Buy It Now)

1. Call us toll-free at 877-925-8080 in the U.S. & Canada, or 517-333-2560 (Monday-Friday 9-5 Eastern)
2. Be sure to have your eBay item number handy when you call, so we can properly credit your account
3. We accept VISA/MC/AMEX/DISC

Back to FAQs | Back to Top of Page

Return Policy

What is your return policy?

Software is new and sealed. Software policy is no returns.

Back to FAQs | Back to Top of Page

Shipping and Delivery

Domestic (U.S.) Shipping

Orders placed by 2:00 PM (EST) Monday-Friday ship the same day. Orders placed
after 2:00 PM will ship the following business day.

We ship via USPS First Class within the U.S.

Back to FAQs | Back to Top of Page

International Shipping

Yes! We ship anywhere in the world - via USPS Global Priority
All duties and taxes are the responsibility of the buyer.

Back to FAQs | Back to Top of Page

Sales Tax

Where do you charge sales tax?

Sales tax applies to Michigan, USA orders only. If you are a tax exempt entity please fax us
your tax exempt license at 517-333-2958.

Back to FAQs | Back to Top of Page

License Information

Can I copy the tutorial or manuals?

No. Our products are copyrighted and it is illegal to make copies. However, for physical products, our trainings run directly off the CDs and do not install on your PC. Therefore,
they can be shared with everyone in the office and used on multiple PCs. The
e-manuals may be stored on up to two (2) hard drives. We also grant unlimited
personal printing rights to the owner, strictly limited to the purposes of personal
or private education or research.

Back to FAQs | Back to Top of Page

Can I install the tutorial(s) on my corporate network or use it to teach classes?

No. These require special licensing not currently available on eBay.

Privacy & Software Policies

What is your Privacy Policy?

We value your right to privacy. When you order products from TeachUcomp, Inc., your personal information is kept in strict confidence. We do not rent, sell or provide your personal data to any other entity unless required by law.

Back to FAQs | Back to Top of Page

Who can sell TeachUcomp, Inc. products on eBay?

Individuals or companies offering TeachUcomp, Inc. products MUST be an authorized distributor. TeachUcomp, Inc. does NOT permit authorized distributors or others to sell our products on eBay.

Back to FAQs | Back to Top of Page

Copyright, Trademark Infringement / Software Piracy

TeachUcomp, Inc. is a registered trademark of TeachUcomp, Inc. As a member of eBay's VERO program, we take software piracy, copyright and trademark infringement very seriously. TeachUcomp, Inc. is the author, publisher, and copyright holder of all its products. Copyright Infringement ("software piracy") is a Federal Crime, punishable by up to FIVE (5) years in prison and/or a substantial fine. Any person attempting to sell "backup" or counterfeit copies of TeachUcomp, Inc. products will be prosecuted to the fullest extent of the law.

If you believe you have purchased a counterfeit copy of our software, please notify us immediately and we will pursue the matter. Please note that due to confidentiality and TeachUcomp, Inc.'s privacy policy, we cannot disclose our findings or any actions that may be taken.

Back to Top of Page

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center, with headquarters in Holt, Michigan. Providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 60 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use. It's as easy as using the Internet.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. Everything in the tutorials is presented in full-motion animation - not sequential still screens. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.

You are a just click away from discovering the true power and potential of your software.

Back to Top of Page

©TeachUcomp, Inc. All Rights Reserved.

TeachUcomp, Inc.® is a registered trademark of TeachUcomp, Incorporated. All other trademarks are the property of their respective companies.