From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Naming and using cell ranges - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Naming and using cell ranges
When you have a lot of cell ranges to deal with, you might find it easier to give them friendly names. For example, you might find it easier to deal with something called the sum of January than deal with the sum of B6:B9. But range names have a little quirk and we are going to look at that also. Well, over here we have regions that we are selling to and we have months January through June. Let's select just the numbers here in the January column and go up to the name box. You see the name box right now is at B6, because B6 is the first cell we are selecting. So, click in the name box and type January and press Enter. Just click anywhere in the worksheet to deselect. Now, when we go back up to the name box, click that down arrow. There is January. Select it and January becomes selected. That's great. Let's do for February. Select February. Click under the name box, type February, press Enter. Again, you could deselect and click up here. Now, there January and February. Well, there is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Understanding formulas and functions4m 41s
-
(Locked)
Entering data in a worksheet3m 22s
-
(Locked)
Adding numbers manually5m 1s
-
Adding numbers using Sum and AutoSum6m 11s
-
(Locked)
Adding a whole worksheet1m 48s
-
(Locked)
Working with numbers in columns4m 53s
-
Preventing errors using absolute references5m 57s
-
(Locked)
Working with times and dates3m 7s
-
(Locked)
Using IF4m 49s
-
(Locked)
Using SUMIF and AVERAGEIF4m 15s
-
(Locked)
Naming and using cell ranges3m 45s
-
-
-
-
-
-
-
-
-
-
-
-
-