Assess Your Skills

Microsoft Excel 2007 Level 3 Skills Assessment

This class is designed for the experienced Excel user.  Participants will learn conditional formatting and data validation techniques and functions and will learn how to protect the data and structure of worksheets and workbooks.  The class covers exporting data from Excel to Word, using PivotTables, and the fundamentals of creating and using Macros.  The class covers macro security issues, and teaches participants to configure Excel for working safely with macros.

Course prerequisites:  Excel Level 2 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 formulas and should be familiar with Excel features such as Tables, Named Ranges, and Data Filters.   

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

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

Add, remove, and arrange commands on the Quick Access Toolbar?
Yes No Unsure

Insert and format dates, and use dates in formulas?
Yes No Unsure

Create a Table and apply style formatting to a Table?
Yes No Unsure

Use the SUBTOTAL function together with filters to analyze data in a Table?
Yes No Unsure

 Use Table and Table Field names in formulas?
Yes No Unsure

Create Named Ranges and use them in formulas?
Yes No Unsure

Use the IF function in a formula?
Yes No Unsure

Use the VLOOKUP function to find an exact match?
Yes No Unsure

Use the VLOOKUP function to find an approximate match?
Yes No Unsure

Create a complex formula using two or more Nested Functions?
Yes No Unsure

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

Hide and unhide rows, columns, and worksheets?
Yes No Unsure

Use links in formulas to different worksheets and different workbooks?
Yes No Unsure Advanced Filters with multiple filter criteria?

 

  Your score:

If your score is 12 or greater, you are probably ready to attend our Microsoft Excel 2007 Level 3 class.  Eleven or fewer?  We suggest you attend our Excel Level 2 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.

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