How to consolidate multiple sheets into one sheet in excel

Consolidate in Excel

Description : Excel Consolidate helps you to consolidate your sheets/worksheets into one worksheet.
 Here we are going to consolidate 3 sheets unit1 , unit2 and unit3 to one sheet. the three sheets are shown below. Excel tips and tricks by +belazy .

How to sum up all the data in separates sheet into one

Receipts and Disbursement

Receipts and Disbursement of a single unit

Receipts and Disbursement

Receipts and Disbursement

Now click on the consolidate icon, it will be available in Data tab in excel 2010.

 

 A window will be open now, choose function as Sum (here we are going to sum up all the sheets)

click on the reference, choose the data table in sheets ancd click on add

 

check Top row & Left Column.

Consolidate Sheet

Consolidated excel sheet

To view the video tutorial : click here

To Know more about Cash Receipts and Cash Disbursement method in accountancy click here

Where to use : 

Author : +belazy

Thanks to +deepajayaprakash payyanakkal  for her support

+Consumerfed IT Division

Similar posts

create a commodity sales graph

multiple user sharing a  excel sheet

Similar posts

1. Taking reports using pivot table in ms office excel
2. How to share an microsoft office excel to work multiple user simultaneously
3. consolidate many table to one using consolidate option in ms office excel
4. Working with pivot table in microsoft office excel 2010
5. working with share point in microsoft office
6. create a internal chat application in organization

http://javabelazy.blogspot.in/

Design pattern in java

Desing Pattern 

                       In software engineering, a design pattern is a general reusable solution to a commonly occurring problem within a given context in software design. A design pattern is not a finished design that can be transformed directly into code. It is a description or template for how to solve a problem that can be used in many different situations. So patterns are formalized best practices that you must implement yourself in your application. Object-oriented design patterns typically show relationships and interactions between classes or objects, without specifying the final application classes or objects that are involved. Many patterns imply object-orientation or more generally mutable state, and so may not be as applicable in functional programming languages, in which data is immutable or treated as such.

Design patterns reside in the domain of modules and interconnections. At a higher level there are architectural patterns that are larger in scope, usually describing an overall pattern followed by an entire system.

                    There are many types of design patterns, like Algorithm strategy patterns addressing concerns related to high-level strategies describing how to exploit application characteristic on a computing platform.

                    Computational design patterns addressing concerns related to key computation identification. Execution patterns that address concerns related to supporting application execution, including strategies in executing streams of tasks and building blocks to support task synchronization.

Implementation strategy patterns addressing concerns related to implementing source code to support program organization, and the common data structures specific to parallel programming.

To Know more about Design pattern in java 

link : http://www.javacamp.org/designPattern/

--

Thanking you...

Information Security and Cloud Computing

Cloud Computing

its the fastest growing technology. Every companies is shifting to cloud as a part of green IT, pollution is less since there will be no CPU because our cpu emits much carbon monoxide gas Even though security is a major issue. End user needs only a browser enable system to use their resource. Three types of services are provided by cloud software as a service, platform as a service and infrastructure as a service. Intel has now arrived with latest technology that support cloud. Salesforce is the major software used to develop cloud. its works on visual force , apex and soql.
 

 

link : http://www.intel.com/content/www/us/en/enterprise-security/enterprise-security-intel-it-malcolm-harkins-best-practices-video.html

pdf : http://www.intel.com/content/www/us/en/cloud-computing/cloud-computing-security-planning-guide.html

Thanking you...