Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...
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 […]
Microsoft Excel has great features to allow Users to easily work with the Work Sheets. And some of the features are allowed you to write programming; for example, macros. Some of these features can be enabled or disabled through Microsoft Excel Options. Once the options are enabled, Microsoft Excel will display the Controls / Icons […]
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 […]
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 […]
