Creative Ways to use Excel

A spreadsheet of my construction showing how n...

Image via Wikipedia

Okay, so you may know the basics about Excel; how to use spreadsheets, how to calculate your budget, how to make a list of potential clients with phone numbers and addresses.

What you do not know comes in the way of creation and less on the technical side of counting it all up. And what is out there may surprise you.

Here’s a list to get you going:

  1. Make a “story web” to help organize your thoughts for your next school paper or business project.
  2. Create a quiz. A great step-by-step instruction list can be found here: http://www.ehow.com/how_2257544_create-quiz-excel.html.
  3. Use Smart Art. Make a family tree. Genealogy or family history is all the rage now and encourages family members of all ages to search out their ancestors.
  4. Draw freehand. Choose “scribble” or “curve” from a list of choices. Use your freehand drawing in a power point presentation or slide show.
  5. Import pictures from two sources, either from Clipart Gallery or from Pictures. Use these photos to create your own poster gallery or for use on presentation day.
  6. Create a review came for your class with the Classroom Jeopardy Template. Content can be changed within the template to suit the subject matter.
  7. Create a crossword puzzle. Use it for classroom study or for family fun or learning time. When the last time you found a puzzle that had you find all the reasons to keep a room clean, or what steps are included in the cleaning process, for example?
  8. Synthesize some music. Notes are plotted on a spreadsheet and an instrument is chosen. Hours of fun and learning!
  9. Play Battleship or Stones of Power. Excel offers about 15 games to choose from. Get a list of them here: http://www.clickonf5.org/freebies/14-cool-games-play-microsoft-excel/6251.
  10. Calculate your driving time and distance. Watch this YouTube video to learn how: http://www.youtube.com/watch?v=ZPbR92aMB-8.
  11. Learning more about zip codes. Track your customers, find zip codes within a particular radius, and profile your customers using demographic data.

When it comes to being creative in Excel, the options are endless. The biggest problem? Knowing what to try first!

Speak Your Mind

*


*