Home » Computers » Software

Fun Things I've Done With Excel

Aug 30, 2007
Microsoft Excel might just be the most versatile application ever created. If you are still using Excel just for number crunching, a MS Excel course can open up a whole new world of possibilities. Let me give you just a few examples of some of the offbeat ways, both at work and at home, I have used Excel over the years.

Numerical solution of differential equations
A Microsoft Excel course can introduce you to macros which can allow you to take calculations to the next level-to the point of writing your own statistical functions. However, Excel macros are written in a language that is interpreted rather than compiled (for you non-programmers out there, read that as "slow rather than fast") so complex numerical models seem impossible.

I used to use a complex numerical code to model contaminant transport in groundwater. The calculations were fast, but it was clumsy to get data in and out of the applications. A MS course had turned me on to macros, and I realized that I could call this fast code from a macro by turning it into a DLL. The Excel interface provided an easy way to create scenarios, to view the data, and to tweak on settings to see how the model changed. The compiled code provided fast results that Excel couldn't match. The combination created a powerful and unique tool.

Wine tasting
I've recently become a bit of an oenophile, and I've started a database of wines I've tasted. I track wines by type, country, vineyard, and year. As the information grows, I examine trends. I've noticed my highest rated wines are generally Australian, something I might not have otherwise noticed.

An Excel course will illustrate techniques in sorting and filtering that allows you to pull important kernels of information out of a mass of data.

Computer game statistics
I am an avid computer gamer and Excel has been a vital tool. I can provide complex demographic data on my population in The Sims 2. I can calculate engine efficiency of the different locomotives in Railroad Tycoon 3. In Oblivion I can track quests, merchant prices, and trainers.

I can also list my alchemical ingredients and have it tell me which potions I can make. I can track the changing economy in Sid Meier's Pirates, color coding prices so I can easily see the best ports to sell my plunder. A course in Excel can teach you about features such as conditional formatting or database functions that make these kinds of workbooks possible.

Learn more fun uses from a Microsoft Excel course
Excel is not just about numbers, as these examples are meant to illustrate. The techniques picked up in a MS Excel course can inspire you to use Excel for tasks you may have never considered. There is more to this software than you think, so get ready to explore its full potential in a Excel course.
About the Author
Author is a freelance copywriter. For more information on a Microsoft Excel course, visit http://www.MicrosoftTraining.net/.
Rating:
Please Rate:
(Average: Not rated)
Views: 164
Print Email Report Share
Article Categories
    • Artists
    • Gambling
    • Humanities
    • Humor
    • Movies
    • Music
    • Photography
    • Tattoos
    • Television
    • Classic Cars
    • Motorcycles
    • Recreational Vehicles
    • SUVs
    • Trucks
    • Vans
    • Branding
    • Business Opportunities
    • Careers and Jobs
    • Corporate
    • Customer Service
    • Direct Mail
    • Entrepreneurship
    • Ethics
    • Financing
    • Franchising
    • Home-Based Business
    • Human Resources
    • Import and Export
    • Leadership
    • Management
    • Market Research
    • Marketing and Advertising
    • Negotiation
    • Network Marketing
    • Networking
    • Organizational
    • Presentation
    • Project Management
    • Public Relations
    • Small Business
    • Strategic Planning
    • Team Building
    • Telemarketing
    • Training
    • Ask an Expert
    • College and University
    • Home Schooling
    • K-12
    • Languages
    • Online Education
    • Psychology
    • Accounting
    • Credit
    • Currency Trading
    • Debt Consolidation
    • Insurance
    • Investing
    • Leasing
    • Loans
    • Mortgage
    • Mutual Funds
    • Personal Finance
    • Stock Market
    • Structured Settlements
    • Taxes
    • Wealth Building
    • Coffee
    • Cooking
    • Gourmet
    • Recipes
    • Wine and Spirits
    • Acne
    • Aerobics
    • Alternative Medicine
    • Beauty
    • Cancer
    • Cosmetics
    • Depression
    • Diabetes
    • Diseases and Conditions
    • Fitness Equipment
    • Fitness
    • Hair Loss
    • Heart Disease
    • Medicine
    • Men's Health
    • Muscle Building
    • Nutrition
    • Skin Care
    • Supplements and Vitamins
    • Weight Loss
    • Women's Health
    • Yoga
    • Arts and Crafts
    • Babies
    • Collecting
    • Elderly Care
    • Genealogy
    • Hobbies
    • Parenting
    • Pets
    • Pregnancy
    • Woodworking
    • Feng Shui
    • Gardening
    • Home Appliances
    • Home Security
    • Interior Design
    • Landscaping
    • Affiliate Programs
    • Article Marketing
    • Auctions
    • Audio
    • Banner Advertising
    • Blogging
    • Broadband
    • Domain Names
    • E-Books
    • E-Commerce
    • Email Marketing
    • Ezines and Newsletters
    • Forums
    • Internet Marketing
    • Link Popularity
    • Pay-Per-Click
    • Podcasting
    • RSS
    • Search Engine Marketing
    • Search Engine Optimization
    • Security
    • Social Media
    • Spam
    • Video
    • Viral Marketing
    • Web Design
    • Web Development
    • Web Hosting
    • Copyright
    • Cyber Law
    • Intellectual Property
    • National, State, Local
    • Patents
    • Regulatory Compliance
    • Trademarks
    • Buying
    • Selling
    • Baseball
    • Basketball
    • Boating
    • Cycling
    • Extreme Sports
    • Fishing
    • Football
    • Golf
    • Hockey
    • Hunting
    • Martial Arts
    • Running
    • Scuba Diving
    • Soccer
    • Swimming
    • Tennis
    • Dating
    • Divorce
    • Marriage
    • Weddings
    • Astrology
    • Buddhism
    • Christianity
    • Faith
    • Hinduism
    • Islam
    • Judaism
    • Meditation
    • Metaphysical
    • New Age
    • Cable and Satellite TV
    • Cell Phones
    • Communication
    • Gadgets and Gizmos
    • GPS
    • Satellite Radio
    • Video Conferencing
    • VoIP
    • Addictions
    • Coaching
    • Goal Setting
    • Motivational
    • Stress Management
    • Time Management
    • Clothing
    • Electronics
    • Fashion
    • Gifts
    • Jewelry
    • Causes and Organizations
    • Environment
    • History
    • Holidays
    • Men's Issues
    • Nature
    • Philosophy
    • Politics
    • Women's Issues
    • World Affairs
    • Air Travel
    • Camping
    • Cruises
    • Destinations
    • Outdoors
    • Article Writing
    • Book Reviews
    • Copywriting
    • Fiction
    • Non-Fiction
    • Poetry
    • Quotes
    • Screenplay
    • Tools and Resources