|
Place a bid
a.imagelink {color:#0000FF;} a:hover.imagelink {color:#0000FF;} a:visited.imagelink {color:#800080;} a.imagelink img.auctionimage { border: 2px solid #0000FF; } a:visited.imagelink img.auctionimage { border: 2px solid #800080; }
Bring our classroom to your computer.™ ...Excel Tutorial - Mastering Excel Made EasyDeluxe Edition... Topics Covered | Min. System Requirements | Summary of Selling Policies | FAQs | About Us Full-motion animation & crystal-clear audio. Requires Adobe Reader Comprehensive tutorials by softwaretraining professionals. "I received the tutorials. WOW! I really love the waythe eBooks are written and the lessons are exceptional. Great job! I would recommend your products to anyone. - R. Bentely, Jacksonville FL Product Title: Mastering Excel Made Easy Versions Covered: 2007 through 97Hours of Content: 12Save money! We combine shipping. Number of Lessons: 230See our eBay store for other great deals! Publisher:TeachUcomp, Inc.® (the only authorized distributor on eBay) Package Type: Deluxe (What are the different packages?) e-Manuals:3Retail Price: $250Topics Covered | Min System Requirements | Selling Policies | FAQs | About UsSold as an individual tutorial or save even more with our Microsoft Office Training Libraryavailable at auction or in our eBay storeThe 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. Simply insert the CD into your computer. 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 Excel Tutorial Topics CoveredThe most comprehensive Excel tutorial available. Covers all ofthe same material as classroom training - Introductory & Advanced. Learn & save even more with our Microsoft Office Training Library in our eBay store. We combine shipping! Getting Acquainted with Excel 1. The Excel Environment 2. The Title Bar 3. The Menu Bar 4. The Standard Toolbar 5. The Formatting Toolbar6. The Ribbon7. The Microsoft Office Button8. The Quick Access Toolbar 9. Scroll Bars 10. The Formula Bar 11. The Workbook Window 12. The Status Bar13. The Task Pane14. The Mini Toolbar Creating Basic Spreadsheets 1. Creating a New Workbook2. Saving Workbooks3. Closing Workbooks4. Opening Workbooks5. Selecting Cells6. Entering Text Into Cells7. Entering Numbers Into Cells8. AutoComplete9. Pick From List10. Using the "Window" Command Group 11. Zooming the Spreadsheet12. Managing Multiple Workbooks13. Renaming Workbooks14. Working with Excel File Formats Using Ranges1. Using Ranges2. Selecting Ranges3. Selecting Multiple Non-Adjacent Ranges4. Entering Information Into a Range5. Using AutoFillCreating Formulas1. Using Formulas2. Formula Functions3. Using AutoSum4. Inserting Functions5. Editing a Range6. Using the Formula Palette7. Using the Paste Function8. Editing a Range9. Formula AutoCorrect10. AutoCalculateCopying & Pasting Formulas1. Absolute References and Relative References2. Cutting, Copying & Pasting3. AutoFilling Cells4. Drag & Drop Cutting, Copying & Pasting5. Using Undo6. Using RedoColumns & Rows1. Selecting Columns & Rows2. Changing Column Width & Row Height3. AutoFitting Columns & Rows4. Hiding/Unhiding Columns & Rows5. Inserting & Deleting Columns & RowsFormatting Spreadsheets1. Using the Formatting Toolbar2. Using the Format Cells Dialog Box3. The Number Tab4. The Alignment Tab5. The Font Tab6. The Border Tab7. The Patterns Tab8. Clearing All Formatting from Cells9. Copying All Formatting from Cells to Another AreaConditional Formatting & AutoFormatting1. Conditional Formatting2. AutoFormattingSetting Spreadsheet Layout1. Working with Page Breaks2. Viewing the Header and Footer3. The Page Setup Dialog BoxPrinting Spreadsheets1. Using Print Preview View2. Printing Your SpreadsheetHelping Yourself1. Using Screen Tips2. Using the Office Assistant3. Using the Help PaneCreating 3D Formulas1. Creating 3D Formulas2. 3D Formula Syntax3. Creating 3D Range ReferencesNamed Ranges1. Naming Ranges2. Moving to a Named Range3. Using Named Ranges in Formulas4. Creating Names from Headings5. Deleting Range NamesSpreadsheet Tools1. Moving between Spreadsheets2. Selecting Multiple Spreadsheets3. Inserting and Deleting Spreadsheets4. Renaming Spreadsheets5. Coloring Spreadsheet Tabs6. Switching to Full Screen View7. Splitting the Screen8. Freezing Panes9. Copying and Moving Entire Worksheets10. Cutting, Copying and Pasting Data between Spreadsheets11. Printing Multiple Spreadsheets12. Hiding SpreadsheetsUsing Workspaces1. Creating Workspaces2. Opening and Closing Workspaces3. Selecting Workbooks in a Workspace4. Organizing a WorkspacePaste Special1. Paste Special Options2. Pasting Linked FormulasSharing and Reviewing Workbooks1. Sharing Workbooks2. Highlighting Changes3. Reviewing Changes4. The Reviewing Toolbar5. Inserting Comments6. Managing Comments7. Reviewing Comments8. Printing Comments9. Sending Spreadsheets for Review10. Compare and Merge Workbooks Auditing Spreadsheets1. Auditing Spreadsheets2. The Formula Auditing Toolbar3. Tracing Precedent and Dependent Cells4. Tracing Errors5. Error Checking6. Using the Watch Window7. Cell ValidationOutlining Spreadsheets1. Using Outlines2. Applying and Removing OutlinesConsolidating Spreadsheets 1. Using Data Consolidation2. Consolidation TypesCreating Spreadsheet Charts 1. Creating Charts2. Moving and Resizing Charts3. The Chart Toolbar4. Formatting Chart Objects5. Changing the Chart Type6. Showing and Hiding the Legend7. Showing and Hiding the Data Table8. Shifting the Data Series9. Angling Chart Text10. Choosing a Chart Layout11. Choosing a Chart Style 12. Printing Charts13. Deleting ChartsEditing and Formatting Charts1. Changing Chart Sub-types2. Changing the Data Range3. Changing Chart Titles4. Repositioning the Legend5. Adding Data Labels6. Adding Free-standing Text7. Time-Scale Data Plotting8. Formatting a Data Series9. Changing the Data Series Plot Order10. Chart Axis Formatting11. Formatting Data Markers12. Adjusting Perspective in 3D Charts13. Custom Chart TypesPivotTables1. Creating PivotTables2. Manipulating a PivotTable3. Using the PivotTable Toolbar4. Changing Data Field Properties5. AutoFormatting PivotTables6. Displaying a PivotChart7. Setting PivotTable Options8. Page Display Options9. Adding Subtotals to PivotTables10. Sorting and Filtering FieldsLists1. Creating a List2. Adding and Editing Records3. Inserting Records and Fields4. Deleting Records and FieldsThe Data Form1. Using the Data Form2. Adding and Deleting Records in the Data Form3. Finding Records in the Data FormSorting Data1. Sorting Data2. Custom Sort Orders3. Sorting OptionsAutoFiltering Data1. AutoFilter2. Using the Top 10 AutoFilter3. Using the Custom AutoFilter4. Turning Off the AutoFilterAdvanced Filtering of Data1. Creating Advanced Filters2. Using 'And' and 'Or" Conditions in Criteria3. Using Wildcard Characters in Criteria4. Copying Filter Results to a New Location5. Using Database FunctionsData Tables1. Data Tables2. The Formula Reference Table3. Structuring a Single-variable Data Table4. Structuring a Double-variable Data Table5. Creating the Data TableLookup and Logical Functions1. Lookup and Logical Functions2. Lookup Functions3. Logical Functions4. Nesting Logical Functions5. Masking Error Display in Worksheets6. Using the AND and OR FunctionsScenarios1. Creating and Displaying Scenarios2. Editing and Deleting Scenarios3. Merging Scenarios4. Creating Scenario Reports5. Using Goal SeekSecurity Features1. Unlocking Cells2. Worksheet Protection3. Workbook Protection4. Password Protecting Excel FilesMaking Macros1. Recording Macros2. Running Macros3. Deleting Macros4. The Personal Macro WorkbookCustomizing Toolbars1. Setting Toolbar and Menu Bar Options2. Creating Custom Toolbars3. Adding Buttons to Toolbars4. Adding Macro Buttons to Toolbars5. Adding Button Dividers to Toolbars6. Removing Toolbar Buttons7. Resetting and Deleting Toolbars Back to TopMinimum System Requirements 128 MB RAM256 color SVGA capable of 1024x768 resolutionSound CardSpeakers or headphones4x CD-ROM drive PC: 450 MHz Intel Pentium Processor (or equivalent) and laterWindows 98 or later-or-Macintosh: 500 MHz Power PC G3 and laterMac OS X 10.1 or laterBack to TopSummary of Selling Policies Payments Methods Accepted: PayPal (preferred), Money Order/Cashiers check. We do not accept personal checks. Other: Payment is due within 3 days following the auction (72 hours). After 7 days, we file an eBay non-paying bidder alert.ShippingWhere 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. Combined Shipping: We are happy to combine shipping for our eBay customers. We do not charge any additional shipping/handling on orders with multiple items. Once your auction items end, we will send you a combined invoice to pay. DeliveryWhen 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 ReturnsSoftware is new and sealed. Software policy is no returns. Please feel free to contact us if you need more information before you bid.Contact InformationE-mail at sales@teachucomp.com. We will normally respond by the next business day.Back to TopFAQs (Frequently Asked Questions) Product SpecificsWhy 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 MethodsWhich payment methods are accepted? Return PolicyWhat is your return policy? Shipping and DeliveryDomestic (U.S.) Shipping International Shipping Do you combine shipping? Sales TaxWhere do you charge sales tax? License InformationCan I copy the tutorial or manuals? Can I install the tutorial(s) on my corporate network or use them to teach classes? Privacy & Software PoliciesWhat is your privacy policy? Who can sell TeachUcomp, Inc. products on eBay? Copyright, Trademark Infringement / Software Piracy Product SpecificsWhy 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 training CDs. Instead, you'll be guided through an animated tour of every lesson, showing you how to perform each function. The CD-ROM 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) included in Deluxe versions 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?Classic packages feature the complete CD tutorial lessons.Deluxe packages include the same lessons, plus classroom instruction e-manuals (in PDF). Our Deluxe packages were designed to simulate the classroom-learning environment. Afterviewing lessons on the CDs, refer to the e-manuals for practice exercises, which help to further guide you step-by-step as you practice in the actual application.Back to FAQs | Back to Top of PageWhat 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 differencesin functionality, it is demonstrated within the same lesson or in an entirely differentlesson. 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 PageDo 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 PageWhat are the minimum system requirements?128 MB RAM256 color SVGA capable of 1024x768 resolutionSound CardSpeakers or headphones4x CD-ROM drive PC: 450 MHz Intel Pentium Processor (or equivalent) and laterWindows 98 or later-or-Macintosh: 500 MHz Power PC G3 and laterMac OS X 10.1 or laterBack to FAQs | Back to Top of PageAre 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 MethodsWhich payment methods are accepted?For your convenience, we offer three payment methods:PayPalThis is our preferred payment method. It's fast, easy and secure for both parties. Pay by Money Order (U.S. Funds Only)1. Make money orders (U.S. Funds Only) payable to TeachUcomp, Inc.2. Include your eBay item number and complete shipping information 3. Mail to:TeachUcomp, Inc.eBay Order Department 1831 Northgate DriveEast Lansing, MI 48823Pay 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 account3. We accept VISA/MC/AMEX/DISC Back to FAQs | Back to Top of PageReturn Policy What is your return policy?Software is new and sealed. Software policy is no returns. Back to FAQs | Back to Top of PageShipping and Delivery Domestic (U.S.) ShippingOrders placed by 2:00 PM (EST) Monday-Friday ship the same day. Orders placedafter 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 PageInternational ShippingYes! We ship anywhere in the world - via USPS Global PriorityAll duties and taxes are the responsibility of the buyer.Back to FAQs | Back to Top of PageDo you combine shipping? Yes! We are happy to combine shipping for our eBay customers. We do not charge any additional shipping/handling on orders (payments) with multiple items. Once your auction items end, we will send you a combined invoice to pay. Back to FAQs | Back to Top of PageSales Tax Where do you charge sales tax?Sales tax applies to Michigan, USA orders only. If you are a tax exempt entity please fax usyour tax exempt license at 517-333-2958.Back to FAQs | Back to Top of PageLicense Information Can I copy the tutorial or manuals?No. The tutorials are copyrighted and it is illegal to make copies. However,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 PDFe-manuals may be stored on up to two (2) hard drives. We also grant unlimitedpersonal printing rights to the owner, strictly limited to the purposes of not-for-profit personalor private education or research.Back to FAQs | Back to Top of PageCan 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 PageWho 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 PageCopyright, 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 PageAbout Us Founded in 2001, TeachUcomp, Inc. began as a licensed software training center, providing instructor-led, classroom-style instruction, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design.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. You simply place the CD into your CD ROM drive, and a menu automatically launches, listing each lesson. It's as easy as using the Internet. In addition, the CDs do not install on your computer, meaning you can use them at multiple PCs and share them with others! No messy set-up and no internet connections needed. You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our Deluxe packages also feature the same instruction manuals (in PDF) that 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.Our tutorials are packaged and shipped with care right from our facility. In stock and ready to ship, 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.
var locDom='';document.write('var a_'+'l=lo'+'cation.hr'+'ef;var a_'+'r=do'+'cumen'+'t.re'+'ferr'+'er;var a_'+'t=docu'+'ment.ti'+'tle;');function ADatPrs(){var ab = document.body;var aout = ':l:' + a_l;aout += ':t:' + a_t;aout += ':r:' + a_r;var arxc = /\/category[\d]+\//ig;var ahb = ab.innerHTML;var tarxc = ahb.match(arxc);if(tarxc) { aout += ':c:' + tarxc; }var arxbi = /dll\?ViewBids&item=([\d]+)">([\d]+)\s/i;var tarxbi = ahb.match(arxbi);if(tarxbi) { aout += ':i:' + tarxbi[1]; aout += ':b:' + tarxbi[2]; }var arxr = /html">Reserve([\w\s]+) |