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

Rand() Function

Purpose: Get a random number between 0 and 1. Return Value: Any decimal number between 0 and 1. Syntax: =RAND() Usage: RAND() function will returns a number between 0 and 1. For example, = RAND()...

Saburudeen MA

0 0

Advance Excel Training

This is reminder and follow database, ensure to priorities you work distribution

Kartik Dindi

0 0

Data Validation In Excel

MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between...

ITech Analytic Solutions

0 0

VBA Function - INSTR

INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

Karthik Dale

0 0

Use of Indirect Function

I would like to share my experience of how Indirect formula helped me in my recent project. I was working with some report which was connected to a large database in excel, so whatever changes I made to...

Kaustubh Chavan

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

Hi, my English is very poor. How I can improve my English?

11 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

VBA Training institutes in Bangalore?

18 Answers

Linear Programming in Excel ?? Can someone can solve just 1 question of Linear Programming in Excel ?? I am ready to pay. Thanks

5 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.