Provided by: 123-CBT Computer Based Training Quattro Pro 9 Advanced Click here for more information or to take this course

---

---

Training Provided by 123-CBT Computer Based Training

CENTER">

 Lesson1: Introduction, Opening Quattro Pro 9, Inserting Images, Removing The Border From An Inserted Image, Inserting An Arrow Shape, Changing The Properties Of A Shape, Inserting TextArt, Inserting A Rounded Rectangle Shape, Changing The Order Of Objects, Adding A Chart Using The Chart Expert, Naming The X And Y Axis Of A Chart, The Objects Sheet, Viewing Slides, Inserting OLE Objects, Exploring Maps

Lesson 2: Introduction, Opening An Existing File, @IF Function, Nested @IF Functions, Logical Operators, @FORECAST Function, Calculating Trends, Using Solve For, Creating A Scenario, Displaying A Scenario, Creating A Scenario Report, Entering An Optimizer Constraint, Creating An Optimizer Report., Auditing A Spreadsheet, Trace Precedents, Trace Dependents

Lesson 3: Introduction, Opening An Existing File, @VLOOKUP Function, @VLOOKUP - First Argument, Applying @VLOOKUP To Multiple Cells, @VLOOKUP - Fourth Argument, @HLOOKUP Function, @MAXLOOKUP And @MINLOOKUP Function, @MINLOOKUP Function, What-If Tables, One-Variable What-If Table, Selecting Table Range, The Input Cell, Using The What-If Expert, The Invoking Expert, Expert - Formula Cell, Expert - Input Cell, Table Cells, Two Variable What-If Tables, Row Input Cell

Lesson 4: Introduction, Opening An Existing Document, Writing A Macro Script, Using The {IF} Command In Macros, Attaching A Macro To A QuickButton, Attaching A Macro To A RadioButton, Opening The Visual Basic Editor, Inserting A Userform, Adding A Label Control To A Userform, Changing The Properties Of A Label Control, Adding A Command Button Control To A Userform, Changing The Properties Of A Command Button, Opening The Code Module Of A Userform, Adding Code For A Userform, Adding Code For A Class Module, Control Screen Display While Playing Macros, Playing A VBA Macro, Using A VBA Macro To Control Data

Lesson 5: Introduction, Creating A Custom Menu, Creating A Custom Toolbar, Removing A Menu From Menu Bar, Hiding A Toolbar, Inserting A Comment, Deleting A Comment, Using Workgroup Functions, Sharing A Notebook, Viewing A User List, Updating Notebooks, Resolving Conflicts In A Shared Notebook, Removing Shared Properties Of A Notebook, Comparing Notebooks, Creating An HTML Spreadsheet, Viewing HTML Pages, Creating A Web Query, Running a Web Query, Adding Custom Buttons, Creating A Dialog Box, Auto-executing A Macro, Attaching A Macro To A Button, Playing A Startup Macro When Opening A Notebook

Training Avaliability and Delivery

This is primarily cdrom training This program may be available on CD Contact 123-CBT Computer Based Training for more information

Training Presented in: English

About 123-CBT Computer Based Training - Training Provider

More Corel Quattro Pro 9 Training from 123-CBT Computer Based Training

• Quattro Pro 9 Intermediate
• Quattro Pro 9 Introduction
• Quattro Pro 9 Training Suite