How to Create Simple Formulas and Functions in Microsoft Excel?

Microsoft Excel is the most powerful member of the Office suite. With that power comes a steep learning curve. But it’s worth climbing it because spreadsheet skills are a must for self-respecting digital workers today. And don’t worry like everything else you can start from the very basics and learn Excel one tiny bit at a time.

One of the fundamental concepts in Excel is the difference between formulas and functions. So, let’s learn how to create them and see how they can help us manipulate the data in the rows and columns.

What is the Difference Between a Formula and Function in Excel

A formula (also called an equation) is something that you as the user create to calculate a value with the data in the cells.

A function is a built-in formula that already exists in Excel as pre-defined piece of code.

In short: A function is a built-in calculation, while a formula is a calculation defined by the user.

Both are building blocks of any Excel operation. A formula can make use of a single function or a combination of functions to calculate a result. A formula can also refer to cells, rows, columns, defined variables, and functions to create complex statements that manipulate the data in the spreadsheet.

Here’s an example:

A1 + A2 + A3 is a simple formula that calculates the values in the cells A1, A2, A3.

A Simple Excel Formula

 

Instead of laboriously adding each cell, you can use the SUM function to add up a range of cells: =SUM(A2:A3)

Microsoft Excel - SUM Function

How to Write a Formula

To enter a formula:

  1. Select a cell.
  2. To enter a formula, type an equal sign (=) in the cell.
  3. Type the cell references for the cell values you want to calculate. For example, type the formula =A1+A2+A3. Hit Enter.
  4. Instead of typing each cell address, you can also select cell A1, A2, and cell A3.
  5. If you change the value of any cell, Excel automatically re-calculates the total. Also, when you select a cell, Excel shows the value or formula of the cell in the formula bar. You can always click in the formula bar and edit the formula.

How to Write a Function

Instead of inserting each value to be summed as in the above formula, you can use the SUM function to add up a range of cells. There are several ways to insert and use functions, but let’s see the simplest one to begin with. The process is similar…

  1. Select a cell.
  2. To enter a function, type an equal sign (=) in the cell.
  3. Type SUM (A1:A3). Hit Enter.
  4. The SUM function simplifies the calculation. The part between the brackets (arguments) gives Excel the range A1:A3 as input. As you can see, the range includes the first and last cell of the range separated by a colon.
  5. You don’t have to type a function name in all caps. Microsoft Excel automatically capitalizes it once you finish the formula and press the Enter key to complete it.

SUM is a basic function. There are 467 functions in Excel and more can be used through third-party add-ons. Don’t worry—there are easier ways to use functions without memorising them all. Let’s get introduced to the Insert Function feature in Excel.

How to Use Insert Function in Excel

The Insert Function dialog box makes it easy to search and reuse the right functions from the library Excel provides. It also gives you an easier way to understand the arguments the function will take.

  1. To view the Insert Function dialog box, click the fx button on the Formula bar.

Microsoft Excel-The Insert Function Dialog

  1. Use the search box to type a brief description of the task you want the function to do. Click Go.
  2. A list of closest matches will be displayed in the Select a function box. You can use the dropdown under select a category to broaden your search or narrow it down. For instance, selecting All will display all Excel functions in an alphabetical order.

Microsoft Excel - Insert Function Arguments Screen

  1. Click a function name to see the function syntax and a brief description immediately below the Select a function.
  2. Double-click a function name to display the function and its arguments in the Function Arguments wizard, which helps you add correct arguments.

The Insert Function dialog box helps you paste the correct function with its arguments in a cell. Simpler functions can be entered manually, but you will feel better equipped to handle the more complex functions (like COUNTIF or COUNTIFS functions) with the dialog box. Excel couldn’t have made it any easier for beginners.

There are two other ways to display the dialog box.

  1. Click the Insert Function button on the Formulas tab.

Microsoft Excel-Insert Function Formula Tab

  1. Click the small arrow to the right of the AutoSum feature on the Formulas Ribbon. Select More Functions from the dropdown.

Microsoft Excel-Insert Function-AutoSum

The AutoSum Button for Simple Formulas

The AutoSum button on the Home tab is a timesaving feature for the simplest of calculations. You can also use it from the Formulas tab. This one-click formula button can add, average, count numbers, or find the minimum or maximum for a column, row, or group of cells.

  1. Click the AutoSum button and it will enter the SUM function. Click the arrow for the button, you will see the other common functions you can use for basic calculations.

Microsoft Excel-AutoSum Button

  1. Let’s say you have a column of numbers you would like to add. Click the cell where you want the total to be displayed. Then, click the AutoSum button. Excel will automatically detect the numbers you want to add and their cell references. The cells get selected and the function will be displayed like this:

Microsoft Excel-AutoSum Example

  1. Click Enter for the total.
  2. The other functions available in the AutoSum button will work in the same way.

Do Everyday Tasks with Simple Formulas and Functions

You don’t need to be a statistical guru to use Excel. Formulas and functions are a great help to manage everyday tasks like home budget management, income taxes, and loan amortization calculations. Simple formulas and functions are the first building blocks.

How to start and invest in a mutual fund SIP?

Savings is perhaps the basic goal of every earning individual. You will find it tough to locate an individual would want to put in hours of effort to earn just as much that he is able to pay off all his expenses and be left with nothing to keep aside for his and his loved one’s future.

