10 Excel templates that will be useful in everyday life

It is gratifying that Microsoft Corporation is doing its best to provide us with absolutely free access to its office products for mobile devices. Therefore, you can easily use the powerful Excel toolkit on your tall iPhone, iPad and Android gadgets with a large diagonal.

Do not forget that the proposed templates can be modified to meet your wishes, as well as printed, if the screen you prefer paper. But before taking on corrections, read about effective tricks, secrets and common mistakes in Excel. With such a baggage of knowledge, you are not afraid of this mighty monster!

1. The list of tasks

Even the brightest head with a clear mind and solid memory will one day fail, and you will forget something. Well, if it’s buying fish food, congratulating mother-in-law with Mother’s Day or watering your violet half-violet. They poke, pinch and croak, and your conscience will remain clean. But suddenly you do not pay for the essentials – the Internet? You will be ashamed to look at yourself in the mirror. And on that ill-fated day you will break down and promise to make lists of cases. In the meantime, you will be plagued by choice among electronic planners, try to start with a simple list of tasks.

Assign tasks, prioritize them, set deadlines, select the person in charge, monitor progress and leave notes without leaving Excel. The template is already set to quickly sort by date, importance, status and other parameters.

2. Travel budget

Theoretically, even the most unreal (and thus full) travel can do without any financial investments from your side. To do this, it is necessary to enlist the support on the crowd-hosting area, to find free places to visit and to work a bit for food and a bed-place. Such successes are accompanied only by the burned-out travelers with a fair amount of luck. Although something to hide, even they have to look for a couple of coins to call to report to my mother about their health. Therefore, any movement beyond the boundaries of the place of residence is accompanied by preliminary planning and drawing up of estimates. And in order that you do not have to steal sheets of paper and endlessly twist-twirl the numbers, we suggest that you turn to the travel calculator for help.

  10 free online editors with Markdown support

How to calculate travel expenses in Excel

In addition to the calculation itself, the template can display the expected costs in the form of a pie chart. The breakdown of denezhek into categories in percentage terms will make it clear which item of expenditure is most voracious.

3. Inventory list

What unites the fire, flood, theft and the arrival of relatives stay “for a week”? Correctly, the high probability of loss of integrity of your property.

It’s such a human nature that the toad strangles not for the very fact of losing grandmother’s socks, but because you can not remember all your accumulated belongings at all. With such an unfavorable scenario, you will be rescued by the inventory of household utensils. And in addition to it, it will not be superfluous to photograph your mansions with all the contents.

Leaving the jokes, you can advise the template to those people who rent housing. Taking guests for a long period of settlement, do not forget to acquaint them with the signature with the act of inventory. He will do you a good service when evicting tenants.

4. Contact list

No matter how hard the technical progress is, he can not defeat the “dinosaurs” who do not want to know about the existence of convenient tools for organizing your contacts. Diaries, notebooks and just scraps of paper are all of them. Usually in such cases it is said that the humpbacked grave will correct (hello, wife!). But let’s not drop our hands and find a compromise option – a notebook.

The electronic sheet of your dating is good for at least two reasons: it’s easy to share and simply sort by Excel. Therefore, it is not superfluous to have its backup option even for those who completely trust Google Contacts.

5. The Gantt Chart

A good Russian tradition to strike hands, walk down an advance, relax and do work the night before the day of reporting is a rather risky business technique that significantly affects the quality. Only planning, splitting tasks into stages and adhering to the schedule can save your reputation.

The Gantt Chart is a popular type of bar chart (histogram), which is used to illustrate the plan, work schedule for a project.

Of course, the power of Excel allows you to create these very diagrams. Their hobby is visibility and accessibility.

  Why the photos on Facebook look so awful and how to avoid it

Excel template for Gantt chart

And even if you do not have your own business, try to plan repairs in the apartment, preparation for admission or a marathon using the Gantt technique. You will appreciate the power of the instrument.

6. Family tree

The crown of the wedding celebration – a fist fight – will go according to the correct scenario only if you clearly divide the opposing sides into “your own” and “strangers”. And to prevent you from understanding the situation can not only alcohol, but also the banal ignorance of one’s relatives.

Of course, the reason for creating a family tree is not the best, there is much more valid reason. If the pattern seems incomprehensible to you, switch to the Example sheet, which shows the Kennedy family tree.

7. Schedule of shifts

“Failures in memory” have accompanied humanity since the distribution of duties. The illness is especially characteristic for children. It’s malyavki more often than their moms and dads forget to wash dishes, remove toys and take out the garbage. The disease is treated without the use of medications: it is enough to print a weekly schedule and write under it the alleged punitive measures.

Enter the household names in the template cells, distributing the work on the days of the week before and after noon. And do not forget to hang the printout on the most popular place in the apartment – a refrigerator. Now no one will refer to their forgetfulness.

8. Maintenance log

Once, after years of operating the car, you may get the impression that there is not a single native part left in the car. In addition to the janitor, of course – he is holy and inviolable. Is it really? The answer can only be obtained if, when buying a car, you get the habit of recording every act of its maintenance in a special magazine. In addition, the template provides an opportunity to calculate the total amount spent on repairing the vehicle.

  Safe chats: do they exist, why are they needed, and why is it important?

9. The mileage log

Born Ilon Mask in the expanses of the Soviet space, we would have already ridden with you on electromachines with a low cost of travel. Though whom I deceive, such would not happen. Ilon would have smashed his forehead against the wall of the bureaucracy and had long been asleep.

Therefore, the owners of cars in the old manner scroll around before the eyes of the flowing dollars for the flashing figures of the gas station. But the nature of a person tends 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 constant refueling? And it’s easy to do this with the help of a mileage log.

How to calculate fuel consumption per kilometer in Excel

Put in the form odometer readings, the number of lit liters and their cost, and you will estimate the cost of one kilometer of run. Similar functionality is implemented in mobile applications, for example, Car Logbook for Android.

10. The Diary

Only members of society who live by the principle “drank in the morning – the day is free”, the list of cases ends with the opening of a nearby store. The rest have to turn sometimes no worse than the squirrel in the wheel, stubbornly keeping within a limited time frame. And in order not to forget in your turmoil your list of plans, people prefer to fix it in diaries. The proposed template is good because it allows you to break every work hour into 15-minute segments.

댓글 달기

이메일 주소는 공개되지 않습니다. 필수 필드는 *로 표시됩니다

위로 스크롤