Advertising
Advertising

5 Powerful Excel Functions That Make Work Easier

5 Powerful Excel Functions That Make Work Easier

If you’ve just started learning how to use Microsoft Excel, you’ll probably have a lot of questions to ask about the functions of the program. Because let’s face it, despite being exceptionally useful, Excel can be a very complicated application. It’s like a hammer when your most frustrating reporting tasks at work resemble nails.

Aside from great Excel features such as flash fill, pivot tables, and conditional formatting, Excel also has a lot of powerful functions that will help save time when creating spreadsheets. Invest some time in learning to use Excel so you can prepare and manage complex reports, as well as perform what-if analysis on data like a pro!

To help you get started, here are 5 important Excel functions you should learn today.

1. The SUM Function

The sum function is the most used function when it comes to computing data on Excel. This function works to sum a group of numbers in a specific set of cells. This means you don’t need to type a long cumbrous formula just to calculate the sum of all the data you need. Because of its popularity, newer versions of Microsoft Excel have a button specifically for this function.

This function is performed by typing the formula on the function bar and highlighting the cells you want summed before clicking “Enter”. You also need to be careful in highlighting cells, as Excel will sum everything you include. If this happens, you can easily click the “Undo” button to reset the values back to its original state.

Advertising

SUM function

    The syntax formula for sum function is “=SUM” (number1, number2, etc.).

    In this image, the sum function for the cells C2 through C7 is obtained through the formula “=SUM(C2:C7)”, giving you the result of 33161.

    2. The TEXT Function

    Text function is a useful tool that helps convert a date (or number) into a text string in a particular format. It falls in the category of string formulas that converts numerical values to a string. It is handy when users need to view numeric data in a readable format. Take note that the “TEXT” formula only works to convert numeric values to text. Therefore, its results cannot be calculated.

    Advertising

    TEXT FUNCTION

      The syntax formula for text function is “=TEXT” (value, format_text).

      • “Value” refers to the particular number you wish to convert to text.
      • “Format_text” defines the format of the conversion.

      In this example, the user uses a text formula to find the abbreviated day for the date “=TEXT (B2, “ddd”)”.

      3. The VLOOKUP Function

      VLookup is powerful Excel function that is often overlooked. Users will find it useful when they need to find specific data on a large table. You can also use VLookup to search for names, phone number, or specific data on your sheet. Instead of manually looking for the names and wasting time scrolling through hundreds of data, the VLookup function makes this process faster and more efficient.

      vlookup

        Image: spreadsheeto.com

        Advertising

        The VLookup formula is “=VLOOKUP” (lookup_value, table_array, col_index_num, *range_lookup*).

        • “lookup_value” is the data you want to find.
        • “table_array” is the data column where you want to limit your search.
        • “col_index_num” is the column number within the table that you want to return a value from.
        • “range_lookup” is an optional argument that allows you to search for the exact match of your lookup value without sorting the table.

        4. The AVERAGE Function

        The average function is an extremely useful tool for getting the average value in a range of cells. Like the sum function, it is frequently used in computing and analyzing data on spreadsheet. Basically, the average function works to find the “arithmetic mean” for a group of cells. Aside from the average function, Excel also has the median and mode function.

        Average Function

          The syntax formula for the average function is “AVERAGE” (number1, number2, etc.).

          • “Number 1” refers to the first number in the range where you want the average.
          • “Number 2” is the additional reference of the average range. You can get an average of up to a maximum of 255 cells.

          Additional ­­Examples:

          Advertising

          “=AVERAGE (A2:A10)” – computes the average of numbers in cells A2 through A10.

          “=AVERAGE (B2: B10, 7)” – computes the average of the numbers in cells B2 through B10 and the number 7.

          5. The CONCATENATE Function

          This function is a good time saver when you need to combine data from 2 or more cells. Unlike the merge tool which physically merges two or more cells into a single cell, the concatenate function only combines the contents of the combined cells. In the latest version of Excel ( 2016), the concatenate function has been replaced with concat function and will be incorporated in more future versions of Excel.

          Average Function

            The syntax formula for the concatenate function is “CONCATENATE” (text1, [text2…text_n]),

            • “Text1, Text2…text_n” are the data you want to combine.

            More by this author

            Armela Escalona

            Freelance Writer

            9 Beautiful Journals for People Who Love To Take Notes 7 Ways To Fix Damaged Hair and Get Your Healthy Hair Back How To Design Your Bedroom the Feng Shui Way 5 Tools to Create a Professional Website for Free 5 Best Professional E-commerce Store Builders

            Trending in Productivity

            1 8 Ways to Train Your Brain to Learn Faster and Remember More 2 How Exercising Makes You More Productive 3 10 Practical Ways to Drastically Improve Your Time Management Skills 4 15 Highly Successful People Who Failed On Their Way To Success 5 How to Memorize More and Faster Than Other People

            Read Next

            Advertising
            Advertising

            Last Updated on September 20, 2018

            8 Ways to Train Your Brain to Learn Faster and Remember More

            8 Ways to Train Your Brain to Learn Faster and Remember More

            You go to the gym to train your muscles. You run outside or go for hikes to train your endurance. Or, maybe you do neither of those, but still wish you exercised more.

            Well, here is how to train one of the most important parts of your body: your brain.

            When you train your brain, you will:

            • Avoid embarrassing situations. You remember his face, but what was his name?
            • Be a faster learner in all sorts of different skills. No problem for you to pick up a new language or new management skill.
            • Avoid diseases that hit as you get older. Alzheimer’s will not be affecting you.

            So how to train your brain and improve your cognitive skills?

            1. Work your memory

            Twyla Tharp, a NYC-based renowned choreographer has come up with the following memory workout:

            When she watches one of her performances, she tries to remember the first twelve to fourteen corrections she wants to discuss with her cast without writing them down.

            If you think this is anything less than a feat, then think again. In her book The Creative Habit she says that most people cannot remember more than three.

            The practice of both remembering events or things and then discussing them with others has actually been supported by brain fitness studies.

            Memory activities that engage all levels of brain operation—receiving, remembering and thinking—help to improve the function of the brain.

            Advertising

            Now, you may not have dancers to correct, but you may be required to give feedback on a presentation, or your friends may ask you what interesting things you saw at the museum. These are great opportunities to practically train your brain by flexing your memory muscles.

            What is the simplest way to help yourself remember what you see? Repetition.

            For example, say you just met someone new:

            “Hi, my name is George”

            Don’t just respond with, “Nice to meet you”. Instead, say, “Nice to meet you George.”

            Got it? Good.

            2. Do something different repeatedly

            By actually doing something new over and over again, your brain wires new pathways that help you do this new thing better and faster.

            Think back to when you were three years old. You surely were strong enough to hold a knife and a fork just fine. Yet, when you were eating all by yourself, you were creating a mess.

            It was not a matter of strength, you see. It was a matter of cultivating more and better neural pathways that would help you eat by yourself just like an adult does.

            Advertising

            And guess what? With enough repetition you made that happen!

            But how does this apply to your life right now?

            Say you are a procrastinator. The more you don’t procrastinate, the more you teach your brain not to wait for the last minute to make things happen.

            Now, you might be thinking “Duh, if only not procrastinating could be that easy!”

            Well, it can be. By doing something really small, that you wouldn’t normally do, but is in the direction of getting that task done, you will start creating those new precious neural pathways.

            So if you have been postponing organizing your desk, just take one paper and put in its right place. Or, you can go even smaller. Look at one piece of paper and decide where to put it: Trash? Right cabinet? Another room? Give it to someone?

            You don’t actually need to clean up that paper; you only need to decide what you need to do with it.

            That’s how small you can start. And yet, those neural pathways are still being built. Gradually, you will transform yourself from a procrastinator to an in-the-moment action taker.

            3. Learn something new

            It might sound obvious, but the more you use your brain, the better its going to perform for you.

            Advertising

            For example, learning a new instrument improves your skill of translating something you see (sheet music) to something you actually do (playing the instrument).

            Learning a new language exposes your brain to a different way of thinking, a different way of expressing yourself.

            You can even literally take it a step further, and learn how to dance. Studies indicate that learning to dance helps seniors avoid Alzheimer’s. Not bad, huh?

            4. Follow a brain training program

            The Internet world can help you improve your brain function while lazily sitting on your couch. A clinically proven program like BrainHQ can help you improve your memory, or think faster, by just following their brain training exercises.

            5. Work your body

            You knew this one was coming didn’t you? Yes indeed, exercise does not just work your body; it also improves the fitness of your brain.

            Even briefly exercising for 20 minutes facilitates information processing and memory functions. But it’s not just that–exercise actually helps your brain create those new neural connections faster. You will learn faster, your alertness level will increase, and you get all that by moving your body.

            Now, if you are not already a regular exerciser, and already feel guilty that you are not helping your brain by exercising more, try a brain training exercise program like Exercise Bliss.

            Remember, just like we discussed in #2, by training your brain to do something new repeatedly, you are actually changing yourself permanently.

            6. Spend time with your loved ones

            If you want optimal cognitive abilities, then you’ve got to have meaningful relationships in your life.  Talking with others and engaging with your loved ones helps you think more clearly, and it can also lift your mood.

            Advertising

            If you are an extrovert, this holds even more weight for you. At a class at Stanford University, I learned that extroverts actually use talking to other people as a way to understand and process their own thoughts.

            I remember that the teacher told us that after a personality test said she was an extrovert, she was surprised. She had always thought of herself as an introvert. But then, she realized how much talking to others helped her frame her own thoughts, so she accepted her new-found status as an extrovert.

            7. Avoid crossword puzzles

            Many of us, when we think of brain fitness, think of crossword puzzles. And it’s true–crossword puzzles do improve our fluency, yet studies show they are not enough by themselves.

            Are they fun? Yes. Do they sharpen your brain? Not really.

            Of course, if you are doing this for fun, then by all means go ahead. If you are doing it for brain fitness, then you might want to choose another activity

            8. Eat right – and make sure dark chocolate is included

            Foods like fish, fruits, and vegetables help your brain perform optimally. Yet, you might not know that dark chocolate gives your brain a good boost as well.

            When you eat chocolate, your brain produces dopamine. And dopamine helps you learn faster and remember better. Not to mention, chocolate contains flavonols, antioxidants, which also improve your brain functions.

            So next time you have something difficult to do, make sure you grab a bite or two of dark chocolate!

            The bottom line

            Now that you know how to train your brain, it’s actually time to start doing.

            Don’t just consume this content and then go on with your life as if nothing has changed. Put this knowledge into action and become smarter than ever!

            Featured photo credit: Unsplash via unsplash.com

            Read Next