OLI's Home Finds

21/02/2026

10/01/2021

Use VLOOKUP when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.

In its simplest form, the VLOOKUP function says:

=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

09/01/2021

As you prepare to enter the workforce, here are some pointers to improve your own typing skills:

1.) Use the correct starting position
2.) Don’t look down your hands
3.) Maintain good posture
4.) Find a comfortable position for your hands
5.) Practice!

https://www.herzing.edu/blog/5-tips-improving-your-typing-speed-accuracy

08/01/2021

5 benefits of drinking coffee

The potential health benefits associated with drinking coffee include:

> protection against type 2 diabetes, Parkinson’s disease, liver disease, and liver cancer and for the promotion of a healthy heart

https://www.medicalnewstoday.com/articles/270202

07/01/2021

The H in HLOOKUP stands for "Horizontal."

The HLOOKUP function syntax has the following arguments:

1. Lookup_Value: Required. The value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.

2. Table_Array: Required. A table of information in which data is looked up. Use a reference to a range or a range name.

3. Row_Index_Num: Required. The row number in table_array from which the matching value will be returned.

4. [Range_Lookup]: Optional. A logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. The first one is TRUE (1), which finds an approximate match from the table, and the second one is FALSE (0), which finds the exact match from the table.

https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f

06/01/2021

Relaxation encourages a healthy mind and body. But that does not mean that we can relax infinitely some stress is also important. There should be a balance between stress and relaxation.

Here are some points to explain why it is important to relax:
Relaxation slowers the heart rate. Thereby giving our hearts some rest. This in turn avoids many heart risk factors like hypertension, stroke, and broken heart syndrome.

It improves the skin by easing acne problems. Stress leads to skin breakouts and other skin related issues. Whereas if you relax the skin also relaxes and gets some time to recover from the earlier stress.

By relaxing we encourage the increase of blood flow to the muscles. Thereby providing more energy, better metabolism, and improves your memory.

Relaxation helps you to achieve a clear and calm mind. Your thought process is more positive and helps you in making a better decision.

https://kiipfit.com/important-relax/

05/01/2021

We are obsessed with getting our lives into some sort of a balanced state, be it getting our work in order, keeping track of the kids birthdays and gifts, or even day to day activities like housework. We’ll even go on strict diets. Since time has been so considerate, we shall look into the month known as "Get A Balanced Life Month."

Background and Content:
https://www.daysoftheyear.com/days/get-a-balanced-life-month/

04/01/2021

It’s about not just talking the talk, but also walking the walk. Everyone stumbles on their road to success, even if they’re sitting in a fancy office with a cushy chair at a Fortune 500 company. Just get started if you dream of running a successful business.

https://www.qualitylogoproducts.com/blog/walt-disney-inspirational-quotes/

03/01/2021

Good time management is a fundamental part of successfully working on your goals. Endless stress and always feeling overextended are often a result of lacking time management skills, which clearly stands in the way of your happiness.

Below you’ll find a list of my tips for efficient time management:
1. Find out how long things take
2. Set priorities
3. Plan enough
4. Personal performance curve
5. Break projects down into small steps
6. Set milestones
7. Evaluate

https://goalifyapp.com/en/steps-to-better-time-management/

02/01/2021

If you find yourself having a hard time managing your workload and wasting most of your time doing such daily tasks, you need to look and hire a virtual assistant. They can handle these activities efficiently, freeing up time for you to focus and increase your productivity.