Advertising
Advertising

The Humble Spreadsheet: A Tool for the True Lifehacker

The Humble Spreadsheet: A Tool for the True Lifehacker

    When I was very young—I can’t remember how old, but let’s call it six or seven—I was introduced to spreadsheets. It introduced me to the world of statistics, of using data to track progress and predict the future, to work towards tangible, measurable goals instead of lofty, obtuse and too-often forgotten resolutions that people so often make about a month from now each year.

    I have my father to thank for this, a mindset and skill I consider vital to the successes I’ve had in many areas of my life, most especially those areas of my life that have to do with business and money. Each evening we’d go for a run, a habit that unfortunately didn’t stick as well as the interest in statistics, and when we got home we’d track the various details on some ancient (well, not at the time) and hefty Apple computer.
    I was fascinated to see how the data changed over time. How our best times improved—now doubt they would’ve looked different if a kid wasn’t tagging along!—and progress could be seen, right there, in solid numbers.

    The spreadsheet is often looked at as purely the realm of accountants, businessmen, and sometimes, for those smart enough to have one, the family budget. But that’s not the spreadsheet’s only utility. Not by a long shot! You can use spreadsheets in many aspects of your lifehacking and personal development.

    Advertising

    1. Budgeting and Expense Tracking

    We’ll start off by looking at something that doesn’t veer too far from the traditional domain of the spreadsheet—money. It’s an area that many people are looking to deal with in their lives. Spending gets out of control, bills come in with figures higher than the figure in your bank account, and without proper money management, life is the pits.

    But a spreadsheet, better configured to your own circumstances than any watered-down software application, can help anyone solve their money problems. You can see where the income comes in and how much of it there is, track where it disappears, and see how much you really have to spend once both your bills and savings have been taken into account.

    If you can see in black and white on your screen that you only have X amount of money left each week after your requisite expenses have been dealt with, it’s easy to stay in control. Figures can and do provide that extra bit of discipline and insight you may need.

    2. Exercise & Fitness

    As I mentioned, my first encounter with spreadsheets had nothing to do with money, but fitness. It’s great and truly motivating to see how your fitness level is improving in a tangible way. But it’s not just a self-lovefest, either; that insight allows you to plan for increased fitness. You can see how much you’re capable of improving over a given amount of time, and create a plan based on that ability to adapt that’ll take you to the next level.

    Advertising

    You’ll be able to determine a goal—whether that’s a best time you’d like to achieve or a certain amount of weight you’d like to be able to lift—and work towards on it on a truly achievable schedule. And as the cycle continues, you’ll reap the motivation to continue your fitness plan by seeing the numbers improve before your eyes.

    3. Nutrition

    I’ve heard it said that calorie counting is so eighties, but really, if you throw the stupid fad diets away, what is weight loss if it’s not burning more calories than you take in? You have to put yourself into calorie deficit or loss just won’t occur; that’s a fact. The trouble is often with determining how to put yourself into calorie deficit in a sensible way.

    With a spreadsheet, a knowledge of how many calories are in what you’re eating, and the tools available to figure out how much your body burns on its own, you can track your calorie intake and weight loss. By tracking your progress with numbers rather than a mere visual check on your waistline, you can make sure you’re losing weight. Again, you can use that data to make adjustments to your plan so it works better—losing weight the smart way without resorting to extreme and unhealthy measures.

    The same goes with gaining weight, or just eating right in general if you’ve got a specific plan that can be calculated with numbers of some kind.

    Advertising

    4. Productivity

    There are so many methods of tracking productivity out there it’s not funny. Some are ridiculously complicated and some are incredibly simple. If you use a GTD system where everything is captured as a task (if you’re doing it properly), you can see how many of those tasks you are completing and how many you’re not. You can tell when you’re getting dangerously close to unacceptable procrastination, or when you’re really on a roll.

    If your goal is to get more done in less time, you can track your working hours and see whether your hours-worked to tasks-completed ratio is getting better or worse. This gives you insight enabling you to figure out where your time-wasters are and maximize the productivity of each hour you’ve assigned for working.

    Whether you suffer from workaholicism or procrastination, then data can help—many problems occur when you just don’t know what’s going on.

    Spreadsheets Aren’t So Boring After All

    Where there’s a need for data, a spreadsheet can be your best friend. We’ve just had a baby daughter who sometimes has trouble feeding and data is essential to ensuring that she’s getting enough food often enough, and gaining enough weight, and so far that data has helped immensely; she’s been on an upward spiral. If anything goes to show that spreadsheets are infinitely versatile, as far as I’m concerned, that’s the proof.

    Advertising

    At sites I manage like AudioJungle, I use spreadsheets to ensure that we’re experiencing true growth on all fronts and not just getting hopeful over heightened statistics in one category. That data has helped make many smart business decisions before anything bad happened to us. That’s a pretty typical use for sheets, contrary to the unusual one I just mentioned.

    I’ve barely scratched the surface. How do you—or could you—use spreadsheets to get better results from life?

    More by this author

    Joel Falconer

    Editor, content marketer, product manager and writer with 12+ years of experience in the startup, design and tech digital media industries.

    How to Master the Art of Prioritization The Importance of Scheduling Downtime How to Make Decisions Under Pressure 11 Free Mind Mapping Applications & Web Services How to Use Parkinson’s Law to Your Advantage

    Trending in Featured

    1 How to Stay Motivated and Reach Your Big Goals in Life 2 How to Stop Procrastinating: 11 Practical Ways for Procrastinators 3 11 Reasons Why You Aren’t Getting Results 4 Why Do I Have Bad Luck? 2 Simple Things to Change Your Destiny 5 Top 4 Misapplications of the 80/20 Rule

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on June 26, 2020

    How to Stay Motivated and Reach Your Big Goals in Life

    How to Stay Motivated and Reach Your Big Goals in Life

    It is hardly a secret that the key to successfully accomplishing one goal after another is staying motivated. There are, of course, tasks which successful people may not like at all, yet they find motivation to complete them because they recognize how each particular task serves a greater goal.

    So how to stay motivated most of the time? Here are 5 simple yet effective ways on how to be motivated and get what you want:

    1. Find Your Good Reasons

    Anything you do, no matter how simple, has a number of good reasons behind it.

    You may not be able to find good reasons to do some tasks at first but, if you take just a few moments to analyze them, you will easily spot something good. We also have many tasks which don’t need any reasoning at all – we’ve been doing them for so long that they feel natural.

    If you’re ever stuck with some tasks you hate and there seems to be no motivation to complete it whatsoever, here’s what you need to do: find your good reasons.

    Even when you set goals, there needs to be reasons behind these goals. They may not be obvious, but stay at it until you see some, as this will bring your motivation back and will help you finish the task.

    Some ideas for what a good reason can be:

    • A material reward – quite often, you will get paid for doing something you normally don’t like doing at all.
    • Personal gain – you will learn something new or will perhaps improve yourself in a certain way.
    • A feeling of accomplishment – at least you’ll be able to walk away feeling great about finding the motivation and courage to complete such a tedious task.
    • A step closer to your bigger goal – even the biggest accomplishments in history have started small and relied on simple and far less pleasant tasks than you might be working on. Every task you complete brings you closer to the ultimate goal, and acknowledging this always feels good.

    Here’re 9 Types of Motivation That Make It Possible to Reach Your Dreams.

    2. Make It Fun

    When it comes to motivation, attitude is everything. Different people may have completely opposite feelings towards the same task: some will hate it, others will love it.

    Advertising

    Why do you think this happens? It’s simple: some of us find ways to make any task interesting and fun to do!

    Take sports for example. Visiting your local gym daily for a half-an-hour workout session sounds rather boring to some. Yet many others love the idea!

    They like exercising not only because they recognize the good reasons behind it, but simply because it’s fun! At certain time of their daily schedule, they find going to gym to be the best thing to do, simply because nothing else will fit their time and lifestyle so perfectly.

    Depending on how you look at it, you can have fun doing just about anything! Just look for ways of having fun, and you’ll find them!

    A simple approach is to start working on any task by asking yourself a few questions:

    • How can I enjoy this task?
    • What can I do to make this task fun for myself and possibly for others?
    • How can I make this work the best part of my day?

    As long as you learn to have the definite expectation of any task being potentially enjoyable, you will start to feel motivated.

    Some of you will probably think of a thing or two which are valid exceptions from this statement, like something you always hate doing no matter how hard you try making it fun. You’re probably right, and that’s why I don’t claim everything to be fun.

    However, most tasks have a great potential of being enjoyable, and so looking for ways to have fun while working is definitely a good habit to acquire.

    3. Change Your Approach And Don’t Give Up

    When something doesn’t feel right, it’s always a good time to take a moment and look for a different approach for the task.

    Advertising

    You may be doing everything correctly and most efficiently, but such approach isn’t necessarily the most motivating one. Quite often, you can find a number of obvious tweaks to your current approach which will both change your experience and open up new possibilities.

    That’s why saying “one way or another” is so common — if you really want to accomplish your goal, there is always a way; and most likely, there’s more than one way.

    If a certain approach doesn’t work for you, find another one, and keep trying until you find the one which will both keep you motivated and get you the desired results.

    Some people think that trying a different approach means giving up. They take pride in being really stubborn and refusing to try any other options on their way towards the goal.

    My opinion on this is that the power of focus is great, but you should be focusing on your goal, and not limiting your options by focusing on just one way to accomplish it it.

    4. Recognize Your Progress

    Everything you may be working on can be easily split into smaller parts and stages. For most goals, it is quite natural to split the process of accomplishing them into smaller tasks and milestones. There are a few reasons behind doing this, and one of them is tracking your progress.

    We track our progress automatically with most activities. But to stay motivated, you need to recognize your progress, not merely track it.

    Here’s how tracking and recognizing your progress is different:

    Tracking is merely taking a note of having reached a certain stage in your process. Recognizing is taking time to look at a bigger picture and realize where exactly you are, and how much more you have left to do.

    Advertising

    For example, if you’re going to read a book, always start by going through the contents table. Getting familiar with chapter titles and memorizing their total number will make it easier for you to recognize your progress as you read. Confirming how many pages your book has before starting it is also a good idea.

    You see, reading any book you will be automatically looking at page numbers and chapter titles, but without knowing the total number of pages, this information will have little meaning.

    Somehow, it is human nature to always want things to happen in short term or even at once. Even though we split complex tasks into simpler actions, we don’t quite feel the satisfaction until all is done and the task is fully complete.

    For many scenarios though, the task is so vast that such approach will drain all the motivation out of you long before you have a chance to reach your goal. That’s why it is important to always take small steps and recognize the positive different and progress made. This is how your motivation can sustain in long term.

    5. Reward Yourself

    This is a trick everyone likes: rewarding yourself is always pleasant. This is also one of the easiest and at the same time most powerful ways to stay motivated!

    Feeling down about doing something? Dread the idea of working on some task? Hate the whole idea of working? You’re not alone.

    Right from the beginning, agree on some deliverables which will justify yourself getting rewarded. As soon as you get one of the agreed results, take time to reward yourself in some way.

    For some tasks, just taking a break and relaxing for a few minutes will do.

    For others, you may want to get a fresh cup of coffee and even treat yourself a dessert.

    Advertising

    For even bigger and more demanding tasks, reward yourself by doing something even more enjoyable, like going to a cinema or taking a trip to some place nice, or even buying yourself something.

    Your progress may not seem to others like anything worth celebrating but, take time and do it anyway! It is your task and your reward, so any ways to stay motivated are good.

    The more you reward yourself for the honestly made progress, the more motivated you will feel about reaching new milestones, thus finally accomplishing your goal.

    Mix and Match for the Best Effect!

    Now that you have these five ways of staying motivated, it is a good moment to give you the key to them all: mix and match!

    Pick one of the techniques and apply it to your situation. If it doesn’t work, or if you simply want to get more motivated, try another technique right away. Mix different approaches and match them to your task for the best results.

    Just think about it: Finding good reasons to work on your task is bound to helping you feel better; and identifying ways to make it fun will help you enjoy the task even more.

    Or, if you plan a few points for easier tracking of your progress and on top of that, agree on rewarding yourself as you go; this will make you feel most motivated about anything you have to work through.

    More Tips to Boost Your Motivation

    Featured photo credit: Lucas Lenzi via unsplash.com

    Read Next