10 Excel templates that will be useful in everyday life
Technologies / / December 19, 2019
It is encouraging that Microsoft utmost comes to meet us, providing a completely free access to their office products for mobile devices. So you can quite comfortably use powerful Excel tools in his stalwart iPhone, for iPad and Android-gadgets with a large diagonal.
Do not forget that the proposed templates can be modified according to your wishes, as well as printed out if you prefer a paper screen. But before we take up adjustments, read about effective method, secrets and common errors work in Excel. With such a wealth of knowledge you are not afraid of this powerful monster!
1. Task list
Even the light head with a clear mind and memory once will fail, and you will forget something. Well, if it is to buy food for the fish, Tiffany Congratulations to the mother or violet watering your second half. They pobulkayut, poshipyat and pokvakayut, and your conscience will be clear. But then you do not pay a necessity - the Internet? You will be ashamed to look at myself in the mirror. And in that ill-fated day you broke the promise and make to-do lists. In the meantime, you will suffer one
electronic schedulers, Try to start with a simple list of tasks.Assign tasks, set their priority, ask deadline, select the person in charge to monitor the implementation progress and leave notes without leaving Excel. The template is already set up for quick sorting by date, importance, status, and other parameters.
2. budget travel
Theoretically, even the unreal (and with a full) travel can do without any financial investment on your part. To do this, get support at kraudfandingovoy siteFind free places to visit and do some work for food and beds. Such successes are accompanied by a seasoned web travelers with a fair amount of luck. Although what to conceal, even they have to find a few coins to call to report her mother about her health. Therefore, any movement beyond the boundaries of the place of residence is accompanied by the preliminary planning and budgeting. And so you do not have to dirty sheets of paper and endlessly twist-twirl figures suggest that you ask for help trip calculator.
In addition to the calculation, the template can display the estimated expenditure as a pie chart. Denezhek partition into categories as a percentage will make it clear which item of expenditure most gluttonous.
3. Inventory list
What unites fire, flood, theft and visit relatives to visit "on a week '? That's right, a high probability of losing the integrity of your property.
Oh, it's human nature that the toad strangling not for the fact of the loss of my grandmother's socks, but for the fact that you generally can not remember all his accumulated belongings. Under such unfavorable hands, you will gain household goods inventory. And in addition it is not superfluous to take a photo of their mansion and all its contents.
Putting jokes, you can suggest a pattern to those people who rent housing. Taking guests on a long settling time, do not forget to introduce them by hand with an act conducted by the inventory. He will stand you in good stead during the eviction of tenants.
4. Contact list
No matter how hard technical progress, but he can not win "dinosaurs" who do not want to know about the existence of easy to use tools to organize your contacts. Diaries, notebooks and just scraps of paper - their everything. Usually in such cases we say that the leopard change his spots (hello, my wife!). But we will not give up and find a compromise - notebook.
Electronic list of your dating is good for at least two reasons: they are easy to share and easy to sort Excel forces. Therefore, no harm will be to get hold of its back-up option, even those who fully trust google Contacts.
5. Gantt
Good Russian tradition to shake hands, take a stroll down payment, relax and do the job the night before the reporting day - a risky business equipment, significantly affecting the quality. Only planning, splitting tasks into steps and firm adherence to the schedule is able to save your reputation.
Gantt Chart - a popular type of bar charts (histograms), which is used to illustrate the plan, the work schedule for any project.
Of course, Excel power allow you to create the most graphs. Their strong point - visibility and accessibility.
And even if you do not have your own business, try to plan the repairs in the apartment, preparing to enter or marathon on Gantt procedure. You will appreciate the power of the tool.
6. Family tree
The crown of a wedding celebration - fist fight - go in the right scenario only if you clearly divide the warring parties into "us" and "them." And to prevent you to understand the situation is not only alcohol, but also the banal ignorance of their kindred.
Of course, the reason for the creation of genealogical tree chosen is not the best, there is much more strong reason. If the pattern will seem incomprehensible, switch to the list Example, which shows the family tree Kennedy.
7. cleaning schedule
"Lapses of memory" accompanied mankind since appeared as a division of responsibilities. The illness particularly characteristic of childhood. It minnows usually their moms and dads forget to wash the dishes, clean toys and take out the trash. The disease is treated without the use of drugs: print enough week operating schedule and write under it alleged punitive measures.
Enter the household names in the template cell, distributing work on weekdays and until the afternoon. And do not forget to hang the printout on the most popular place in the apartment - a refrigerator. Now nobody soshlotsya its forgetfulness.
8. maintenance Log
One day, after many years of operation of the vehicle, you might get the impression that in the car there was not a native part. In addition to the janitor, naturally - he is holy and inviolable. Is it really? The answer may be obtained only in the case when buying a car you have got into the habit of recording every act of his service in a special magazine. In addition, the template provides the ability to calculate the total amount of expenses associated with vehicle repairs.
9. run magazine
Elon Musk born in the vast Soviet space, we would have with you now riding on electric machines with low travel costs. Although people I kidding, this would not have happened. Elon would have smashed his forehead against the wall of bureaucracy and has long been drunk.
Therefore, the owners of cars the old fashioned scroll before his eyes switched out of dollars at the gas station flashing digits. But human nature is prone to quickly forget all the bad things, protecting you from thinking about soap and rope. Of course, I exaggerate, but why not find out how much money you spend on a constant refueling? And to make it easy to mileage log.
Make the shape of the odometer reading, the number of gallons filled and their cost, and you will appreciate the cost of one kilometer. A similar functionality is implemented in mobile applications, such as Car Logbook for Android.
10. diary
Only members of society living on a "morning drink - free day", the list of cases end with the opening of a nearby shop. The rest is necessary to spin sometimes worse than a squirrel in a wheel, persistently lying down in the limited time frame. And that is not forgotten in the turmoil of their list of plans, people prefer to fix it in diaries. The proposed template is good because it allows you to break every hour of labor at 15-minute intervals.