June 14, 2016

How to sum up table into one 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 .

Date : Jun 14

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



Receipts and Disbursement
Receipts and Disbursement

Receipts and Disbursement of a single unit

Receipts and Disbursement
Receipts and Disbursement




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 , +Shimjith , +bithesh, +Vipin Cp   for their supports






http://javabelazy.blogspot.in/

June 13, 2016

CONSUMERFED TRIVENI REGIONAL OFFICE KOZHIKODE

CONSUMERFED IT-ACCOUNTS SECTION KOZHIKODE


Attendance Working Demo 




Loading and unloading spreadsheet



Sales entering spreadsheet apps for accounts section


Attendance monitoring system - editing




Preparing budget  - accounts section kozhikode





Excel consolidation for R & D preparation  - accounts section kozhikode






For salary consolidation   - administration section consumerfed kozhikode




Employee Management System   - information technology section consumerfed kozhikode




Foreign Liquor Shop Attendance Marking System Consumerfed Kozhikode




Visit our channel

Thanks to Regional Manager, deepa, jisha, rasmi, remya. shimjith, ashref, jerin , vipin and all triveni employees for their supports


http://javabelazy.blogspot.in/

Facebook comments