As part of Excel functions discussions, we are going to discuss about 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 […]
Microsoft Excel 2013 – Why can’t I see Tabs in Excel?
Excel allows to create 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 to […]
How to display Developer tab in Microsoft Excel 2013 ?
Microsoft Excel has great features to allow the Users to easily work with the Work Sheets. And some of the features are allowed 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 […]
How to add a pivot table in Microsoft Excel?
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 […]
How to convert Columns to Rows (OR) Rows to Columns in Excel?
When we use Microsoft Excel, sometimes it is required to rotate the data from columns to rows and vice versa. 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 the location in the spreadsheet where you […]