Assess Your Skills

Microsoft Excel 2007 Level 2 Skills Assessment

This class is designed for people familiar with Excel 2007 who need to go beyond the basics.  Participants will learn to create and use complex formulas, define and name tables and ranges, and to create basic pivot tables.  The class covers linking and consolidation of multiple worksheets and workbooks.  The class also covers using Auto Filters and Advanced Filters for analyzing datasets.

Course prerequisites:  Excel Level 1 or equivalent experience.  Participants should have direct experience working with the Excel 2007 user interface.  Participants should know how to use common Excel functions in basic formulas and should be able to create workbooks, enter and format data, insert worksheets and perform similar basic tasks.

Read each question below. Being honest with yourself, evaluate your current level of knowledge and experience.

  • Choose “Yes” if you can confidently perform the activity.
  • Check “No” if you can’t perform the activity
  • Check “Unsure” if you don’t understand the questions or only have a vague idea about what’s being asked.
  • After you answer all of the questions, click on the calculate button to receive your score.

Can you confidently:

Yes No Unsure
Enter text and numbers in worksheet cells?
Yes No Unsure

Format cells using the Ribbon, the Mini-toolbar, and the Format Cells dialog box?
Yes No Unsure

Add inside and outside borders to a range of cells?
Yes No Unsure

Select a single column or row as well as multiple columns or rows?
Yes No Unsure Insert and remove rows and columns?
Yes No Unsure

Change a column's width and a row's height?
Yes No Unsure

Create simple formulas?
Yes No Unsure

Copy formulas using the cell AutoFill handle?
Yes No Unsure

Tell the difference between an absolute cell reference and a relative cell reference?
Yes No Unsure

Create formulas using the SUM() function?
Yes No Unsure

Use the AutoCalculate feature to sum, count, and average a numeric selection?
Yes No Unsure

Copy- or cut-and-paste cell contents within a worksheet and between worksheets?
Yes No Unsure

Use the [CTRL] key with the [HOME], [END] and Arrow keys to navigate within a worksheet?
Yes No Unsure

Set up a report's header and footer using the Page Layout View?
Yes No Unsure

Create a simple column chart?

 

  Your score:

If your score is 12 or greater, you are probably ready to attend our Microsoft Excel 2007 Level 2 class.  Eleven or fewer?  We suggest you attend our Excel Level 1 class first.  If you're experienced with an earlier version of Excel and just want to learn the new Excel 2007 user interface and other new features, consider attending our Excel 2007 Transition class.

If you are still unsure about which level of training is best for you, please feel free to give us a call and we can have you talk directly to one of our instructors. You can reach us at 408-261-2600. 

 
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600