QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Concatenate Multiple Cells in MS Excel 2016?

By Neha T Leave a Comment

Concatenate is a text function which is used to concatenate multiple cells in excel. The Concatenate function does not provide the delimiter. Like, it does not provide spacing between the texts that you want to concatenate. The Syntax of the Concatenate function is given below: =CONCATENATE(text1, [text2],......) In the above syntax, text1 is the first item to consider while … [Read more...]

How to Create a Pivot Table in Excel?

By Neha T Leave a Comment

The pivot table in Excel which allows you to arrange and summarize the complex data easily. You can create a pivot table within a few seconds without worrying about any formula. There are many advantages of using the pivot table as it fast and flexible. Below are the benefits of using the pivot table. Benefits of Pivot Table: A pivot table allows you to summarize and calculate the data … [Read more...]

How to Hide and Unhide Rows & Columns in Excel?

By Neha T Leave a Comment

Have you ever hide and unhide rows & columns in excel? In some excel sheets we store our everyday information like attendance of office staff, we create an everyday to-do list etc. Putting everyday data in an Excel sheet creates numerous rows and columns in the sheet. Too many columns and rows in the sheet makes it voluminous. Analysing such a voluminous spreadsheet become a headache. In … [Read more...]

How to Generate Random Number in Excel?

By Neha T Leave a Comment

Excel provides us with two formulas to generate random number those are, RAND() & RANDBETWEEN(). We can modify these functions to get random decimal numbers, random date, random time, random character. We can also calculate random text string to get a password. Well, there is a lot to do with this random function. In this section, we will discuss the steps to: RAND() Function … [Read more...]

How to Edit Dropdown List In Excel 2016?

By Neha T Leave a Comment

In our earlier post, we have discussed the methods to create the drop-down list. In case, you need to edit dropdown list i.e. if you want to add more items to the drop-down list or you want to delete the items from the drop-down list you can do it with few pretty simple steps.  In this section, we will discuss the methods to edit the dropdown list. We will edit the dropdown list using the three … [Read more...]

How to Delete Duplicates in Excel 2016?

By Neha T Leave a Comment

It happens that many times we got stuck in an Excel workbook which contains duplicates cells. It is difficult to understand the data with duplicates. Well, we can delete duplicates in Excel. Let’s see how? In this section, we will first learn to identify the duplicates in Excel and then we will see how to delete the duplicates? We will also discuss the scenario when there are multiple rows … [Read more...]

How to Delete Blank Rows in Excel 2016?

By Neha T 1 Comment

Blank rows or cells in a table create a lot of confusion for excel built-in functions to identify the data in a correct manner. So, to clean the data in the table we must delete blank rows present in a table that creates a disturbance while analysing the data. Well, if you are working with a large table in Excel and you keep on adding or removing entries in a table, definitely there will be … [Read more...]

How to Compare Two Columns to Find Matches & Differences in Excel 2016?

By Neha T Leave a Comment

There can be two reasons to compare two columns in excel either we have to find the matches or to find the differences. Matches are the data points that are present in both the compared columns. Differences are the data points that are in one column but not present in other column being compared. There are several ways to compare two columns in an excel sheet. In this section, we will discuss … [Read more...]

How to COUNTIF in MS Excel 2016?

By Neha T Leave a Comment

Have you ever operated the function COUNTIF in Excel? COUNTIF is a statistical function which counts all the cells that match the criteria we describe in the function. This function always returns you a count number that has met the criteria specified in the function. Let us discuss the syntax of the COUNTIF function: COUNTIF(range, criteria) range: Here, the range denotes the range of … [Read more...]

How to Count Unique Values in Excel 2016?

By Neha T Leave a Comment

It becomes messy to sort out the unique values in a large range of cells if it contains duplicate values. Let’s say if you want to identify or count unique values in excel, then you can build up your own formula for it. There are various functions available in Excel using a combination of which you can implement the formula to count the unique values in Excel. In this section we will discuss … [Read more...]

  • « Previous Page
  • 1
  • …
  • 8
  • 9
  • 10
  • 11
  • 12
  • …
  • 65
  • Next Page »

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Mute Someone’s WhatsApp Status?
  • How to Bold, Itaticize, Strikethrough & Monospace Text in WhatsApp?
  • How to Clear Chats in WhatsApp?
  • How to Mute WhatsApp Notifications?
  • How to Mute WhatsApp Group?
  • How to Send Photo on WhatsApp?
  • How to Block Someone in WhatsApp?
  • How to Add Caption to Instagram Post?
  • How to use Hashtag in Instagram?
  • How to Live on Instagram?

Copyright © 2021 · QueHow · Contact Us