Excel for One and All Everybody needs to keep track of information. From veterinarians, to accountants, to housewives, we all have lists. Microsoft Excel is a program that can be used for simple, everyday tasks to complicated financial calculation and reporting. The following are a few examples of the versatile uses of Microsoft Excel.
Managing Movies Beth is a mom whose children have all flown the coop. Her family loved movies and over the years they had accumulated several hundred. When her kids were young, movies were stored by popularity. This box was for frequent viewing. That box was for holidays. The square box was for classic black-and-white, and the bookcase was for everything else. But now that everyone was gone and the old classification system was in shambles, Beth decided to buy a few nice bookcases and organize the movies by genre and title. Beth pulled up Excel on her laptop and got to work. She entered each movie by name, genre, and length. She used the sort function on Excel to make one list organized by title and gave them each a number. Then she copied that tab and re-sorted the list by genre. Simple and clear, her project was done.
Financial Information Nathan was an accountant. He was in charge of tracking all the date for his company’s promotional events. He had a worksheet for each event and separate tabs for each successive year. He programed macros to automatically sort and organize imported financial data. Once that was done, Nathan added tables and pie charts to put the data in workable terms that management would find easy to understand. With a few simple clicks, all authorized personnel could have access to the detailed, organized, and easy to understand information for each promotional event. It was a huge leap forward from the physical, handwritten bookkeeping records of twenty years ago.
Patient Records Tracy was a veterinarian. She had a local, yet booming business that offered check-ups, surgery, and kennel services for all domestic animals in the area. In order to keep track of the twelve nearly identical cats that each required different care, she turned to her Excel workbook for help. She had a separate page for each type of care (coded by color) and had the information for each animal organized in columns. Her system of tracking made it easy to keep tabs on each animal and make sure no cat undergone surgery when they were just being housed as their owner vacationed. As a result, she never made a mistake and never had to deal with angry customers, lawsuits, or unhappy animals.
As we see from these three examples, Excel can be a powerful tool in keeping our lives organized. No matter what type of data (movie lists, financial information, or animal patient records), Excel is the program to get it done. Microsoft training Kuwait offers Excel training courses for all housewives, accountants, vets, and so on. By getting your Microsoft certification Kuwait, you can work Excel like an expert and revitalize your life! Photo Credit:
malkowitch, mmagallan