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 - Training Needs Analysis
This Questionnaire is designed to assess which training course will best suit your needs. Please indicate which box best describes your level of competence with each of the functions listed. The Questionnaire will be most useful if you answer as openly as possible.
You will receive an email with our recommendation(s) for the course(s) best suited to your current skill level, based on the findings from this questionnaire.
* Name and email are required fields.
Name
Company
Email
Phone
N/A = Not Applicable Are you Competent? Y = Yes N = No
Topic
N/A Y N
Excel Basics
Using a Mouse
Identifying Parts of the Screen
Using Pull down Menus
Working with Dialog Boxes
Working with Files
Opening a Workbook
Using a Workbook
Saving to a Floppy Disk
Using Save As
Closing a Workbook
Basic Worksheet Skills
Entering and Editing Data
Deleting Data
Move and Copy
Basic Formula Building
Formatting Data
Range Names
Working with Dates
Borders and Shading
Customising Excel
Screen Display Customisation
Customising User Options
Customising Standard Toolbars
Creating New Toolbars
Adding Simple Macros to Toolbars
Printing
Print Settings
Printing Large Worksheets
Print Using Print Titles, Page
Breaks and Print Ranges
Printing using Views and Reports
Formulas
Building Formulas
Absolute and Relative Cell References
BODMAS
Copying a Formula
Linked Formulas
Functions
Using the Inbuilt Functions
Financial Functions
Designing your own Functions
Charts
Creating a Chart using the Chart Wizard
Editing charts
Adding Objects to charts
Advanced chart Features
Database Functions
Sorting Data
Finding, Extracting and Deleting Data
Automatic Sub Total
Database Functions
Pivot Table
Multiple Worksheets
Managing Multiple Worksheets
Data Consolidation
Linking Data
Group Edit
Outline
Creating an Outline
Editing and Managing an Outlined Worksheet
Styles and Templates
Using Styles
Merging Styles from Another Workbook
AutoTemplates
Special Effects
Inserting a Picture
Inserting a WordArt
Dynamic Data Exchange
What If Analysis
Data Tables
Goal Seek
Scenario Manager
Solver
Macros
Recording Macros
Attaching Macros to Tools and Buttons
Global Macros
Macro Development using Visual Basic
File Management
Creating Directories
Using Find File to Preview and Open Files
Using Find File to Search for Files
Adding a Password to Files
Removing a Password
N/A Y N
Any Other Comments