Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...
Microsoft Excel provides the useful feature “Formula AutoComplete” to make it easier to create or edit formulas and to minimize typing and syntax errors. Once this feature is enabled, Microsoft Excel displays a dynamic drop-down list box containing valid functions, names, and text strings that match the typed letters in the cell. Below are the […]
PivotTable is useful to summarize the data in Microsoft Excel. PivotTable is generated based on the data source. PivotTable allows to sort/filter of the data displayed in the PivotTable. If we change the data source of an existing PivotTable; and when we attempt to filter/sort the data, PivotTable displays old data items along with the […]
To summarize the data in Microsoft Excel we can use the PivotTable tools feature. With the help of this feature, we can display the data into the most readable form. One of the interesting options it provides is showing the totals of each group which will be helpful to find out the group-wise sum of […]
In Microsoft Excel you can protect/lock the cells to disallow the users to not to modify anything in the cells. You can also select the options to not to allow the users to format the cells. This article applies to: Microsoft Excel 2010 Step (1). Open Microsoft Excel 2010. Step (2). Select the cells you […]
COUNTIF function in Microsoft Excel is useful to find the count of a number of cells that meet the given criteria. Below is the syntax of this function: COUNTIF(range, criteria) Here the range is any valid cell range. criteria are either number, text, expression, any valid cell reference, or any valid formula. It allows using […]
Microsoft Excel provides lot of features to the end users to experience rich functionality to easy to work with spreadsheets. One of the functionality is cell dragging; allows to automatically fill the data in cells depending on the data in the selected cells, like automatically fill the numbers, text, dates, formulas etc.,. This article explains how […]
PivotTable is useful to summarize the data and drill-down on details. This article explains how to add pivot table into Microsoft Excel Spreadsheet. This article applies to: Microsoft Excel 2010 Step (1). Click on Insert menu and select Insert PivotTable icon to insert the PivotTable. Step (2). Excel will open Create PivotTable dialog to allow the […]
Applies to: Microsoft Excel 2010 Step (1): Click on the Developer tab in Microsoft Excel; it will display the Developer tab. If the Developer tab is not visible, read the article How to display Developer tab in Microsoft Excel? to display the Developer tab. Step (2): In the Developer tab, click on the Insert button under […]
Microsoft Excel provides a wide range of options for Excel users. Microsoft Excel allows to create the Macros and run the existing Macros in Excel. To do this, there are controls added in the Developer tab; and this has to be visible in order to use them from the Developer tab. The following steps explain […]
We arrange the data in Microsoft Excel in rows and columns. Sometimes it is required to rotate the data from columns to rows and vice versa. The below steps explains how to do this. Step 1. Select the columns (OR) rows from Excel Spreadsheet. Step 2. Copy the selected columns (OR) rows. Step 3. Select […]