While savings are important, what is even more rewarding is to see your savings grow over time. If that happens, you know for sure that you are doing good for yourself and your family. With mutual funds, growth in your savings becomes a tad bit easy.

growth in your savings with Mutual funds

Among the different types of mutual funds, Systematic Investment Plans or the SIPs as they are commonly known as are increasingly becoming popular investment vehicles for the working class. As the name suggests, the SIPs are all about investing in a specific plan systematically over a period of time to earn good returns at the end of such period.

If you go by what the mutual fund experts believe in, the SIPs are the best investment vehicles for periodic investments. Though SIPs are quite common investment vehicles, the fact remains that there is not complete clarity on how an SIP really works or what are the steps to start investing in any SIP.

What is an SIP and how does it work?

Simply put, an SIP is an investment tool. It works best for people who like to invest regularly as this investment tools systematically regularises your investments in mutual funds. In case of SIPs, regularity is the key element and not the amount you want to invest.

how sip works?

The SIP can be started with as low as INR 500 every month and can go up to any amount that you can set aside from your earnings consistently every month for a certain period. The frequency of investment in the SIP is also up for your choice – you can start a daily, weekly, monthly or quarterly SIP but being regular with your frequency and investment is essential.

SIPs are the best-recommended options for those interested in mutual funds as it helps them maximise their returns while averaging out their cost of purchase. The best that an SIP does to any working class individual is that it imparts discipline in financial savings and compels the investor to invest a certain amount regularly no matter what the condition in the market.

How to start investing in SIP?

When you decide to invest in an SIP, you choose to take up a financial commitment. To do so, you need to first evaluate your income and total expenses to decide how much amount of money you can put aside for an SIP every month or for whatever frequency of investment you are considering.

how to start investing in SIP?

A monthly SIP is often believed to be the most feasible option for working class individuals. Once you have evaluated your financial position, the next thing to do is to find the right fund and start investing. While you can always rely on your research to find the right mutual fund, if you are not too sure, several professional investment consultants can help you choose the right mutual fund based on your financial situations and financial goals.

Initiating the process to invest in SIP

Once you have decided on the mutual fund, you can initiate the process to start investing in the SIP. It typically involves three basic steps. Below are the details on how easily you can complete these three steps and start your SIP fund.

invest in SIP

Step 1: Arrange your identity documents

Typically, you will only require basic identification to start investing in an SIP. These include your PAN Card, an address proof which could be your driving license, bank statement or Aadhaar card, a passport size photograph and your chequebook.

Arrange your identify proof (documents)

You will need the chequebook for verification of your bank information. As such, there is no compulsion to have an Aadhaar card but having it will make the whole process lot simpler.

Since you can complete this process online, an active internet connection is the need of the hour. With these basics, you can complete the registration process and get started with your SIP in a jiffy.

Step 2: KYC Compliance

It is essential you fill in the KYC compliance form to get eligible for investment in the SIPs. The KYC requires you to provide basic details such as your official name, date of birth as per your identification documents, mobile number, and address. You will need to complete the KYC compliance process just once even though you may be planning to invest in several mutual fund or SIP schemes.

KYC compliance

If you prefer to go online, you can use the eKYC facility that is easy and convenient to use. Most reputed mutual fund companies allow you to complete the KYC formalities online as long as you furnish soft or scanned copies of the required documents.

Merely fill in the necessary details in the online form and upload soft copies of your official documents such as your PAN card and address proof to support the details mentioned in the form. Once you submit the online form, the KYC process will be initiated, and a representative from the mutual fund company will conduct a video call to complete the KYC process.

Just remember, using your Aadhaar card to fill digital KYC form will make the process much easier and quicker as details in the card can be linked to pre-populate the form. If you adopt this measure, there will be no need to have a conference call with the mutual fund representative.

Step 3: Going the online way

Once you have completed your KYC compliance check and have decided the mutual fund you want to invest in, you can check the web link of the mutual fund company and choose the shortlisted SIP.

Going the online way

There are different funds based on the level of risk you are willing to undertake. In case you are a first-time investor, it is recommended you start with low-risk funds that have average returns.

The Bottom Line

You can start the process of investing in the SIP by registering yourself as a new investor and fill in some basic personal details. You can then choose your username and provide a password for accessing your SIP online. As SIP is a regular investment plan, you can submit your bank details and set up an auto debit with your bank for a monthly (or the frequency you have chosen) payment into your SIP. You can also select the date you will invest in the SIP every month based on your convenience.

 

Other Articles :-

 

How to grow your wealth by saving taxes?

No matter what your chosen career, the fact is that everyone works very hard to earn money. People sweat day in and day out to fulfil their professional commitments and the reward is their salary. If this salary only serves the survival needs, the whole purpose of the hard work remains unfulfilled, as future is uncertain and preparing for it financially is the only certain thing you can do.

save taxes

With regards to your earnings, savings can grow only when you have enough money left in hand after your regular financial commitments like utility bills, child’s education, and monthly groceries. These regular expenses cannot be avoided, but what about the taxes?

A major part of your income, as much as a third, can go away in government taxes. However, there are some legitimate ways in which you can save on your taxes and grow your wealth. Of course, business owners have several ways to reduce their taxes to the government, salaried individuals too have ways, but they are quite different.

Plan your investments wisely to meet your goals and avail tax benefits

plan investment wisely

