true

Learn MS Office Software Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Shortcut for adding big data or Columns in MS excel

Kimsi J.

19/07/2019 0 0

1. Simply click on the next cell of column where you want the sum.

2. Press Alt and = keys together.

3. It will show the sum and range of sum.

4 Click Enter key and you will get sum of the column.

0 Like 0 Dislike

Follow 2

Saurabh Sharma | 12/09/2019

In advanced excel there are two way to get an answer first answer mam told us and know where you got the answer use the =sum() and select your range after that you will get your answers, both tricks give you the same answer

0 0

Other Lessons for You

HERE TODAY WE WILL USE THE SUMIF FUNCTION

A B C 1 PRODUCT NAME TOTAL AMOUNT 2 WASHING MACHINE 3616 3 MI PHONE 4978 4 SAMSUNG MOBILE 3825 5 NOKIA PHONE 3902 6 T.V 3759 6 L.G REFRIGERATOR 3693 7 BOTTLE 4191 ...

Saurabh Sharma

0 0

Datedif() Function

Purpose: This function calculates difference between two dates. it can show the result in days, months and years. Syntax: =datedif(start_date,end_date,"unit") start_date This is earliest...

Saburudeen MA

0 0

VBA Function - RIGHT

RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

Karthik Dale

0 0

SQL Join Types

There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

ITech Analytic Solutions

0 0

Some Excel Functions

You need to know about these following functions which are based on Microsoft Excel 2010.1. Speedily Move and Copy Data in Cells:-If you want to move one column of data in a spreadsheet, the fast way...

ICreative Solution

0 0

Find MS Office Software Training near you

Online MS Office Software Trainer

Looking for MS Office Software Training ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

MS Office Software Training Questions

What is the difference between an MS word, an MS Excel, and an MS PowerPoint?

5 Answers

Is there any free software to convert a word file to PDF?

7 Answers

in ms office how to set out a correct pagelayout in default

13 Answers

What are some cool Microsoft Excel tricks?

8 Answers

can i teach

35 Answers

Looking for MS Office Software Training Classes?

The best tutors for MS Office Software Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn MS Office Software Training with the Best Tutors

The best Tutors for MS Office Software Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.