Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...
We have discussed rounding the numbers using CEILING and FLOOR functions through my previous Article “Microsoft Excel – CEILING and FLOOR functions“. Excel provides another set of functions; provides a similar kind of functionality to round the numbers. Through this article, we are going to discuss these functions. ROUND, ROUNDUP and ROUNDDOWN functions in Excel […]
As part of Excel functions discussions, we are going to discuss two functions through this Article; which are CEILING and FLOOR functions. The CEILING function This function returns the rounded-up number which is nearest to the specified multiple of significance. It is important to understand that, the return number is based on the specified significance; […]
Excel allows the creation of multiple Worksheets in each Excel Workbook. And it provides Tabs to manage the Worksheets. You can hide or show these Worksheets inside the Workbook. When the Worksheets are hidden, you can not see the associated Tabs. Tabs can be visible only when Worksheets are Visible. And Excel provides an option […]
Most of the time while dealing with the data in Microsoft Excel it is required to find the duplicate rows and remove them. Fortunately, Microsoft Excel provides a feature to find and remove the duplicate rows within the Excel Worksheet. This article applies to: Microsoft Office 2010 Step (1). Open your Excel worksheet and select […]
Microsoft Word provides the feature to allow the user to insert current dates and times in different formats. This article explains the steps to insert the current date & time in a Word document. This article applies to: Microsoft Office 2010 Step 1. Open Microsoft Word document. Step 2. Place the cursor where you want […]
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 […]
Microsoft Outlook allows creating/scheduling meeting requests for face-to-face meetings or online meetings. Microsoft Outlook allows to create, re-schedule, or cancel the meeting requests. This article explains all these. This article applies to: Microsoft Office 2010 Step (1). Open Microsoft Outlook application. Step (2). Click on the Home tab and click on the New Items button. […]
Microsoft Word Application provides the feature to compare two Microsoft Word Documents and display the results/changes in review pane. This article explains how to compare two-word documents in Microsoft Word Application. This article applies to: Microsoft Office 2010 Step (1). Open Microsoft Word Application. Step (2). Click on the Review tab. It will display Review […]
Add-Ins are useful to provide additional functionality or features in Microsoft Office Applications. That means, Add-ins are useful to extend the Application features. To enable the feature, we need to enable the Add-In. This article explains, how to manage Add-Ins in Microsoft Office Applications. This article applies to: Microsoft Office 2010 Step (1). Open Microsoft […]