Saving on your taxes and at the same time growing your wealth is not a hypothetical situation. Investing your money in the right investment avenues can help you in this regard. Before you consider the different tax-saving options available to you, it is important to evaluate your goals.

Savings for tax benefits should be with an investment objective. You should analyse your professional and financial growth in the next 3, 5, 7 or 10 years and plan your investments accordingly. Depending on whether you have short term or long term goals, you can choose the appropriate investment tools.

Here are a few options available to salaried individuals to save on taxes

Step 1: Save taxes through interest payments on your loans (Section 80E and Section 24B)

save taxes through interest payment on loans

Education Loan (Section 80E)

Higher education can be a great way to not just secure your child’s future but also get some immediate tax benefits by way of education loan. Under Section 80E of the Income Tax Act, interest paid by the assessee on the education loan during the previous assessment year is completely deductible for seven subsequent years from the year the assesse started paying the interest.

Home Loan (Section 24B)

Just like education loan can help you avail some income tax benefits, home loans also quality for tax benefits. Besides being a long-term asset for you, your home also makes you eligible for tax deductions. You can claim a deduction under 80C for up to INR 1.5 lakhs for the repayment of the home loan principal.

Apart from this deduction, you can claim deduction for interest payments under Section 24B. If the home loan is a joint loan with your spouse, the tax deductions are available to both you and your spouse, thereby you can get optimum tax benefits as a family

Step 2: Save taxes through investments (Section 80C)

saving taxes under section 80C

Section 80C of the Income Tax Act allows for tax benefits for expenses incurred to the assesse for investing in certain specific investment vehicles. For eligible investment tools, 100% of the amount invested or INR 1,50,000, whichever is less is deducted from the taxable income of the assesse. Here is the list of eligible investment tools for which the deduction is applicable.

• Life insurance premium paid for self or any dependant’s policy.
• Any contributions made towards statutory provident fund, recognized provident fund and the approved superannuation fund.
• Any contribution made towards Public Provident Fund.
• Amount deposited with the Post Office Savings Bank for a period no less than 10 years.
• NSC (VIII Issue) subscriptions.
• Investment with the mutual fund equity linked savings scheme.
• Any fixed deposits with scheduled banks for a period of more than 5 years.

Step 3: Save taxes through investment in your and your family’s health (Section 80D)

save tax through health insurance

Health insurance policy

If you take a qualified health insurance policy, the interest payed thereof is eligible for deductions under Section 80D. This deduction is available to a limit of INR 15,000 for self, spouse and children. An additional deduction up to the limit of INR 20,000 is available for insurance of dependent parents (if senior citizens and INR 15,000 if not senior citizens). The maximum deduction for health can be up to INR 40,000.

Future protection of your family

Life Insurance policies are in a way a form of financial protection that you can offer to your family in case anything happens to you. The premium paid towards life insurance policies is eligible for deductions under Section 80C.

Step 4: Save taxes through donations (Section 80G)

Tax Free

When you make any donations to charitable organizations, you are eligible to claim deductions from your taxable income under the Section 80G. There are various donations that are specified under the act, which are eligible for either 100% or 50% deduction from the taxable income of the assesse.

Step 5: Save taxes through contribution to the New Pension Scheme (Section 80CCE) and National Savings Certificate

Save tax under pension scheme and NSC

Under the regulatory issued by the government agency – PFRDA, salaried employees can avail tax benefits with contributions to the New Pension Scheme. Apart from the tax savings, the returns are linked to the market and thereby the tax paying individual can also grow his wealth.

Salaried individuals can also claim tax benefits of up to INR 1,50,000 through investment in the National Savings Certificate (NSC) scheme. The interest rate of the NSCs is fixed every quarter and is linked to the government security rates. The interest rates also depend on the lock-in period of your investments. While the interest earned on NSCs is fully taxable but the same can be re-invested.

Breaking the shackles

There is a general misconception among people that tax savings can only be availed through insurance policies. However, that is not the only source. A balanced portfolio of health policies, ELSS mutual funds, PPF and the New Pension Scheme can help salaried individuals save taxes as well as grow their wealth systematically.

Other Articles:-

How to start saving from a young age?

Whether you believe it or not, you are never too young to start saving. As a matter of fact, the whole idea of getting your child a piggy bank is to instil in him the idea of savings from the very time he starts identifying the need of using money to buy things that he wants.

It is true that savings don’t come naturally to most people because the idea of earning is to be able to spend. However, if from a very young age, an individual learns the importance of savings, there can be nothing that can stop him from enjoying the fruits of his efforts at the time when he loses the physical ability to earn.

Introducing the importance of saving to the youth

It wouldn’t be wrong to state that the youth comprise the majority of the Indian population and that being said, there has been an increasing inclination of the working class to shift towards the youth.

importance of saving to the youth

With more and more young graduates finding their dream jobs too early in their lives, the youth of today is enjoying better earnings in their initial years of career. This has relatively reduced the real value of money in their eyes and typically, an average youngster ends up spending all his earnings as they feel their needs are met.

It is, hence, extremely important to introduce the idea of savings in young minds by inculcating in them the uncertainty of jobs and health.

The youth of today have to understand that people who start saving at a young age have an enormous advantage over others as their life moves on.

How can you start your savings when you are young?

Not every person wants to work till he is reaches the age of 60. Yet, the fact remains that most people continue working hard in their old age simply because they cannot afford to not work.

