Name:     ID: 
 
Email: 

MS Excel skills questionnaire

This questionnaire has been designed using SSL encryption - a protocol which submits private documents and information via a secure internet connection.
Multiple Response
Identify one or more choices that best complete the statement or answer the question.
 

 1. 
What are the main functions you use / want to use Excel for?
 a.
Create simple reports
 d.
Perform calculations
 b.
Display information using charts
 e.
Manipulate and consolidate large data lists
 c.
Analyse finance information
 

 2. 
Select what you feel confident using in Excel:
 a.
Insert and adjust column and row sizes
 e.
Adjust print areas, margins and fit spreadsheets to the page correctly
 b.
Format text such as the colour, bold and italic
 f.
Create a new worksheet within an existing workbook
 c.
Format numbers to display them as currency, dates, percentages and decimals.
 g.
Use the autofill for text, numbers and formatting
 d.
Align text to fit correctly in cells
 h.
Work with formulas such as addition, multiplication and division including working with the functions bar.
 

 3. 
Select what you feel confident using in Excel:
 a.
Calculate across multiple worksheets
 e.
Use IF, OR and AND functions
 b.
Adjust borders and shading
 f.
Create complex formulas by nesting multiple functions together
 c.
Use the SUM, MAX, MIN, and AVERAGE
 g.
Create and edit named ranges
 d.
Work with headers and footers including adding auto text such as page numbers and the file name
 h.
Use the autofilter to sort and filter lists including setting criteria
 

 4. 
Select what you feel confident using in Excel:
 a.
Create and Format Charts
 e.
Use Goal Seek, Solver and Scenarios
 b.
Apply Conditional Formatting
 f.
Consolidate data from multiple worksheets, link and import/export
 c.
Protect cells and validate data
 g.
Create and edit pivot tables and pivot charts
 d.
Use VLookup Functions
 h.
Create and edit macros
 

 5. 
What level of Excel do you want to attend / are you attending?
 a.
Introduction
 c.
Advanced
 b.
Intermediate
 d.
VBA
 

Yes/No
Indicate whether you agree with the statement.
 

 6. 
Have you attended Excel training before?
 

Completion
Complete each statement.
 

 7. 
List the top 3 things you want to learn from the training
 

 

 8. 
Have you attended Excel training before? Yes - type the level below (intro, interm, adv)
Introduction
Intermediate
Advanced
VBA
 

 



 
         Start Over