To check for availability, or to order a video simply click on the 6-digit video ID.
Videomarketplace is now fulfilling all Video Learning Library orders.
= Public Performance Rights Included
available for compatible viewing in Europe, Australia and New Zealand
= Closed Captioned
UPC & ISBN are included, when available
Excel 4.0/5.0 for Windows - Video Plus
Learn how to use the powerful spreadsheet features, particularly the analytical functions, reporting and presentation tools: creating charts, editing chart (Excel has 90 chart types, including 3-D, surface and radar charts). Starting with the basics of Excel, creating and saving worksheets, you'll learn how to manage your files and work with different databases. You can begin to create professional presentations in one hour! Includes disk.
Excel 95, Advanced
Includes: arranging windows; opening, arranging multiple windows; saving a workspace; creating a custom toolbar; moving, resizing a toolbar; creating a custom AutoFill list; adding notes to the worksheet; using the Info Window; creating custom format codes; entering grand totals with AutoSum; outlining workbooks; consolidating worksheets; 3-D formulas; working with sheets as groups; merging styles; building a list; using a data form; data sort; filtering a list using AutoFilter; demonstrating templates; using an autotemplete; using the Pivot Table wizard; the Scenario Manager; and using the Text wizard.
Excel 95, Formulas & Functions
Includes: creating formulas; using AutoSum; using arrays in formulas; logical operators; creating statistical formulas; displaying worksheet formulas; the Function wizard; discussing arguments, syntax; financial functions; using the Payment function; the Goal Seek command; using the IF function; the VLOOKUP function; using AutoSum to grand total; calculating dates/times with functions; querying the database; using Autofilter with Top Ten; using Data Map; converting numbers to measures; the ISNUMBER function; discussing logical values; using Rept Text; Data Analysis; Anova: Single Factor; and using Histogram.
Excel 95, Intermediate
Includes: hiding columns; viewing the worksheet; splitting the screen; freezing titles; creating, using names; using the Answer wizard and AutoCalculate; using arithmetic operators; creating formulas; using AutoSum; absolute vs relative cell references; using the Payment function; the Goal Seek command; using the TREND function; linking Excel workbooks; linking worksheets; using AutoFormat; saving linked workbooks; charting; chart basics; using the Chart wizard and AutoComplete; and creating, using shared lists.
Excel 95, Introduction
Includes: Excel's workbooks; discussing sheet tabs; moving through worksheets; selecting cells; using the Tip wizard; entering numbers into cells; using built-in number formats; using the toolbar buttons; changing the column width, row height and cell alignment; clearing, deleting data; using the Undo command; creating a new workbook; entering data in a range; editing a cell; entering text, formulas into a spreadsheet; using AutoFill; entering formulas; using the SUM function; demonstrating AutoSum; copying, moving data; editing characters; using Format Painter; spell checking; and the Print Dialog Box, Print Preview.
Excel 95, Macros & Charts
Includes: recording macros; Personal Macro workbooks; creating absolute references; working with Visual Basic; running a macro; viewing macro code; attaching macros; recording to menus; creating buttons within a worksheet; attaching macros to toolbar buttons; customizing an existing toolbar; adding custom buttons; moving toolbars; graphics and macros; user defined functions; defining arguments; using the Menu Editor; interactive macros; chart basics; using Chart wizard; adding data to a chart; changing patterns; rotating 3-D charts; picture charts; and adding trendlines.
Excel 97, Advanced
Excel 97, Formulas & Functions
Excel 97, Intermediate
Excel 97, Introduction
Excel 97, Macros & Charts
Introduction to Lotus 1-2-3
Introduction to Lotus 1-2-3, Level II
Learning Lotus Spreadsheets 1-2-3
Learn how make your own spreadsheets and presentations with this simple and easy-to-understand program.
Lotus 1-2-3 96 Edition, Advanced
Includes: using the Version Manager; creating a version; modifying, updating a version; creating a Version report; sorting versions; working with Scenarios; creating a database; using criteria and query tables; sorting records; finding, deleting records; using external databases; using, planning and placing macros; creating a macro command; naming, saving and running a macro; protecting data; sealing a file; specifying ranges as unprotected; limiting access to a file; deleting a password; embedding information; Statistical Analysis; discussing Frequency Distribution; Regression Analysis; and discussing Matrix Analysis.
Lotus 1-2-3 96 Edition, Formulas & Functions
Includes: using/building formulas; referring to cells, ranges in formulas; entering range names in a formula; copying, moving formulas; auditing; explaining function formats; entering a function; adding a function to a menu; removing a function; learning about @ functions; calculating a Frequency Distribution; explaining Regression Analysis; predicting values for dependent variables; using data matrixes; What-if problems; explaining Backsolver; using what-if tables; solving problems; charting what-if tables; using Solver; symbolic and numeric solving techniques; multiple worksheets, files; setting up constraints; determining adjustable cells and an optimal cell; and viewing answers.
Lotus 1-2-3 96 Edition, Intermediate
Includes: explaining a sample program; running the sample program; defining Control statements; discussing the infinite loop; using Assign statements; listing mathematical operators; relational expressions; using the If and Else statement; discussing the Scanf statement; using/changing the For statement; adding a continue/break statement; Logical/Assignment operators; explaining data types; defining/using the Printf statement; using a Sub and Void function; using the Distance function; Positional parameters; showing a pointer; using the Test function; the elements of an array; using strings and the Gets statement; the Atoi/Scanf statement; discussing pointers, addresses; declaring a FILE; and using the String Copy statement.
Lotus 1-2-3 96 Edition, Introduction
Includes: the 1-2-3 environment and basics; viewing a SmartMaster file; the Control Panel; using SmartIcons; discussing worksheet fundamentals; scrolling through a document; discussing the Status Bar; inserting, deleting, naming and viewing worksheets; entering, deleting and aligning text; working with text, numbers in a worksheet; spell checking a file; finding and replacing text; formatting text; using the Drag and Fill command; demonstrating the Fill by Example command; manipulating columns and rows; and discussing basic formulas and functions.
Lotus 1-2-3 Basics
Learn to prepare and install Lotus 1-2-3, build simple and complex spreadsheets and design a basic workflow. Practice disc included.
Lotus Spreadsheets 4.0 for Windows - Video Plus
Experience new and improved Lotus 1-2-3, version 4.0, featuring full integration with Windows applications. Menus and button bars, new live status bar, in cell editing, new worksheet tabs and much more. Includes disk.
Quattro Pro 7.0 for Windows95, Advanced
Includes: creating a chart; using scenarios; making a scenario report; using the Consolidator; using the Analysis command; the Data Modeling Desktop; saving to a notebook page; creating, searching, and sorting a database; viewing Paradox tables in the Database Desktop; querying the database; assigning passwords; changing the High level password; using a password on start up; removing password protection; creating a custom toolbar; recording/running a macro; attaching a macro to a button; creating a notebook template; linking a button to the Internet; and creating/editing a map.
Quattro Pro 7.0 for Windows95, Introduction
Includes: discussing the Quattro Pro window; using Toolbar button help; opening a sample notebook; working with a chart; viewing/editing a slide show; creating a notebook; changing page tab attributes; creating, naming, using a group; changing cell attributes; using SpeedSum/SpeedFormat; including a hidden comment; hiding/revealing a column; moving a notebook page; combining with other notebook data; inserting a page in a notebook; splitting the notebook window; using the Application dialog box; creating, resizing, moving a chart; changing chart attributes; using the PerfectExpert; placing text in a chart; creating a comparison chart; viewing/renaming a chart; listing Quattro Pro's operators; creating a formula; and discussing/using @ functions.
Updating to Excel 95
Includes: the Answer wizard; help screen improvements; using AutoComplete, AutoCalculate, AutoCorrect and Drag & Drop; discussing scroll tips; showing cell tips; using AutoFilter; the Top Ten list; using DataMap; the built-in templates; the Template wizard; document retrieval; the management system; discussing easy number formatting; the shared lists feature; and the Access links feature.
Using Lotus 1-2-3 V4.0 for Windows
Teaches you about one of the world's leading electronic spreadsheets. Learn to create 3-D worksheets, produce presentation-quality reports, and customize the 1-2-3 SmartIcons to make spreadsheet operations fast and easy. You'll be amazed at how much you'll learn and how quickly.
Using Microsoft Excel 5.0 for Windows
Produce informative spreadsheets in minutes with this program. This easy-to-use instructional program includes everything you need to build multi-column spreadsheets, shortcuts to creating a chart and adding a professional look to your work using persuasive fonts and graphic images. You'll be amazed at how much you'll learn and how quickly.
Copyright © 2006, Video Learning