start saving from young age

While it may seem difficult, the idea of retiring young and leading a happy and peaceful old age isn’t something that is absolutely impossible.

You can follow your dreams of retiring young with some perseverance and with persistence on discipline in leading a balanced life. Here are some feasible, doable steps that you can start immediately if you are in your early 20s so that you enjoy not just now but also your late sixties.

Step 1: Decisions, decisions and decisions

decisions

Saving money for the future is more about some right decisions than just putting money aside. The fact is that your savings should not stagnate, but grow too. This implies you need to figure out a lot about your career graph and your investment tools. Here are some important decisions that will change the course of your investments.

a. How young is really young?

how young is young

Among the various decisions that you will take that will have a big impact on your life’s earnings and savings, the first most important decision is to understand how young is really young on when you want to retire. Here, you need to be very practical with your estimation.

If you are 27 and do not have any net worth to yourself, you cannot imagine you could retire when you are 30. The younger you want to retire, the younger you would need to start your savings because that’s what you are going to rely on when you do stop working.

b. Manage your finances right

Before you start planning your savings and which investment tools are ideal for you, you need to understand how you truly manage your money. There are several people who may have win lotteries, but lead miserably poor lives.

It all goes down to managing your money not how much you earn when you are looking at learning how to start saving young. Work on a budget and be very disciplined with your spending – these are the basic things that you need to incorporate in order to start savings young.

c. Get yourself the right educational qualifications

get right education

Quality education always goes a long way in ensuring that you have a more reliable future ahead. When you have a college degree, you are in a better position to decide your career moves and take positive steps towards creating a brighter future.

Young individuals should consider their education as an investment in their future and work towards utilizing their education in their professional growth. With the right education comes the right decision-making skills that can help young individuals to save their earnings for their brighter future.

d. Save early for a happy and content retirement

Savings

There is a very simple idea behind your investments – the earlier you start; the sooner you can stop working. Inculcate the habit to save and save regularly. Consider easy investment tools such as the SIP mutual funds that encourage regular savings.

When you get in the habit of saving regularly, you will discipline yourself in your financial spending habits and carve for yourself a financially secure future.

Step 2: It is not about saving but saving right!

saving right

While savings as a habit needs to be developed, in order to get the right benefit out of it, you need to learn how to start saving right. Here are some things young savers should keep in mind.

a. Get-rich-quick scams are just that, scams!

scams

Just like there is no shortcut to success, there is no shortcut to a savings plan. Don’t get fooled by easy money scams as there is nothing as easy money. It is for nothing that people refer to their savings as hard-earned money because it is really not an easy task to accumulate a life’s savings. When you start young, you are likely to do much better.

b. Purchase appreciating assets

purchase appreciating assets

The youth are typically driven by their fantasies. The young working professionals start making good money in the initial years of professional life and the next thing you find then doing is buying expensive cars and other such assets that tend to lose their value as time passes.

These are known as depreciating assets. For those who want to start savings at a young age, investment in appreciating assets such as real estate and stocks is a more sensible recommendation.

c. Work at creating a passive income source

create passive income

There is nothing as wonderful as having a passive source of income to cover all your bills. You can invest in a business or have your own blog with advertisements that will generate income. Evaluate your interests and identify options that you can monetize.

When you start young, you will have a long time on hand to grow your passive income and this will eventually contribute to your plan on savings.

Using these measures, you can begin saving from a young age. Remember, it all begins with the piggy bank and continues into early and middle adulthood. Those are the years you should be saving the most so that later in life, you have built a nice little nest egg to retire without worries.

Other articles:-

How to find the best hotels while planning vacation in India?

Like any other country, India has a plethora of choices when it comes down to picking a hotel. Choosing a hotel based on your comfort, location, budget and other factors can be a tricky task. That is why you need to know how to proceed when it comes to picking a place for your brief stay in India.

Picking a hotel for your stay might be something that you will like to postpone to the very end, but there are quite a few things that you have to consider while going for one. So, read along and bear in mind the things that we are about to tell you about the things that you should know about the hotels in India.

Things that need special consideration while picking a hotel in India.

You need a place to stay for a couple of days, so following a few simple steps can help you save time and reduce the frustration that a bad place can bring with it.Location : Are you here on vacation?

Then, you will want to stay in a hotel that is near to all the tourist spots. This will help you to roam around all the places with ease. This saves a lot of time too. But, if you are here on a business trip, then your workplace should be your priority.

Another thing that you have to consider when you are selecting a location is the availability of shops. Pharmacies, malls, railway station, bus stops and airports should be nearby too.

This is going to make your vacation way more sorted.

Location: Are you here on vacation? Then, you will want to stay in a hotel that is near to all the tourist spots. This will help you to roam around all the places with ease. This saves a lot of time too. But, if you are here on a business trip, then your workplace should be your priority.

hotel location

Another thing that you have to consider when you are selecting a location is the availability of shops. Pharmacies, malls, railway station, bus stops and airports should be nearby too.

This is going to make your vacation way more sorted.

Security: You have to be certain about the security of the hotel that you are going to be in. It is always better to be in one that has proper guards and CCTV cameras on each floor. Try to carry your locks rather than using the one that the hotel provides you with.

Hotel - security - CCTV

