# 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.

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.

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.

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.

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.

“=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.

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

##### This 4-Year Old Girl’s Explanation On the Problem with New Year’s Resolutions Is Everything You Need

Published on January 16, 2019

# How to Effectively Manage a Heavy Workload at Work

We’re all busy, but sometimes we go through periods where the work piles up and it seems like it might never end.

You might have such a heavy workload that it feels too intimidating to even start.

You may have said yes to some or too many projects, and now you’re afraid you won’t be able to deliver.

That’s when you need to take a step back, take a deep breath, and start looking at what’s working and what’s not working.

Here’re 13 strategies you can use to get out from under your overwhelming workload:

## 1. Acknowledge You Can’t Do It All

Many of us have a tendency to think we can do more than we actually can. We take on more and more projects and responsibility and wear numerous hats.

We all have the opportunity to have and take on more work than we can reasonably expect to get done. Unfortunately, our workload is not static. Even now, while you are reading this article, I’m guessing that your inbox is filling up with fresh new tasks.

To make real, effective progress, you have to have both the courage and resourcefulness to say, “This is not working”. Acknowledge that you can’t do it all and look for better solutions.

At any given time in your life, there are likely many things that aren’t going according to plan. You have to be willing to be honest with yourself and those around you about what’s not working for you, both personally and professionally.

The more you exercise your ability to tell the truth about what’s working and what’s not working, the faster you’ll make progress.

## 2. Focus on Your Unique Strengths

Whether you’re an entrepreneur, a leader or working as part of a team, every individual has unique strengths they can bring to the table.

The challenge is that many people end up doing things that they’re simply not very good at.

In the pursuit of reaching your goals or delivering a project, people end up doing everything themselves or taking on things that don’t play to their unique strengths. This can result in frustration, overwhelm and overwork.

It can mean projects taking a lot longer to complete because of knowledge gaps, or simply not utilizing the unique strengths of other people you work with.

It is often not about how to complete this project more effectively but who can help deliver this project.

• Are you a great strategist?
• Are you an effective planner?
• Is Project Management your strength?
• Is communication and bringing people together your strength?
• Are you the ideas person?

Think about how you can bring the biggest value to your work and the projects you undertake.

## 3. Use the Strengths of Your Team

One of the simplest ways to manage your workload effectively is to free up your time so you bring your highest level of energy, focus and strengths to each project.

Delegation or better teamwork is the solution.

Everyone has unique strengths. It’s essential to think teamwork rather than working in isolation to ensure projects can be completed effectively. Besides, every time you give away a task or project that doesn’t play to your unique strengths, you open up an opportunity to do something you’re more talented at. This will empower both yourself and those around you.

Rather than taking on all the responsibilities yourself, look at who you can work with to deliver the best results possible.

## 4. Take Time for Planning

“Give me six hours to chop down a tree and I will spend the first four sharpening the axe”. – Abraham Lincoln

One hour of effective planning could save hours of time. Rather than just rushing in and getting started on projects, take the time to map everything in.

You can take the time to think about:

• What’s the purpose of the project?
• How Important is it?
• When does it need to be delivered by?
• What is the best result and worst result for this project?
• What are the KPIs?
• What does the project plan and key milestones look like?
• Who is working on this project?
• What is everyone’s responsibilities?
• What tolerances can I add in?
• What are the review stages?
• What are the challenges we may face and the solutions for these challenges?

Having absolute clarity on the project, the project deliverables and the result you want can save a lot of time. It also gets you clear on the priorities and timelines, so you can block out the required amount of time to focus and concentrate.

## 5. Focus on Priorities

Not everything is a priority, although it can often feel, in the moment, that it is.

Whatever you’re working on, there is always the Most Urgent, Important or Most Valuable projects or tasks.

One tool you can use to maximize your productivity and focus on your biggest priorities is to use the Eisenhower Matrix. This strategic tool for taking action on the things that matter most is simple. You separate your actions based on four possibilities:

1. Urgent and important (tasks you will do immediately).
2. Important, but not urgent (tasks you will schedule to do later).
3. Urgent, but not important (tasks you will delegate to someone else).
4. Neither urgent nor important (tasks that you will eliminate).

James Clear has a great description on how to use the Eisenhower Matrix: How to be More Productive By Using the Eisenhower Box

The method I use with my coaching clients is to ask them to lay out their Top Five priorities for the day. Then to start with the most important priority first. At the end of the day, you review performance against these priorities.

If you didn’t get everything accomplished, start the next day with your number one priority.

If you are given additional task/projects during the day, then you will need to gauge their importance V the other priorities.

## 6. Take Time Out

To stay on top of a heavy workload, it’s important to take time out to rest and recuperate.

If your energy levels are high and your mind and body is refreshed and alert, you are in more of a peak state to handle a heavy workload.

