Self Test #4:
Getting the Most from Excel
| 1. I am comfortable using standard formulas and functions. |
|
| 2. I always work from templates, and then save modified files with a specific name. | |
| 3. I use Excel to create all or most of my company forms. | |
| 4. I augment the power of other programs (such as my accounting software) by exporting to and creating additional reports in Excel. |
|
| 5. I always imbed error-checking features such as logical if statements or conditional formatting to reduce the corruption potential of my Excel files. | |
| 6. I employ worksheet or workbook protection to reduce accidental user error within my Excel files. | |
| 7. I use color and font consistently within different worksheets, to create continuity. | |
| 8. I use lists, V Lookups, drop-downs, and other means of reducing user input errors. | |
| 9. I know how to embed URL's for quick access to websites from within Excel. | |
| 10. I know how to use links between worksheets and spreadsheets to produce a simplified view of complex data. |
Scoring Your Results
Count 1 point for every statement that's TRUE about your company.
Is anything less than 12 good enough?
If not, check out these services offered by BSM:
Excel Training