Your budget: India is a country with way too many choices when it comes down to hotels. You can be in a hotel that offers five-star service and even be in one that hardly charges a couple of bucks on a daily basis. The five-star hotels in India will treat you like a celebrity but more than often it remains beyond the budget. On the other hand, hotels that charge two to three dollars a night are a bit risky.

There can be security problems, bed bugs, hygiene issues and of course mosquitoes. So, do select one that suits your needs and fits in your budget.

Food: Are you planning to be in a hotel that gives out complimentary breakfasts and dinners? Or has similar arrangements? Or are you willing to try different dishes as you visit the tourist spots? This entirely depends on you.

variety of Food at hotel

WiFi: In today’s era, nothing can be accomplished without a proper internet connection. Make sure your hotel has free WiFi, and it is available everywhere in the hotel. It shouldn’t be confined to the lobby or the halls.

Wifi at hotel in every corner

Booking: When are you planning a vacatioono to visit to India? You should book your hotel at least a month before your arrival. If you plan a trip at the last minute, then take care of the hotel booking two days before you arrive.

Look for deals: There is nothing that is better than package deals. Deals or packages can include a lot of things. There can be spa vouchers, complimentary lunch, and other deals. This way you get your money’s worth services.

look for packaged deals

Brands: To stay ahead of every problem and receive the best hospitality from your hotel staff, it is better to pick a brand. Not only are they trustworthy but they will also take care of you like no one else.

Keep your kids in mind: If you are taking your kids along, then look out for hotels that have some exciting options when it comes to their entertainment. A wide range of hotels today have these options.

Some tips that will come handy while picking a hotel.

There is nothing wrong with a myriad of choices, but sometimes these choices can be overwhelming. So, consider the following things when you choose your hotel in India.

Car Parking – Does your hotel have car parking? This is something that you have to look out for.

View from the windows – Depending on your location pick a hotel that comes with a hill facing or sea facing room.

Read Reviews – Almost every hotel today has reviews and ratings on the internet. Make sure the hotel you pick for your stay has good reviews and a minimum of a four-star rating.

Toilets – Although 95% of the hotels in India today have commodes, there is a chance that your hotel has a traditional Indian toilet. These toilets may not be convenient for you, so check this factor out.

Frauds – Never trust a tout who waits outside airports or railway stations. Make sure you don’t go to the hotels they ask you to.

Traffic – We asked you to book a hotel that has proper connectivity to the rest of the city, but your room shouldn’t be facing the streets. India faces the problem of unnecessary honking. If it is possible decide on a room that doesn’t have a window facing the streets.

24 Hour Service – If you are arriving late to a particular destination then you have to remember whether or not your hotel is open at all hours.

Electricity – You have to brace yourself to unexpected load shedding. Your hotel should have a twenty-hour power backup facility.

Water – This might sound a bit strange, but the shortage of water can be a matter of concern. Before checking into a room be sure you ask about their water supply.

Finding a hotel that meets every requirement is a necessity when you are traveling to India. Every problem that a traveler once faced has been now sorted out by the internet. So, do make sure you keep all of these things in mind before you step into a hotel room in India.

Other Useful Articles:

How to disable Android Apps (without Uninstalling & Data Loss) and Enable them later?

Mobile apps have become an integral part of our lives now a days. We have app for everything – Starting from online buying to lose weight. We all love using them around the clock as they are easy to use, suffice the purpose well and saves a lot of time as well.

Android Apps

Instead of searching on the browser, searching for anything in the related app is hassle-free. It saves your data and time.

For example, if you are using an online shopping app, all your payment details, shipping address and correspondence address will be saved in there forever. No need to fill it up each time you place an order. But is not the case with the browser.

That is why we all love apps. Don’t we?

When we install an app on our Android phone, it certainly consumes certain space of our phone’s external or internal storage.

Even if you are not using it frequently, it keeps on running on background and consumes not only space but also make your phone hang a little bit. In that case, you need to uninstall the app. Now uninstalling that app might lead to losing all the data related to that app. Losing data is what we fear the most these days.

When we uninstall any program on Windows, it remembers all the data and auto-filled it when you re-install it again. But this is not the case with Android. The moment you uninstall the app, you lose the data related to that particular app. The reason for this is:

Your app uses two storage spaces to get stored on the phone. They are:-

1. Internal storage memory

2. External storage memory which comes in the form of SD cards and the App database.

In the majority of the cases, your apps will get stored in the App database as it is the most secure place for them.

To ensure the security of the system, the Android remembers the data only if the app is installed on your phone and available for use. Keeping the data of the removed app is not supported by the androids system.

In that case, how can you prevent losing the data of the related app for future reference?

Well, here is a way out.

We would suggest you disable the app rather than un-installing it completely. By making it disabled, you actually clear up a part of your phone storage space and can save the data as well.

If you do so, all the data will be retrieved back once you install the app in future. No need to fill up that data again.

Here are the steps.

1. Go to the “Setting”.

Go to - Settings

2. Go the “Application Manager” or “Apps”.

Application Manager - Apps

3. Open the app which you are not using any longer or what to uninstall.

Open the app no longer usable

4. Now, there will be two options available for you: Force Stop or Disable.

disable app

5. Choose Disable option. By choosing this option, your android system will actually make it disappear from your app lists and keep it stored in the background. All your app data would be saved for future references.

confirm app disable upon popup

This method is going to work only for those apps which come with your phones. The apps which you download from the Android app store won’t show up the Disable option.

