How to Target and Analyze Large Data Groups in Excel


show more Targeting large data groups provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Targeting large data groups

In Excel, as with all other Windows programs, you have to know how to select your data if you want to modify it. So let's take a look at a few techniques. Well some are pretty straightforward. Put your mouse pointer here at the beginning and you can just drag and as long as you don't let go off the mouse button, you can reduce or enlarge the selection area. Okay, that's great, but what if you wanted to select some things that are not quite so straightforward? Well let's do this. Click on the first cell here A5. Now if you scroll down, you can see there's the end of this selection area.

Well, it can be kind of hard to try to drag to select that, because Excel starts doing that and it can scroll much faster than you can select. So I'm just going to press Ctrl+Home. So here's an easier way to do that. Click the first cell, scroll down, so I'm just to use going to use the rolling wheel on the mouse, put your mouse pointer on the last cell there, and before you clic...

Targeting large data groups
Video duration: 4m 26s 6h 21m Beginner

Viewers:

Targeting large data groups provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...