Take time out of your day to go for a walk or get some exercise in. Leave early when possible and spend time with people who give you a lot of energy.

In the background, it’s essential to get a good night’s sleep and eat healthily to sharpen the mind.

## 7. Maintain a Healthy Work-Life Balance

Maintaining a healthy work-life balance can be tough. The balance we all crave is very different from one another.

I’ve written before about 13 Work Life Balance Tips for a Happy and Productive Life. Working longer and harder doesn’t mean achieving more, especially if you have no time to spend with the people that matter most. The quality of who you are as a person, the relationships you have, the time you spend in work, deciding on what matters most is completely within your control.

Work-life balance is about finding peace within yourself to be fully present, wherever you are, whether that be in the office or at home, right now. It’s about choosing what matters most and creating your own balanced life.

If you feel there is not enough balance, then it may be time to make a change.

Multi-tasking is a myth. Your brain simply can’t work effectively by doing more than one thing at a time—at least more than one thing that requires focused attention.

So get your list of priorities (see earlier point), do the most important thing first, then move to the next item and work down your list.

When you split your focus over a multitude of different areas, you can’t consistently deliver a high performance. You won’t be fully present on the one task or project at hand.

If you allocate blocked time and create firm boundaries for specific activities and commitments, you won’t feel so overwhelmed or overworked with everything you have to do.

## 9. Work in Blocks of Time

To keep your energy up to produce your best results it’s essential to take regular breaks.

I use the 60-60-30 method myself and teach it to my coaching clients.

Work on a project for a sustained period of 50 minutes.

Then take a 10-minute break. This could be taking a walk, having a healthy snack or just having a conversation with someone.

Then continue to work on the project for a further 50 minutes.

Then take another 10-minute break.

Then take a complete 30-minute break to unplug from the work. This could be time for a proper lunch, a quick bit of exercise, reading or having a walk.

By simply taking some time out, your energy levels stay up, the quality of your work improves and you reduce the risk of becoming burned out.

## 10. Get Rid of Distractions

Make an estimation on how many times you are distracted during an average working day. Now take that number and multiply it by 25. According to Gloria Mark in her study on The Cost of Interrupted Work, it takes us an average of 23 minutes and 15 seconds to return to the original task after interruption.[1]

“Our research has shown that attention distraction can lead to higher stress, a bad mood and lower productivity.”

Distractions don’t just take up your time during the distraction, they can derail your mental progress and focus for almost 25 minutes. So, if you are distracted 5 times per day, you could be losing almost 2 hours every day of productive work and almost 10 hours every week.

If you have an important project to work on, find a space where you won’t be distracted, or try doing this.

## 11. Commit Focused Time to Smaller Tasks

You know sometimes, you need to simply tackle these tasks and take action on them. But there’s always something more pressing.

Small tasks can often get in the way of your most important projects. They sit there on your daily To Do list but are often forgotten about because of more important priorities or because they hold no interest for you. But they take up mental energy. They clutter your mind.

Commit to spending a specific period of time completing all the small tasks you have on your To Do list. It will give you peace of mind and the space to focus more on your bigger priorities.

## 12. Take a Time Audit

Do you know exactly where your time is going each day? Are you spending too long on certain projects and tasks to the detriment of bigger opportunities?

Spend a bit of time to analyze where you are spending your time. This insight will amaze you and give you the clarity to start adjusting where you focus your time and on what projects.

You can start by taking a piece of paper and creating three columns:

Column A is Priority Work. Column B is Good Work. Column C is low value work or stuff.

Each day, write down the project or task and the time spent on each. Allocate that time to one of the columns.

At the end of the week, record the total time spent in each column.

If you are spending far too much time on certain types of work, look to change things so your focused time is in Column B and C.

It is essential to protect our confidence to ensure we don’t get overwhelmed, stressed and lose belief.

When you have confidence as a daily resource, you are in a better position to problem solve, learn quicker, respond to anything, adjust to anything, and achieve your biggest opportunities.

Confidence gives you the ability to transform fear into focused and relaxed thinking, communication, and action. This is key to put your mind into a productive state.

When confidence is high, you can clearly see the possibilities at hand and create strategies to take advantage of them, or to solve the challenges you face each day.

## Final Words

A heavy workload can be tough to deal with and can cause stress, burnout and ongoing frustration.

The key is to tackle it head on, rather than let it go on and compound the long-term effects. Hopefully, you can take action on at least one of these tips.

If it gets too much, and negatively affects your physical and mental health, it may be time to talk to someone. Instead of dealing with it alone and staying unhappier, resentful and getting to a point where you simply can’t cope, you have to make a change for your own sanity.

Featured photo credit: Hannah Wei via unsplash.com

## Reference

 [1] ^ Gloria Mark: The Cost of Interrupted Work: More Speed and Stress