| If you read "Fun Things I've Done With Excel", | | | | colour coded by the price she was willing to pay for |
| you've seen some examples of how an Excel training | | | | tickets. Her friends could contribute their opinions, and |
| course can expand your horizons and give you new | | | | she could create a weighted score to plan their |
| ideas for Excel tasks. However, I'm apparently pretty | | | | movie nights. An Excel training course can illustrate |
| sane by comparison. Consider some examples of | | | | the database and conditional formatting functions |
| what other people have done with Excel, from the | | | | that such a spreadsheet would require. |
| normal to the strange. | | | | This is my son, #N/A |
| Smart data entry | | | | An Excel training course can name your child. One |
| One Excel programmer created a spreadsheet for | | | | couple created a spreadsheet that used objective |
| the marketing department. They could copy and | | | | metrics to find the best name for their son. They |
| paste entries from phone directory websites into the | | | | rated all their choices by factors from how the name |
| sheet, and a macro would automatically parse the | | | | sounded compared to their first son's name, to what |
| important data from the entry and create prospect | | | | his initials would spell. In the end, they ignored the |
| lists. These lists could be imported into the company's | | | | results and went with their gut reaction. |
| database without errors that might have been | | | | Looking for love |
| introduced through traditional data entry. | | | | Finally, there is the young man who set up a |
| An Excel training course will illustrate many techniques | | | | database of the women he met. By using the filtering |
| that can reduce errors from data entry. Cells can be | | | | and sorting techniques you could learn in an Excel |
| restricted to certain ranges or data types, other cells | | | | training course, he was able to create a spreadsheet |
| can be locked out so users can't accidentally change | | | | which would objectively tell him which women were |
| them, and macros can automatically process any new | | | | worthy of his interest. |
| data found. | | | | And people think romance is dead. |
| Task tracking | | | | An Excel training course lets you take your |
| Excel might seem like overkill for a to-do list, but an | | | | spreadsheet to its limits |
| Excel training course can add a new dimension. Many | | | | There are countless other examples, including |
| people use Excel to create a list of quantifiable tasks | | | | shopping lists generated from a recipe database, a |
| along with a due date. This allows them to track the | | | | functioning version of PacMan, solvers for |
| percentage of a task that should be complete by a | | | | cryptograms and sudoku puzzles, wedding planners, |
| given date so they know how much work needs to | | | | dance choreography, and timing of labour |
| be accomplished to stay on track. | | | | contractions. You probably won't learn any of these |
| What movie should I see? | | | | in an Excel training course, but you just might find |
| One self-described "nerdy and obsessive" woman | | | | techniques that let you do your own fun things. |
| created charts of all movies that she wanted to see, | | | | |