| |
| * Required Fields |
| |
Please select a button for each task or feature. If you are competent
and completely happy with a task or feature, then select the "Yes"
button. If you are not, or not sure, then select the "No" button. If you
do not need a feature and want us to ignore it, then select the "Not
needed" button.
When complete, click the "Send to the
Learning Ladder" button. Thank you. |
| |
| Task or feature |
Yes |
No |
Not needed |
| |
|
|
|
| Starting Out |
|
|
|
| About Workbooks |
|
|
|
| Exploring Your Workbook |
|
|
|
| Getting Help in Excel 2007 |
|
|
|
| |
|
|
|
| The Quick Access Toolbar |
|
|
|
| The Home Ribbon |
|
|
|
| The Insert Ribbon |
|
|
|
| The Page Layout Ribbon |
|
|
|
| The Formula Ribbon |
|
|
|
| The Data Ribbon |
|
|
|
| The Review Ribbon |
|
|
|
| |
|
|
|
| Working with Excel 2007 |
|
|
|
| Basic Excel Features |
|
|
|
| Moving your Data |
|
|
|
| Smart Tags and Options Buttons |
|
|
|
| Editing Tools |
|
|
|
| |
|
|
|
| Modifying Cells and Data |
|
|
|
| Cell Formatting |
|
|
|
| Enhancing a Worksheet |
|
|
|
| Conditional Formatting |
|
|
|
| |
|
|
|
| Using the View Ribbon |
|
|
|
| Managing a Single Window |
|
|
|
| Managing Multiple Windows |
|
|
|
| Printing your Workbook |
|
|
|
| |
|
|
|
| Using My Computer within Excel |
|
|
|
| Saving Your Files |
|
|
|
| Using Templates |
|
|
|
| |
|
|
|
| Using Formulas in Excel |
|
|
|
| Exploring Excel Functions |
|
|
|
| Using Functions in Excel |
|
|
|
| Working with Names and Ranges |
|
|
|
| Working with Array Formulas |
|
|
|
| Text Functions: CONCATENATE, LEFT/RIGHT, UPPER/LOWER/PROPER |
|
|
|
| |
|
|
|
| Working with Tables |
|
|
|
| Working with Records and Fields |
|
|
|
| Working with Tables and Filters |
|
|
|
| Using Excel as a Database |
|
|
|
| |
|
|
|
| Customizing your Workbook |
|
|
|
| Working with Text Boxes |
|
|
|
| WordArt |
|
|
|
| ClipArt |
|
|
|
| Using Objects |
|
|
|
| |
|
|
|
| Protecting your Workbook |
|
|
|
| Finishing your Workbook |
|
|
|
| Using Excel in Word |
|
|
|
| Using Excel and Access |
|
|
|
| Using Excel with other Programs and Files |
|
|
|
| |
|
|
|
| Working with Charts Basics |
|
|
|
| More about Working with Charts |
|
|
|
| |
|
|
|
| Setting Excel Options |
|
|
|
| Excel and Windows |
|
|
|
| Using the Excel Viewer |
|
|
|
| |
|
|
|
| Getting the Most from your Data |
|
|
|
| PivotTables |
|
|
|
| More About PivotTables |
|
|
|
| Exploring Scenarios |
|
|
|
| What If Analysis |
|
|
|
| |
|
|
|
| Excel and Hyperlinks |
|
|
|
| Saving Workbooks as Web Pages |
|
|
|
| Getting Data from the Internet |
|
|
|
| |
|
|
|
| Creating and Using Shared Workbooks |
|
|
|
| Using Custom AutoFill Lists |
|
|
|
| Using the VLOOKUP and HLOOKUP Functions |
|
|
|
| Linking, Consolodating, and Combining Workbooks |
|
|
|
| |
|
|
|
| Create a Macro with the Macro Recorder |
|
|
|
| Edit a Macro |
|
|
|
| Debug a Macro |
|
|
|
| Customize the Quick Access Toolbar and Hotkeys |
|
|
|
| Work with Macro Security |
|
|
|
| |
|
|
|
| Insert Text |
|
|
|
| Format Text |
|
|
|
| Sort Data |
|
|
|
| Duplicate Data |
|
|
|
| Generate a Report |
|
|
|
| |
|
|
|
| Determine the Dialog Box Type |
|
|
|
| Capture User Input |
|
|
|
| |
|
|
|
| Insert, Copy, and Delete Worksheets |
|
|
|
| Rename Worksheets |
|
|
|
| Modify the Order of Worksheets |
|
|
|
| Print Worksheets |
|
|
|
| |
|
|
|
| Create User-Defined Functions |
|
|
|
| Automate SUM Functions |
|
|
|
