- #MICROSOFT EXCEL 2007 POWER USER ASSESSMENT HOW TO#
- #MICROSOFT EXCEL 2007 POWER USER ASSESSMENT FREE#
Many of the pages point to the same resources. Here are several places you can go to find help.
#MICROSOFT EXCEL 2007 POWER USER ASSESSMENT FREE#
It has links to over 450 free online MS Office 2013 Courses The link to this spreadsheet is in the Office 365 Adoption Kit. They include tests at the end of each unit. The 365 Adoption Kit has a spreadsheet with links to some MS training courses. For example, you could search for "Excel proficiency tests charts" or "Excel proficiency tests PivotTables."įinally, here are some specific resources pointed out by some ExcelTips subscribers: Search terms that reflect the specific skills you want to test. If you want to limit the results further, add additional For instance, you might search for "Excel proficiency tests" (without the quote marks). If you prefer to not develop your own proficiency test, you should try doing a search on Google for what you need. You might even provide a question or two that direct the user to create a worksheet to solve the question. An example would be to create a worksheet that has assorted raw data and then ask the user to do something Indicate how well someone does at creating pie charts, but may not do well on PivotTables, lookup formulas, or conditional formatting.īecause the number of things you can do with Excel is so large, many people develop their own in-house tests that, again, are geared toward specific tasks. Excel is a tool you can use to accomplish some tasks, but it isn't a task itself. Proficiency tests are designed to measure how well someone does at a certain task. The short answer is that it depends-on lots of things. Mark needs to determine someone's proficiency with Excel and is wondering if there are any tests available that can run without the installation of any special software, macros, flash, or the like. Summary: Need to figure out how good someone is with Excel? You need what is commonly called a "proficiency test." Here's the low-down on what is available and what you can do to make your determination. Here is the reply to the same question that was provided by this site: They have lots of good resources and many "experts" responding to questions You can "steal" test question ideas from them.Īsk this question at the "Chandoo" site. Some include pretests, many include post tests.
#MICROSOFT EXCEL 2007 POWER USER ASSESSMENT HOW TO#
The "practical" test will include allowing them to use online help to find specific answers, demonstrating they know how to look for answers. Is this going to be a "paper only" test, or a "hands on" / practical test spreadsheet they can use Excel in to demonstrate. What specific skills you you actually use in your setting? How do you define "proficiency? Proficiency at what: Version specific features or just general spreadsheet skills?