Advertising

5 Powerful Excel Functions That Make Work Easier

5 Powerful Excel Functions That Make Work Easier
Advertising

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]),

            Advertising

            • “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 7 Effective Ways To Motivate Employees in 2021 2 How a Project Management Mindset Boosts Your Productivity 3 5 Values of an Effective Leader 4 How to Motivate People Around You and Inspire Them 5 The Importance of Reminders (And How to Make a Reminder Work)

            Read Next

            Advertising
            Advertising

            Last Updated on July 21, 2021

            The Importance of Reminders (And How to Make a Reminder Work)

            The Importance of Reminders (And How to Make a Reminder Work)
            Advertising

            No matter how well you set up your todo list and calendar, you aren’t going to get things done unless you have a reliable way of reminding yourself to actually do them.

            Anyone who’s spent an hour writing up the perfect grocery list only to realize at the store that they forgot to bring the list understands the importance of reminders.

            Reminders of some sort or another are what turn a collection of paper goods or web services into what David Allen calls a “trusted system.”[1]

            A lot of people resist getting better organized. No matter what kind of chaotic mess, their lives are on a day-to-day basis because they know themselves well enough to know that there’s after all that work they’ll probably forget to take their lists with them when it matters most.

            Fortunately, there are ways to make sure we remember to check our lists — and to remember to do the things we need to do, whether they’re on a list or not.

            In most cases, we need a lot of pushing at first, for example by making a reminder, but eventually we build up enough momentum that doing what needs doing becomes a habit — not an exception.

            Advertising

            From Creating Reminders to Building Habits

            A habit is any act we engage in automatically without thinking about it.

            For example, when you brush your teeth, you don’t have to think about every single step from start to finish; once you stagger up to the sink, habit takes over (and, really, habit got you to the sink in the first place) and you find yourself putting toothpaste on your toothbrush, putting the toothbrush in your mouth (and never your ear!), spitting, rinsing, and so on without any conscious effort at all.

            This is a good thing because if you’re anything like me, you’re not even capable of conscious thought when you’re brushing your teeth.

            The good news is you already have a whole set of productivity habits you’ve built up over the course of your life. The bad news is, a lot of them aren’t very good habits.

            That quick game Frogger to “loosen you up” before you get working, that always ends up being 6 hours of Frogger –– that’s a habit. And as you know, habits like that can be hard to break — which is one of the reasons why habits are so important in the first place.

            Once you’ve replaced an unproductive habit with a more productive one, the new habit will be just as hard to break as the old one was. Getting there, though, can be a chore!

            Advertising

            The old saw about anything you do for 21 days becoming a habit has been pretty much discredited, but there is a kernel of truth there — anything you do long enough becomes an ingrained behavior, a habit. Some people pick up habits quickly, others over a longer time span, but eventually, the behaviors become automatic.

            Building productive habits, then, is a matter of repeating a desired behavior over a long enough period of time that you start doing it without thinking.

            But how do you remember to do that? And what about the things that don’t need to be habits — the one-off events, like taking your paycheck stubs to your mortgage banker or making a particular phone call?

            The trick to reminding yourself often enough for something to become a habit, or just that one time that you need to do something, is to interrupt yourself in some way in a way that triggers the desired behavior.

            The Wonderful Thing About Triggers — Reminders

            A trigger is anything that you put “in your way” to remind you to do something. The best triggers are related in some way to the behavior you want to produce.

            For instance, if you want to remember to take something to work that you wouldn’t normally take, you might place it in front of the door so you have to pick it up to get out of your house.

            Advertising

            But anything that catches your attention and reminds you to do something can be a trigger. An alarm clock or kitchen timer is a perfect example — when the bell rings, you know to wake up or take the quiche out of the oven. (Hopefully you remember which trigger goes with which behavior!)

            If you want to instill a habit, the thing to do is to place a trigger in your path to remind you to do whatever it is you’re trying to make into a habit — and keep it there until you realize that you’ve already done the thing it’s supposed to remind you of.

            For instance, a post-it saying “count your calories” placed on the refrigerator door (or maybe on your favorite sugary snack itself)  can help you remember that you’re supposed to be cutting back — until one day you realize that you don’t need to be reminded anymore.

            These triggers all require a lot of forethought, though — you have to remember that you need to remember something in the first place.

            For a lot of tasks, the best reminder is one that’s completely automated — you set it up and then forget about it, trusting the trigger to pop up when you need it.

            How to Make a Reminder Works for You

            Computers and ubiquity of mobile Internet-connected devices make it possible to set up automatic triggers for just about anything.

            Advertising

            Desktop software like Outlook will pop up reminders on your desktop screen, and most online services go an extra step and send reminders via email or SMS text message — just the thing to keep you on track. Sandy, for example, just does automatic reminders.

            Automated reminders can help you build habits — but it can also help you remember things that are too important to be trusted even to habit. Diabetics who need to take their insulin, HIV patients whose medication must be taken at an exact time in a precise order, phone calls that have to be made exactly on time, and other crucial events require triggers even when the habit is already in place.

            My advice is to set reminders for just about everything — have them sent to your mobile phone in some way (either through a built-in calendar or an online service that sends updates) so you never have to think about it — and never have to worry about forgetting.

            Your weekly review is a good time to enter new reminders for the coming weeks or months. I simply don’t want to think about what I’m supposed to be doing; I want to be reminded so I can think just about actually doing it.

            I tend to use my calendar for reminders, mostly, though I do like Sandy quite a bit.

            More on Building Habits

            Featured photo credit: Unsplash via unsplash.com

            Advertising

            Reference

            [1] Getting Things Done: Trusted System

            Read Next