2007Ó Integrity Computer Solutions.
The
Learning Laboratory
innovate results trust
ABN: 94 081 457 454
11th Floor
Adelaide Bank Building
90 King William Street
ADELAIDE SA 5000
Tel. 1300 731 451
Fax. (08) 8231 2427
www.learnlab.com.au
labinfo@learnlab.com.au
Integrity
Training Solutions
innovate results trust
ABN: 58 309 252 680
Suite 2, Level 1
902 Mt Alexander Road
Essendon VIC 3040
Tel. 1300 731 451
Fax. (03) 9372 9382
www.integritytrainingsolutions.com
info@integritytrainingsolutions.com
A division of...
Microsoft Excel Advanced - Course Outline
Duration
1 day Course
Course Aims
To assist the user to become more proficient in Excels advanced data analysis, formatting and handling capabilities.
Learning Outcomes
Upon completion of this course the participant will be able to:
understand and use arrays apply "what if" analysis tools
consolidate data create charts using advanced techniques
understand statistical functions create a basic macro
Training Method
Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.
Prerequisite
Excel Intermediate course or the equivalent amount of experience using Excel.
Course Content
Arrays
Creating an Array Formula Selecting and Editing an Array
Outlining Creating an Automatic Outline
Hiding/Showing Detail Removing an Outline
Changing the Outlining Default Settings
Data Consolidation
Consolidating Workbooks Consolidating Worksheets in a Workbook
Advanced Database Features
Database Functions Pivot Table Reports
Data Tables
One Input Data Table Two Input Data Table
Scenario Manager
Overview Creating and Deleting a Scenario
Editing and Showing a Scenario Scenario Reports
Custom Views
Adding and Deleting a Custom View Showing a Custom View
Print Reports
Creating a Print Report Editing an Existing Print Report
Printing a Print Report Deleting a Print Report
Solver and Goal Seek
Overview Goal Seek
Solver Report Results
Save Scenario Resetting Scenario
About the Solver Options Dialog Box Advanced Charting
Editing an Existing Series of Data Adding an Extra Series of Data to an Existing Chart
Deleting an Existing Series Changing Chart Values
Changing the Way Data is Plotted Changing the Scaling
Inserting Trend Lines Combining Chart Types
Macros
Understanding Macros Recording a Macro
Running a Macro Understanding Macro Code
Adding Comments to a Macro
Statistics*
Installing the Analysis Toolpak Rank and Percentile
Descriptive Statistics Other Statistical Abilities
*Statistics are only included time and participant interest permitting. Statistics are not covered at all in the standard Advanced Excel XP course.