It will directly show up the “Uninstall” option. If you have uninstalled an app which belongs to this category then we might fear that restoring the app data would be next to impossible.

However, apps which use your e-mail id and phone numbers to start or launch will be able to restore all your data forever.

For example, if you are using Paytm app which needs your mobile phone and e-mail details for login will be able to restore all your data automatically. So, if you uninstall that app then you are going to get back all the details once you re-install it.

Basically, the apps which need your login details will never lose your data. On the other hand, apps like gaming apps and beauty apps, downloaded from App gallery are hard to restore as they don’t need your login details.

To retrieve data related to that app, you need to take the help of some data restoration software available in the market. You can use this software to recover your app data.

Now, there are times when we need those disables app back suddenly. In that case, you need to follow these steps:

For inbuilt apps.

1. Go to the settings.
2. Open Apps.
3. Go the details of the respective app.
4. Click on “Enable” and you will be able to get back your app with all the data intact.

Enable app the same way you disabled

For downloaded apps.

1. Open Play Store.

2. Type the app name which you want to download and click on “Install “. Once you install the app then those who need your login details will automatically recover your data.

3. For others, you need to buy paid software like dr.fone, Helium Android App Data Back Up (it is a free app) and so on.

4. You can also try using ADB with the command: adb -d shell “pm uninstall -k com.package.name”.

It is a highly versatile commanding tool developed by Android only that allows you to build a communication with your device.

This client-server program helps you to perform some actions like installing and debugging effortlessly.

With the help of these simple and easy steps, you can easily get back your app data. All you need to go is just follow them and implement.

More articles you should read:

How to Create Windows 10 Bootable Flash Drive?

Windows 10 was launched in 2015. A bootable Windows 10 flash drive is just the vehicle you need if you haven’t upgraded or you want to install the latest version of Windows on another machine.

The USB drive will help you install a fresh copy of the OS (without being connected to the web if you have the Windows ISO file).

It is also an emergency repair utility to have around if your installation runs into a crash and you need to set up Windows from scratch. A clean install is always better than papering it with an in-place upgrade.

A bootable flash drive with the latest version of Windows is the simplest device to carry around in your pocket. It is also less damage prone than a DVD.

You can make your own bootable USB drive with the Windows 10 ISO file a series of commands from the Command prompt. But why bother when there are several easier alternatives available.

Use the Official Windows Media Creation Tool

You can easily create a bootable Windows 10 USB drive thanks to a handy official tool from Microsoft itself. The Windows 10 Media Creation Tool is easy enough to install and use for even the technologically challenged. Microsoft provides the steps to create the installation media, but these screenshots should make it easier for you.

1) Open the Windows 10 Download page. Go to the Create Windows 10 installation media section and click the Download tool now button.

2) Click on the downloaded software. Allow the User Account Control to run the tool. It will take a few seconds to prepare the Windows 10 Setup screen. Accept the license and move on to the next screen. Choose the

Create installation media option and then click the Next button.

Choose USB

3. Select the relevant language and Windows 10 version you have the license for from the selection field. Also, select either the 32-bit or 64-bit variant of Windows. Select your desired choices and click Next.

select language

4. Insert an empty USB flash drive into a free USB port on the computer. The Media Creation tool will detect the USB drive and prompt you if it is not there. Make sure the drive is formatted correctly and has at least 8GB of available storage space as recommended by Microsoft.

choose USB drive

5. Select USB Flash Drive and click the Next button.

select a usb flash drive

6. The tool will then download the relevant Windows 10 files and create a USB bootable version of the operating system. Select the Finish button when the process ends.

This bootable drive can now be used to create a fresh install of Windows 10 on any machine.

download windows 10

Remember: The Media Creation Tool lets you create Bootable USB Windows 10 Drive for the Official general release Windows 10 Build only and not the Insider Previews. For the latter you will have to head to the section below and the excellent third-party freeware.

Use Rufus – The Best Bootable Drive Installation Utility for Windows

The Windows Media Creation Tool does both jobs simultaneously. It downloads the right version of Windows 10 and creates the bootable flash drive in one go. But what should you do if you have already downloaded the Windows 10 ISO and then need to create a bootable Flash drive from that back-up?
Take the help of Rufus. Rufus also allows you to create bootable installation mediums for Insider Preview builds.

I am assuming you have already downloaded the Windows 10 ISO. Plug in your pen drive to the PC. Ideally, the Windows 10 32-bit version will need a minimum of 4GB and the Windows 10 64-bit version will need 8GB.

Now, we need to just download and run Rufus to create the bootable drive. So, download the executable and run it – no installation is necessary. Rufus will prompt you to check for any updates to the software online; skip this if you have downloaded the latest version.

Rufus

Configure Rufus to handle the installation. The settings are common to both 32-Bit and 64-Bit Windows 10 ISO files.

Device: Choose the bootable device you would like to install to.

Boot selection: Select the disk or ISO image option and then click the Select button and navigate to the location of the ISO file on your computer. This defaults the utility to create a bootable installation.

Partition scheme and Target system: MBR partition scheme for BIOS or UEFI-CSM

Volume label: Any name for the bootable installation. For e.g. Windows 10 64-bit ISO

File system: NTFS

Cluster size: Default value is 4096 bytes

Show advanced format options:

• Select Quick format as it works in most cases.
• Select Create extended label and icon files.
• Select Check device for bad blocks to test the integrity of the Flash Drive. If you are sure that the drive is okay, then leave this unchecked as the test can slow down the installation.

Press Start and Rufus will go to work. It takes less than 10 minutes for the whole installation to finish.

Rufus is trouble-free. But if you face any installation issues then head to this GitHub support page for common troubleshooting tips.

Keep a Windows 10 Bootable Flash Drive Nearby

Thanks to the fade out of bulky DVD drives, portable USB drives are the preferred medium. You can see for yourself that making a quick bootable flash drive is quicker than burning the bootable ISO to a DVD. Also, Rufus and the Windows Media Creation tool aren’t the only two utilities available. Here’s a short list of freeware you can look into:

1. UNetbootin
2. Universal USB Installer
3. YUMI – Your Universal Multiboot Installer
4. RMPrepUSB
5. XBoot

In the end, do remember that if you do a clean install you will need the original Windows license key. Key that in after the installation and you are good to go.

More helpful articles:-

How to Defragment and Optimize Hard Disk on Windows 10?

Defragmentation is one the key maintenance tasks you must perform if you don’t want a slow PC. Your hard disk is one of the slowest components inside the computer.

It stockpiles all your files, but it may not always save an entire file in one single space. When most of your hard disk is near its capacity, each part of a file is saved in the first available space the computer finds in the hard disk.

For an analogy, think how long it will take you to collate your documents if one part of it is on one shelf and the others are elsewhere.

What Causes Fragmentation?

It is caused when you create new files and folders or delete old ones. It also happens when install new software or just download stuff from the internet.

It can cause longer boot times and even computer crashes when the machine can’t read and write data effectively. The computer just has to work harder to get to all the bits of a file on your hard drive platters.

Defragmentation re-organizes the broken-up files and brings them together. It is the simplest housekeeping task you can perform to speed up your computer. Windows 10 has its own defragmenter built in. It is simple and does the job. We will talk about it but first let’s look into one of the more well recommended defragmentation programs in the market.

Auslogics Disk Defrag Free

Version: 8.0.14.0

Download Size: 11.8 MB

Supports: Win XP, Vista, 7, 8.1, and 10.

Auslogics Disk Defragmenter

Auslogics Disk Defrag Free is one of the most well-regarded software for any Windows PC. There is a Disk Defrag Pro also, but the free version is a capable tool for personal use. You can also try the Portable version which does not need an installation and can be run from a Flash drive.

Let’s install Auslogics Disk Defrag Free and run it through its paces. The installation wizard will take you through three screens.

Auslogics installation screen

For a cleaner install without any extra bloatware, opt out of installing these three extra programs in the next screens by unchecking the boxes.

    1. Shield Defense Add Blocker on Chrome
    2. Auslogics BoostSpeed
    3. Auslogics Driver Updater

The installation runs its course and the software launches on the main interface. You can cycle through the four screens which address four different tasks on the computer.

Auslogics disk defrag different options

List of Disks: Select the drive you want to defragment and watch the progress.

Scheduled Defragmentation: Configure automatic defragmentation at a time of your convenience.

Offline Defragmentation: Set defragmentation when the computer is offline.

SSD Optimization: Ignore this screen as SSDs do not need fragmentation and any defragmentation can degrade its performance over time.

You can run your first defrag with the slower Defrag and Optimize command. Auslogics Disk Defrag can launch a Quick Defrag and skip the analysis of your disk. You can also go into Program Settings and allow the software to remove all temporary files before it starts the defrag. This can help optimize your free space and speed up the defragmentation.

Auslogics program settings

Key Features of Auslogics Disk Defrag:-

• Free for home and commercial use.
• Runs scheduled defrags and also when system is idle.
• It can move common system files to a quicker part of the disk.
• User can set defrag priority and exclude specific files and folders from defragmentation.
• Visual map of the most fragmented files as well as the location of each fragment on the disk map.
• Applies smart optimization by consolidating free space and shifting regular files from the Master File Table (MFT) Reserved Zone.
• Disk Defrag can defragment hard drives with as little as 1% of free space available.
• It can check and correct errors on a drive.

The Built-In Defragmentation Tool: Windows 10 Optimize Drives

Windows has always included a disk defragmentation tool. While it is not as full-featured like Auslogics Disk Defrag, it is capable enough to handle the basic task. It comes with the added advantage of being in-built and without bloatware or adware which some of the free tools suffer from. It is a simpler option if you get flummoxed by the complicated options in a third-part tool.

default windows 10 defragment and optimize tool

To run a Windows 10 defragmentation, follow these steps:

1. Type “Defragment” in the Search bar and select the Defragment and Optimize result when it pops up.

2. Select the hard drive you want to optimize and click Analyze. If amount of defragmentation is more than 10% then run the tool, else you can skip it this time.

3. Click the Optimize button to start defragmentation. Once the process complete, the status should change to “0% fragmented”.

4. By default Windows automatically defragments every week. But change this schedule around your workflow. Click on Change Settings.

5. Keep the Run on a schedule checkbox selected and use the dropdown to pick a frequency from: Daily, Weekly (default), or Monthly.

Windows 10 - defragment tool schedule

6. Check the drives you want to apply the new schedule.

7. Click OK to apply the settings. The click Close to close the defragmenter.

Windows 10 optimization is better than earlier operating systems. Even then, if you have a traditional hard drive or an external storage drive that sees heavy use, then you should occasionally run a manual defragmentation.

Keep Your Disk Healthy

Even though solid state drives are gaining popularity, hard disk drives still rule the roost. If you have the latter, keep using a disk defragmenter to keep your drive running smoothly. For those with SSDs, remember that SSDs don’t come with moving parts. Defragmenting them often is not recommended. Also, Windows defragment SSDs once a month if necessary and if you have System Restore enabled.

What is your defragmentation schedule? Do you prefer to run it manually or keep it on automatic?

More helpful articles:-

How to prevent ads from appearing on Youtube videos?

ads on youtube put us offThough watching your favorite videos on YouTube are indeed amazing, those not-so-welcoming ads that keep on popping every now and then are highly annoying.

Who want an interruption in the middle of an interesting scene from “Friends” or how annoying it is to wait for the ad to finish first to see “The Simpsons”?

There are ads everywhere on YouTube. Banner ads that almost cover the whole website, then there are pre-roll ads that will auto-play before your favorite video.

The worst part is that you have to actually wait for good 2-3 minutes to skip the ads.

At last, there are mid-roll ads that come from no-where when you are watching long videos like movies and TV shows episodes.

This whole ad thing actually puts you off. But there is good news. You can actually block those ads to appear and take a delight of uninterrupted entertainment.

Wondering how?

There are our tips to prevent those ads from showing up again and again.

For Chrome Users : If you watch YouTube videos in Chrome Browser then you need to follow below-mentioned steps to block those annoying and unwanted ads.

1. Open you, Chrome Browser.

2. Type “Chrome Web Store” in the search bar and then hit “Enter”.

type : chrome web store in address bar

3. To find an ad block extension, type “Ad Blocker” in the search bar.

search : ad blocker

4. Now there will be a list of all ad blockers available in the market. Choose one of your choices and then click on “Add to Chrome”.

now add to chrome

5. Once you choose the desired extension, click on “Add Extension”.

Click on : Add Extension

The extension has been added to your Chrome browser and now you can enjoy your videos without any boring and unwelcoming ads.

To check whether it is working or not, we would suggest you play one video on YouTube just after adding the extension.

If you still see those ads then chances are high that ad blocker extension won’t be of a good grade. Remove it from your chrome and try another extension.

For Firefox Users : Follow these steps to prevent ads on YouTube when you are using Firefox.

1. Open Firefox browser.

2. Click on “hamburger icon”. Hamburger icon is the three horizontal lines located at the topmost corner of the site.

click on hamburger icon - three parallel lines at the top

3. Choose Add-ons.

get add ons

4. Scroll down and click on “See More Add-ons”.

scroll down and see more add ons

5. A new will open in front of you and then you need to type “Ad Blocker” in the search button. Hit “Enter”.

firefox add ons

6. Choose the one from the list.

choose one from the search results

7. Once you choose any particular add-on, click on “Add to Firefox”.

choose any add on and click on add to firefox

8. Grant it permission by clicking on “Add”.

grant permission and 'click on add'

Play a video on YouTube to check whether it is working or not.

For Internet Explorer users : Internet Explore exactly don’t support any extension especially the built-in ones. To block the ads, you have to navigate directly to the site of any high-end ad blockers website and install it from there. Here are the steps.

1. Open Internet Browser.

2. Search for any particular ad blocker and go to the website.

3. Choose “Agree and Install for Internet Explorer” and then click on “Run”.

4. If any User Account Control windows open ups then click on “Yes” to proceed with the installation process.

5. You need to close the Internet Explorer to complete the installation. If you don’t do that then you have to go through a long reboot process. So, click on ‘Yes” when windows take your permission to close the Internet Explorer.

6. “Next” followed by “Install” and then “Finish”.

7. Once this is over again open Internet Explorer.

8. A new pop up will be visible on the bottom of the page. This is your ad blocker. Click on “Enable”.

9. Close the window.

10. Open a new window again and start playing a YouTube video to check whether the extension is working or not.

For Microsoft Edge users : A new entry in the browser’s category, Microsoft Edge still has many scoops for improvement. Though Microsoft is burning the midnight oil to make it more robust, it still lags way behind than its predecessors like Firefox and Chrome.

Open Microsoft Edge browser

Recently, Microsoft has added few extensions in the browser but Ad Blocker Plus is not in the list. Maybe it will come after some time.

You need to search for a suitable extension that will help you to block those irritating ads. Extensions from Edge are available at Microsoft Store.

1. Open the browser and click on the Menu. The menu is identifiable with three horizontal dots.

click on three dots top right hand corner

2. Choose “Extension” and then “Explore more Extensions”. Now, you will be directed to the Microsoft Store.

choose extension

3. Search for the ad blocker extension. Not many options would be available.

choose adblocker extension from the list

4. Upon finding one, click on “Get” to install and download the extension. It will direct you to the Internet Explorer.

add ad guard blocker

5. When you hit “Launch” once installation is complete, you will be directed back to Microsoft Edge.

6. Open Edge and look for an added extension.

7. Click “Turn it on” option to make it function.

8. Open YouTube video and check the operation of the extension.

Enjoy a video without any unwanted ads is what we all want. With the help of these simple and easy to implement steps, you can actually achieve it. So, why wait? Enjoy uninterrupted entertainment.

See more articles:-