Smart data entryOne Excel programmer created a spreadsheet for the marketing department. They could copy and paste entries from phone directory websites into the sheet, and a macro would automatically parse the important data from the entry and create prospect lists. These lists could be imported into the company's database without errors that might have been introduced through traditional data entry.
An Excel training course will illustrate many techniques that can reduce errors from data entry. Cells can be restricted to certain ranges or data types, other cells can be locked out so users can't accidentally change them, and macros can automatically process any new data found.
Task trackingExcel might seem like overkill for a to-do list, but an Excel training course can add a new dimension. Many people use Excel to create a list of quantifiable tasks along with a due date. This allows them to track the percentage of a task that should be complete by a given date so they know how much work needs to be accomplished to stay on track.
What movie should I see?One self-described "nerdy and obsessive" woman created charts of all movies that she wanted to see, colour coded by the price she was willing to pay for tickets. Her friends could contribute their opinions, and she could create a weighted score to plan their movie nights. An Excel training course can illustrate the database and conditional formatting functions that such a spreadsheet would require.
This is my son, #N/AAn Excel training course can name your child. One couple created a spreadsheet that used objective metrics to find the best name for their son. They rated all their choices by factors from how the name sounded compared to their first son's name, to what his initials would spell. In the end, they ignored the results and went with their gut reaction.
Looking for loveFinally, there is the young man who set up a database of the women he met. By using the filtering and sorting techniques you could learn in an Excel training course, he was able to create a spreadsheet which would objectively tell him which women were worthy of his interest.
And people think romance is dead.