Skip to main content

How to use Microsoft Excel?

Microsoft Excel


No matter you require generating reports, compute math or you require maintain records in soft copy, Microsoft Excel is the application that serves all these needs. This application comes loaded with various features that can robust your working needs. The purpose of this article is to discuss how to use this application to its full potential.

How to use filters?

As you can make it from the name itself this function enables users to find out specific data. This function comes very effective to find out specific data while dealing with larger spreadsheets. On the excel dashboard, towards the left-hand corner, there is an icon by the same name. You need to select on any column and then click on the filter icon. It will add filter dropdown. Once the drop-down appears, you can filter the entire spreadsheet as per your criterions.

How to remove duplicate entries?

If you are dealing with larger data sets, there are chances to encounter duplicate data. Hence, you need to have solutions to these problems. Fortunately, you can accomplish this objective in few simple steps. You need to highlight the column or row that features duplicated entries. Subsequently, you need to navigate to the Data Tab and click on Remove duplicate. You will get this function under the Tools menu. Once you make your selection, a pop-up will come up and it will ask you to confirm the data that you need to remove.

How to do mathematical calculations in excel?

This application helps users to accomplish various types of mathematical calculations. You can accomplish computations like addition, multiplication, division, and subtraction. You can use brackets to ensure that specific computations get done before the others. Users can even include formulas to the excel documents that will automatically do the necessary computations.

Steps to do condition formatting

You need to start with highlighting the cells where you aspire to apply this command. Go to the Home tab and select “Conditional Formatting” command. Subsequently, you need to pick your logic. If you want to set some unique logic, you can even do that. A pop-up window comes that asks for further information on the formatting logic. Once done, select “OK” for the coveted results to appear automatically.

How to use the Format Painter in Excel?

You should be familiar as for how to format the spreadsheet cells. Well, organized excel sheet gets a high appreciation as it makes it easier to follow the data as well as to do the calculation. Following are the steps to use the format painter:

·        You need to select the cell that you wish to replicate

·   Go to the Home tab and you require clicking on Format Painter icon. The application will display a painting brush, appearing immediately after the cursor.

·   Once the painting brush appears, you require clicking for applying the entire attributes from the selected cell to the others.

You need to get familiar with the steps mentioned above to ensure that you can reap the optimal benefits from the excel application.  

Comments

Popular posts from this blog

HOW TO USE FREE ANTI-KEYLOGGER GHOSTPRESS WITH WINDOWS 10/8/7

Sometimes people need to use an unknown computer to complete a task with Internet and they need to share some personal information there. This may compromise their personal information. When using a public computer, Key logging comes handy to people seeking such information. Key Logging is also known as Keystroke logging or Keyboard capturing. This feature enables information seeker to the recording of key struck on a keyboard. Users do not know that his actions are monitored by anyone else. This is a dangerous feature that compromises people’s personal information like the debit card, credit card and more. To overcome above situation it is always advised that you use an anti-keylogger app, at the time of using a public terminal with your personal information. This will not let other monitor your keyboard strokes. Software named Ghost press can be used to prevent capturing of keyboard strokes typed by you for windows. Ghost press is a free and easy to use program that preven

How to install MAC mouse cursor in Windows 10

Windows 10 comes with many options in mouse cursors. They can be changed with their Shape and Size, Their Black and White cursor are also good. But if you are interested in something different than Apple's Mac mouse cursors are available in market to satisfy you. How to install MAC mouse cursor in Windows 10 Now I will show you how to install MAC EI Capitan cursors in Windows 10.  Following steps will help you. Step 1.   Go to  http://in-dolly.deviantart.com/art/Updated-ElCapitan-cursors-593804414 . Step 2.   Now click on Download link which is in the right corner of website, When this Zip file completely downloaded, now open that Zip file using WINRAR , or locate the file and right click. Now select Extract All(if you have WinRAR installed in your device). Step 3.   After that select location, where you want to install that file on your Device. Step 4.   Now open that file and locate the file install.inf. After that click on particula

How to unlock Sony Xperia SOL24 by code

Unlock Sony Xperia SOL24 fast and secure with IMEI and unlock code. You can unlock all your Sony Xperia SOL24 from network restrictions or remove network restrictions from your Sony Xperia SOL24 locked to any network. We provide factory unlock code to free your phone for all networks. Unlock Sony Xperia SOL24 with its IMEI no and unlock code. You need to provide IMEI no to get unlock code for your Sony Xperia SOL24. To get IMEI from Sony Xperia SOL24 dial *#06# from your device or go to settings. We provide Factory unlock codes for Sony Xperia SOL24. Initially, Sony Xperia SOL24 comes to lock to a single network, but with the help of this post, you can easily remove network restrictions of your Sony Xperia SOL24 for all networks. You need the correct code to unlock this device. Do not enter wrong unlock codes on your phone. It may cause unexpected behavior on your phone. If, your phone is dual SIM then provide IMEI of primary SIM only. After inserting unlocks code into