This free survey is powered by
  1. Surveys
  2. 2014
  3. September
  4. E
  5. Excel Skills Assessment
0%
Exit Survey
 
 
The Excel Skills Assessment will be use to discover the average level of knowledge in Microsoft Excel. The results will be the main resource to determine which topics needs to be reinforced. The information attained will be use to create a customized training that will meet the learning needs of the group. 

Thanks for your collaboration.
 
 
Please rate your knowledge based on these basic excel skills:
None Slight Considerable Great
Create worksheets and workbooks
Format worksheets and workbooks
Insert and format Data in cells and ranges
Order and group cells and ranges
Create and modify a table
Filter and sort a table
Utilize cell ranges and references in formulas and functions
Use functions like AUTOSUM, SUM, MIN, MAX, COUNT, Average
Modify Page Layout
Create and format a chart
Insert and format an object
 
 
Please rate your knowledge based on these intermediate excel skills:
None Slight Considerable Great
Look up data using Conditional Formatting
Create a new Conditional Formatting rule
Format text with TRIM, UPPER, CONCATENATE functions
Create custom AutoFilter
Define a name for a range or cells
Remove duplicate cells
Use Split window options
Use Freeze/Unfreeze headings
Work with multiple worksheets
Group/ Ungroup data
Add images, SmartArt, cliparts
Work with data lists
 
 
Please rate your knowledge based on these advanced excel skills:
None Slight Considerable Great
Create conditional format formula-SUMIF
Create a look up formula -VLOOKUP, HLOOKUP
Create conditional logic formula - IF, Nested IF's
Calculate difference between date or times
Define a name for a range or cells
Create a Pivot Table
Create Macros
Create a drop-down list
Add data validation to a worksheet
Add Password protection
Lock and unlock cells
 
 
 
Related to Excel, Please share any specific topic you would like to learn.
   
 
 
 
Please provide Comments/Suggestions for future educational projects: