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

Functions in Advanced MS Excel

Introduction to Advanced Excel: Basic Understanding Menu and Toolbar, Introduction to a different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References,...

Sla Consultants India

0 0

WebSphere

WebSphere is a set of Java-based tools from IBM that allows customers to create and manage sophisticated business Web sites. The central WebSphere tool is theWebSphere Application Server (WAS), an application...

Itech Analytic Solutions

0 0

HTML (Hypertext Markup Language)

HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file intended for display on a World Wide Web browser page. The markup tells the Web browser how to display a Web page's...

Itech Analytic Solutions

1 0

VBA Tip: Print Random Numbers In A Selected Range

Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

Karthik Dale

0 0

Hidden Gems Of MS Excel - Consolidate

Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...

Ankur Sharma

1 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

can i teach

35 Answers

Need to enhance skills on MS Project and in Power Point

25 Answers

What are the top excel functions management consultants use?

6 Answers

what is the recommended time needed to learn excel and cost ?

52 Answers

How can we convert date into days for any year?

9 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

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

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.