category
home / developersection / category
Creating a Reference to another Sheet or Workbook
Creating a Reference to another Sheet or Workbook
Count Workdays between Two Dates in Excel
Count Workdays between Two Dates in Excel
Sum Function in Excel
This article I have explain how to used sum function, when working with excel. For example calculate student mark, product total price or total quantity. Sum formula used with many condition that described one by one below with example.
Pivot Table in Excel
In this article I’m going to described, how to used Pivot table for displaying record in query based. In another works we can filter and display data according our requirement. Suppose you've a large list of data in excel sheet
Merge Cells in Excel
This article explain how to merge cells in excel. Using this feature we make our document more stylish and well format. You can merge two or more neighboring cells into one cell and display the contents of one cell in the merged cell.
How to do percentages in Excel
In this article I have described to calculate percentages between different cell values. For example compute a sales tax, or determine a percent change in sales between two fiscal quarters etc. There are several ways to calculate percentages.
