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

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

Using Ranges In Excel

A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its address, which consists of its column letter and row number. For example, cell B1 is...

ITech

0 0

Dynamic HyerText Markup Language (DHTML)

Dynamic HyerText Markup Language (DHTML) is a combination of Web development technologies used to create dynamically changing websites. Web pages may include animation, dynamic menus and text effects....

ITech

1 0

Learn in Excel To Create a LIST in One Minute

Sanjay singh

7 0

Hidden Gems of MS Excel - Reapply Filter

Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Ankur

0 0

PowerPivot For Excel

PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...

ITech

0 0

Find MS Office Software Training near you

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

Are there any excel and VBA coaching centres at As Rao Nagar?

15 Answers

What are the best practices when modelling in Excel?

6 Answers

Hi All, My question is how to define age calculation in excel by formula?

24 Answers

Why do we use a dollar sign in Excel?

8 Answers

What is Microsoft Excel?

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.