It is a Microsoft developed program, based on worksheets. In MS Excel, data is managed in rows and columns, it is used to do numerical functions mainly. Nowadays, MS Excel
Microsoft Excel is the most utilized application among the other Microsoft program. Excel is very helpful tool, it is used, almost in all sectors. The reason behind its widely use
Microsoft Excel is a spreadsheet based program. There are many more applications in Microsoft and windows, but MS Excel is most used application among all. The reason behind its widely
Microsoft Excel sheet is the most used sheet in the world. Almost in every office it is used to prepare data. Sometimes, excel has private or sensitive data. To secure
Count celsl equal too is part of COUNIT formula. There is a lot of formulas under countif category. In count cells equal to formula we will learn how to count cells cantainig
The COUNTIFS formula is used to count cells between two numbers in a specific criteria. Here we will learn how to count cells between two numbers using COUNTIFS formula. To count cells
The COUNTIFS formula is used to count number of cells in a specific criteria. Here we will learn how to count cells between two dates using COUNTIFS formula. Sometimes we
How to use IF function in Microsoft Excel If Function is very helpful formula and used vitally. This function is categorized as logical function. Here we will learn how to
Change Case in Excel You have come across with this situation many times in routine life, that you have large list of names with all Uppercase or Lowercase. It is
Uses of Name a Range Command Microsoft Excel has a lots of commands to make our working easy, whether we are working in name-a-range-in-excel office or doing personal work. Name
Microsoft Excel Shortcuts Microsoft Excel is widely used in daily routine. Even, if we are good in excel, we can make a big difference in our speed and can save
HOW TO HIGHLIGHT DUPLICATES IN EXCEL Very often, while we are working in excel, we get duplicate data. To identify the duplicate data there is a tool in excel
How to remove duplicates in Microsoft Excel While working in Excel sheets we get data in large amount to work. Sometimes it happens by mistake that our data is
How to use “Text to Columns” in excel Many times we get data in one cell like full name with address and we need to separate it in different
How to Add (Sum) data in Excel In Microsoft office, Excel plays a vital role. It has vast range of formula, in excel we can add (sum) the data
How to import text file in excel. In our day to day life it happens many times that we receive data in text (txt.) format to edit or modify, but
How to keep excel cell data visible in one cell (How to wrap text) In excel, wrap text is used to keep excel cell visible in one cell, in
How to change text orientation in Excel. In this lesson I will tell you how to use text orientation in excel. Text orientation is used in many ways to
How to make all data in 1 format in excel (Format Painter) Sometimes we make a sheet collecting data from different sheets. Sheets may have data in different formats,
Usually we copy the cell data by pressing “Ctrl+C” and paste pressing (Ctrl+V). When formula are used in cells, formula are pasted, but we need only cell data instead of
How to Merge 2 or more Cell into 1. While working in excel we need to merge 2 or more cells into 1. Mainly when are to make a
Sometimes we need to delete text in written data and want to delete the whole Row /Column or a particular Cell. To Delete Column/ Row there are several methods. I
How to Insert Column/Row in Excel Sometimes we need to add text in written data and want to Insert Row or Column. To Insert Column/ Row there are several
Sometimes we have to combine the data of cell in large number which is not possible to do manually. In this Situation this formula can be very helpful. First of
