 |
Our course is loaded
with general information on each of these topics, covering the basics and
providing more advanced information for individuals already familiar with
this subject. The course is supported
with numerous tips, examples, and interactive questions to help you
understand this subject and includes a
special "Bookmark" feature so you can learn at your own pace.
TOPICS COVERED
Unit 1: Using What-If Analysis
Defining a What-If Analysis
Tracking a What-If Analysis with Scenario Manager
Generating a Scenario Summary
Projecting Figures Using a Data Table
Creating a Two-Input Data Table
Using Goal Seek
Setting Up a Complex What-If Analysis with Solver
Running Solver and Generating an Answer Report
Practice
Unit 2: Summarizing Data with PivotTables
Planning and Designing a PivotTable Report
Creating a PivotTable Report
Changing the Summary Function of Pivot Table Reports
Analyzing Three-Dimensional Data
Updating a PivotTable Report
Changing the Structure/Format of a PivotTable Report
Creating a PivotChart Report
Using the GETPIVOTDATA Function
Practice
Unit 3: Exchanging Data With Other Programs
Planning a Data Exchange
Importing a Text File
Importing a Database Table
Inserting a Graphic File in a Worksheet
Embedding a Worksheet
Linking a Worksheet to Another Program
Pasting an Excel Chart into a PowerPoint Slide
Converting a List to an Access Table
Practice
Unit 4: Gaining Control Over Your Work
Finding Files
Auditing a Worksheet
Outlining a Worksheet
Controlling Worksheet Calculations
Creating Custom AutoFill Lists
Customizing Excel
Adding a Comment to a Cell
Saving a Workbook as a Template
Practice
Unit 5: Programming with Excel
Viewing VBA Code
Analyzing VBA Code
Writing VBA Code
Adding a Conditional Statement
Prompting the User for Data
Debugging a Macro
Creating a Main Procedure
Running a Main Procedure
Practice
This self-paced Program is available from any browser, and is accessible
for one full year from date of purchase.
|
Item |
Course |
|
Individual Course Cost |
$30.00 |
| |
 |
Credencia e-Learning courses are designed to
function under the following minimum computer standards. Please be sure
that your computer meets these minimum standards:
- Internet Explorer version 5.5 or higher
- Windows Media Player version 6.4 or higher
- A minimum connection speed of a 56K modem is required,
but higher speed connections are better for viewing.
- Your computer must have the ability to play audio,
with speakers or headset attached
Depending on the speed of your modem connection, the download time may take a few minutes to view the presentation.
|
|
