|
Excel Advanced Level Training
We would like to provide some training on Excel. This short survey is designed to help gauge interest and content requirements . The results of the survey will be used to plan sessions for the Autumn term. If you have any questions please ask either Vince Holmes or Sharon Jeffs.
This survey covers the more advanced features of Excel, and should be completed after the Introduction Level survey. Thank you for completing the survey.
|
| |
|
|
|
* Can you set up Named Ranges of cells? |
| |
|
|
|
|
* Can you set the scope of a range name? |
| |
|
|
|
|
* Can you use the range name manager? |
| |
|
|
|
|
* Can you use range names in formulae? |
| |
|
|
|
|
* Can you link worksheets with formulae? |
| |
|
|
|
|
* Can you link workbooks? |
| |
|
|
|
|
* Do you know how to view links? |
| |
|
|
|
|
* Can you use basic conditional functions? |
| |
|
|
|
|
* Can you use nested IF functions? |
| |
|
|
|
|
* Can you use SUMIF and COUNTIF? |
| |
|
|
|
|
* Can you use VLOOKUP and HLOOKUP? |
| |
|
|
|
|
* Can you set up conditional formatting? |
| |
|
|
|
|
* Can you use the built-in conditional formatting? |
| |
|
|
|
|
* Can you use the data validation feature? |
| |
|
|
|
|
* Can you find invalid data? |
| |
|
|
|
|
|
|
* Can you insert subtotals? |
| |
|
|
|
|
|
|
* Do you know how to remove duplicates? |
| |
|
|
|
|
* Can you create a pivot table? |
| |
|
|
|
|
* Can you modify a pivot table? |
| |
|
|
|
|
* Can you create a chart from a pivot table? |
| |
|
|
|
|
* Can you use outlining to group columns and rows? |
| |
|
|
|
|
* Can you use auto outline? |
| |
|
|
|