White Papers by Dick Evans
White  Papers on Microsoft Excel 2007

by Dick Evans

  1. A Combo Box with a Two Dimensional Array

  2. A Spinner Control Referencing an Array

  3. Spinner Control with Decimals

  4. Adding a Spinner Control

  5. Adding Style to a Worksheet

  6. Age Calculation

  7. AgeFunc Function

  8. Auto Fit Column Width

  9. Converting Data in Excel

  10. Counting Some of the Cells

  11. Counting

  12. Creating a Dropdown List

  13. Custom Lists

  14. Data Entry Form

  15. Date Calculation Overview

  16. Display Numbers as Text

  17. Divide by Zero Errors

  18. Entering Data with Forms

  19. Evans Excel Conventions

  20. Excel autoformat

  21. Excel Conventions Check List

  22. Excel Nevers

  23. Excel Tips

  24. Format Excel Date within Text

  25. Formatting Numeric Merged Fields in Word

  26. Multiple Worksheets

  27. Named Ranges

  28. Nesting IF Statements

  29. Overview excel

  30. Parsing Names

  31. Password Protection

  32. Pasting Data into an Excel Worksheet

  33. Percentage Explained

  34. Pivot Tables

  35. Practical Stuff in Excel

  36. Problem Solving

  37. Rounding

  38. Shortcut keys

  39. Sorting in Excel

  40. Sorting Multiple Columns

  41. The Developer Tab

  42. The IF Function

  43. The Scroll Bar Control

  44. To SUM or not to SUM

  45. Two Way Lookups

  46. Using a Check Box

  47. Using a List Box

  48. Using Option Buttons

  49. Using Table Style to Format

  50. Using the Built In Dropdown List

  51. Using the Thesaurus

  52. Workspaces Dropdown Lists and VLOOKUP