Quattro Pro
|
Quattro Pro 8.0 Three Video Set -- Beginning, Intermediate and Advance
Details
|
$119.95
|
kyqp8a
|
|
|
Quattro Pro 7.0 Three Video Set --
Beginning, Intermediate and Advance
Details
|
$119.95
|
kyqp7a
|
|
Quattro Pro 8.0 Training Videos Curriculum
|
|
 Beginning Video (2 hrs 6 min)
1.0 Basics (14 min)
1.1 The Application Window
1.2 Opening an Existing Document
1.3 Navigating the Notebook
2.0 Creating Your First Notebook (22 min)
2.1 Entering & Editing Data
2.2 Labels Versus Numbers
2.3 Using Undo
2.4 Selecting Blocks of Data
2.5 Clearing Notebook Entries
2.6 Using Quickfill to Automate Data Entry
2.7 Using QuickSum to Calculate Totals
2.8 Saving Your Work
3.0 Making Changes (31 min)
3.1 Copying & Moving
3.2 Inserting & Deleting Rows & Columns
3.3 Finding & Replacing Data
3.4 Spell Check & Quick Correct
4.0 Getting Help (7 min)
4.1 Getting Context Sensitive Help
4.2 Searching for a Help Topic
4.3 Asking the Perfect Expert
5.0 Entering Formulas (18 min)
5.1 Entering Basic Formulas
5.2 Getting Help From the Formula Composer
5.3 Using Spreadsheet Functions (min, max, etc.)
5.4 Quick Cell
6.0 Formatting Spreadsheet Data (25 min)
6.1 Speed Format
6.2 Quick Fit
6.3 Changing Column Widths & Row Heights
6.4 Working with Fonts
6.5 Alignment Features
6.6 Clearing Values & Formats
6.7 Modifying Numeric Formats
6.8 Adding borders
7.0 Printing Your Work (6 min)
7.1 Specifying What You Want to Print
7.2 Previewing & Printing Your Work
Intermediate Video (2 hrs 2 min)
1.0 Working with Large Spreadsheets (29 min)
1.1 Zoom
1.2 Splitting the Notebook Window
1.3 Locking Notebook Titles
1.4 Using Block Name to Facilitate Navigation
1.5 Inserting Page Breaks
1.6 Setting Notebook Properties
1.7 Working with Toolbars
2.0 Creating Multi-Page Notebooks (23 min)
2.1 Copying from Sheet to Sheet
2.2 Naming Notebook Sheets
2.3 Creating Multi-Sheet Formulas
2.4 Right Mouse Click Options (Setting Sheet Properties)
2.5 Creating Group Names
2.6 Using Group Mode to Improve Efficiency
3.0 Working with Multiple Notebooks (22 min)
3.1 Copying from Notebook to Notebook
3.2 Inserting another Notebook
3.3 Creating Multi-notebook Formulas
3.4 Saving Your Workspace & Updating Links
3.5 Consolidating Notebook Data
4.0 Advanced Formulas (15 min)
4.1 Absolute Cell References
4.2 Date & Time Functions
5.0 Advanced Formatting Techniques (18 min)
5.1 Reveling & Hiding Spreadsheet Data
5.2 Using Constraints to Control Data Entry
5.3 Paste Format
5.4 Utilizing Styles to Improve Productivity
6.0 Advanced Print Options (13 min)
6.1 Setting Margins
6.2 Selecting the Paper Type
6.3 Adding Headers & Footers
6.4 Print Scaling
6.5 Named Settings
6.6 Options
Advanced Video (1 hr 56 min)
1.0 Projects (6 min)
1.1 Using a Project
1.2 Creating an Expense Report
1.3 Generating an Invoice
2.0 Database Techniques (24 min)
2.1 Sorting Notebook Data
2.2 Quick Filter
2.3 Notebook Query
2.4 Outlining
3.0 Power Functions (23 min)
3.1 The IIF Function
3.2 Using AND & OR in Formulas
3.3 Auditing
3.4 Calculating Loan Payments
4.0 Charting Your Spreadsheet Data (21 min)
4.1 Inserting a Chart
4.2 Changing the Chart Type
4.3 The Chart Gallery & Advisor
4.4 Modifying Chart Titles
4.5 Modifying a Chart Series
4.6 Changing the Properties of Chart Objects
4.7 Inserting Graphics & Shapes
4.8 Printing the Chart
5.0 Enhancing Your Notebook with Objects (16 min)
5.1 Inserting Images
5.2 Inserting OLE Objects
5.3 The Objects Page
5.4 Placing Notebook Data in a Word Processing Document
6.0 Macros (13 min)
6.1 Recording a Macro
6.2 Naming a Macro
6.3 Playing a Macro
6.4 Using a Quick Button to Execute a Macro
7.0 Working with the Internet (10 min)
7.1 Saving Your Notebook Data as HTML
7.2 Hyperlinks
7.3 Using a Quick Button to Access the Internet
Quattro Pro 7.0 Training Videos Curriculum
|
|
Beginning Video (1 hr 56 min)
1.0 The Basics (10 min)
1.1 The Application Window
1.2 Navigating the Notebook
2.0 Creating Your First Notebook (22 min)
2.1 Entering and Editing Data
2.2 Using Undo
2.3 Changing Cell Data
2.4 Selecting Blocks of Data
2.5 Using QuickFill to Automate Data Entry
2.6 Using QuickSum to Calculate Totals
2.7 Saving Your Work
3.0 Making Changes (23 min)
3.1 Copying
3.2 Moving
3.3 Inserting and Deleting Rows and Columns
3.4 Finding and Replacing Data
3.5 Spell Check and QuickCorrect
4.0 Getting Help (7 min)
4.1 Context Sensitive Help
4.2 Searching for a Help Topic
4.3 Asking the PerfectExpert
5.0 Entering Formulas (13 min)
5.1 Entering Basic Formulas
5.2 Getting Help from the Formula Composer
5.3 Using Spreadsheet Functions (min, max, etc.)
6.0 Formatting Spreadsheet Data (26 min)
6.1 SpeedFormat
6.2 QuickFit
6.3 Changing Column Widths and Row Heights
6.4 Working with Fonts
6.5 Alignment Features
6.6 Clearing Values and Formats
6.7 Modifying Numeric Formats
6.8 Adding Borders
7.0 Printing Your Work (12 min)
7.1 Specifying What You Want to Print
7.2 Previewing Your Work
7.3 Additional Print Options
Intermediate Video (1 hr 54 min)
1.0 Controlling the Environment (18 min)
1.1 Setting Application Preferences
1.2 Zooming in & out
1.3 Working with Toolbars
1.4 Modifying the Display Options
2.0 Working with Large Spreadsheets (25 min)
2.1 Splitting the Notebook Window
2.2 Locking Notebook Titles
2.3 Using Range Names to Facilitate Navigation
2.4 Inserting Page Breaks
2.5 Setting Notebook Properties
3.0 Advanced Formatting Techniques (21 min)
3.1 Using Shading and Borders to Emphasize Important Data
3.2 Revealing and Hiding Spreadsheet Data
3.3 Using Constraints to Control Data Entry
3.4 Utilizing Styles to Improve Productivity
4.0 Advanced Formulas (17 min)
4.1 Absolute Cell References
4.2 Date & Time Functions
5.0 Creating Multi-page Notebooks (24 min)
5.1 Copying from Page to Page
5.2 Creating Multi-page Formulas
5.3 Setting Page Properties
5.4 Moving Pages
5.5 Creating Group Names
6.0 Advanced Print Options (8 min
6.1 Sheet Options & Page Setup
Advanced Video (1 hr 53 min)
1.0 Working with Multiple Notebooks (18 min)
1.1 The File Management Dialog
1.2 Copying from Notebook to Notebook
1.3 Inserting Another Notebook
1.4 Creating Multi-notebook Formulas
1.5 Saving Your Workspace
1.6 Updating Notebook Links
2.0 Data Consolidation (12 min)
2.1 Selecting Source and Destination Blocks
2.2 Saving and Using Consolidation Settings
3.0 Database Techniques (24 min)
3.1 Sorting Notebook Data
3.2 Notebook Query
3.3 Working with Fill Series
4.0 The Data Modeling Desktop (24 min)
4.1 Creating Label Bars
4.2 Filling in Report Data
4.3 Pivoting Label Bars
4.4 Creating Totals & Groupings
4.5 Formatting Data
4.6 Sending Data to Quattro Pro
4.7 Hot Links
5.0 Power Functions (35 min)
5.1 The IF Function
5.2 Using AND & OR in Formulas
5.3 Calculating Customer Payments
5.4 Calculating Loan Payments
Power Features Video (1 hr 45 min)
1.0 Charting Your Spreadsheet Data (24 min)
1.1 Inserting a Chart
1.2 Changing the Chart Type
1.3 The Chart Gallery and Advisor
1.4 Modifying Chart Titles
1.5 Modifying a Chart Series
1.6 Changing the Properties of Chart Objects
1.7 Inserting Graphics and Shapes
1.8 Inserting a Spreadsheet Range
1.9 Printing the Chart
2.0 Creating Maps (15 min)
2.1 Inserting a Map
2.2 Changing the Map Data Range
2.3 Working with Overlays
2.4 Applying Colors and Other Attributes
2.5 Modifying Titles and Title Properties
2.6 The Map Expert
3.0 Enhancing Your Workbooks with Objects (18 min)
3.1 Inserting Images &OLE Objects
3.2 The Objects Page
3.3 Placing Notebook Data in a Word Processing Document
4.0 Presenting Your Data with a Slide Show (13 min)
4.1 Creating a Slide Show
4.2 Adding Transitions
4.3 Working with the Master Slide
4.4 Modifying Slide Properties
5.0 Getting Help from the Experts (15 min)
5.1 The Analysis Expert
5.2 The Budget Expert
5.3 The Slide Show Expert
6.0 Macros (9 min)
6.1 Recording a Macro
6.2 Naming & Playing a Macro
6.3 Using a QuickButton to Execute a Macro
7.0 Working with the Internet (9 min)
7.1 Saving Your Notebook Data as HTML
7.2 Using a QuickButton to Access the Internet
|
