Saturday, December 29, 2018

Everything about Sum Function in MS Excel (3D Sum & Shortcuts for AutoSum)

Almost every Excel user will be familiar with the use of Sum Function in MS Excel. But are we making use every possibility of this wonderful function? For example the concept of 3D Sum.

In this Session, Different methods of using the Sum Function are explained in detail. Then about the concept of 3D Sum and a few Shortcuts related to Sum function. Topics discussed are : 1. Using Individual values inside Sum Function 2. Cell References inside Sum Function 3. Range References inside Sum Function 4. 3D sum for consolidation values from a series of sheets 5. Shortcuts related to Sum Function




No comments:

Post a Comment

Most Used Formula in Excel (15 functions explained in 20 minutes)

Most Used / Most useful 15 Functions in MS Excel are explained with simple Examples, in this video. A must watch Tutorial for Beginner and...