Microsoft Excel 2013 Training Tutorial

Learn to use Microsoft Excel 2013 with this comprehensive course.
4.7 (20 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
4,896 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 226
  • Length 18 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2013 English Closed captions available

Course Description

Learn Microsoft Excel 2013 with this comprehensive course from TeachUcomp, Inc.Mastering Excel Made Easy features 222 video lessons with over 10 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each Microsoft Excel 2013 lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises. You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.

Whether you are completely new to Excel or upgrading from an older version, this Excel 2013 course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply click to launch a video lesson or open one of the manuals and you’re on your way to mastering Excel. This course also includes lessons for versions prior to Microsoft Excel 2013, making an upgrade from earlier versions a breeze.

</p>

What are the requirements?

  • Excel software recommended for practice.

What am I going to get from this course?

  • Video Lessons
  • Includes Three Classroom Instruction Manuals
  • Getting Acquainted with Excel
  • Creating Formulas
  • 3D Formulas
  • Auditing Worksheets
  • Creating Charts In Excel
  • PivotTables and PivotCharts
  • Security Features
  • Much More!

What is the target audience?

  • Anyone wanting to learn Microsoft Excel.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Acquainted with Excel
01:38
Microsoft Excel is a spreadsheet program that you can use to organize and manipulate information. With Excel, you can create worksheets that can perform complex calculations instantly. When your numbers in your worksheet change, Excel can recalculate the answers automatically! You also have complete control over the appearance of your worksheets. Learn this and more during this lecture.
01:57
Excel 2013, you are given one worksheet by default within your new, blank workbook. The default name of the worksheet is “Sheet1” and is displayed on the worksheet tab in the lower left corner of the window. You may open and close multiple workbooks within Excel without closing the entire Excel application. Even if you close all open workbooks, you will see some of the items within the Excel environment displayed onscreen within the application window. Learn this and more during this lecture.
02:09
The first thing that you should notice is that the Excel screen consists of two windows: the application window, and the workbook window. A workbook is the default object in Excel, much like a document is the default object in Word. It consists of three worksheets, by default. It opens up within the application window, and is where you create and modify worksheets. You may close the workbook window without closing the entire Excel application. This allows you to open and close different workbooks without having to restart the program. Learn this and more during this lecture.
01:57
The first thing that you should notice is that the Excel screen consists of two windows: the application window, and the workbook window. A workbook is the default object in Excel, much like a document is the default object in Word. It consists of three worksheets, by default. It opens up within the application window, and is also where you create and modify worksheets. You may close the workbook window without closing the entire Excel application. This allows you to open and close different workbooks without having to restart the program. Learn this and more during this lecture.
02:14
The Title Bar is the bar that runs across the top of the application window. The name of the workbook that you are working on will be displayed in the center of this bar. At the right end of the Title Bar is a button group. There are five buttons in this group in Excel 2013 and three in Excel 2010 and 2007. Learn this and more during this lecture.
02:40
The primary tool that is available for you to use in Excel is the Ribbon. This object allows you to perform all of the commands available in the program. The Ribbon is divided into tabs. Within these tabs are different button groups of commands. Learn this and more during this lecture.
01:26
Starting in Excel 2010, the “File” tab within the Ribbon replaces the functionality of the older “Microsoft Office” button that appeared in Excel 2007. You can click the “File” tab in the Ribbon to open a view of the file called the “Backstage View.” In this view, you can perform all of your file management. This includes performing functions such as saving your file, opening an existing file, or creating a new file. Learn this and more during this lecture.
02:01
The Microsoft Office button gives you access to your basic file management functions within Excel 2007. For upgrading users, you will find that this button replaces the functionality previously found under the “File” command in the old Menu Bar. Learn this and more during this lecture.
00:34
The scroll bars run both vertically and horizontally in the bottom right corner of your workbook. You can click the arrows at the ends of the scroll bars to scroll through the workbook in that direction. Learn this and more during this lecture.
03:24
The Quick Access toolbar is located above the Ribbon, by default. However, you can also place it below the Ribbon, if desired, by clicking the “Customize Quick Access Toolbar” button at the right end of the toolbar and then selecting the “Show Below the Ribbon” command. You can reset it to its default location by clicking the same “Customize Quick Access Toolbar” button and then choosing the “Show Above the Ribbon” command. Learn this and more during this lecture.
01:30
Because of the increased use of tablets, Excel 2013 has been redesigned with a new mode to allow for easier access to the buttons and other commands within the Ribbon and Quick Access toolbar. This mode is called touch mode. Learn this and more during this lecture.
01:01
The Formula Bar is located underneath the Ribbon. At its left end is the “Name Box” which displays the address of the currently selected cell in your workbook. To the right of that is the “Insert Formula” button which looks like the function (fx) sign. Learn this and more during this lecture.
03:17
The workbook window is the window in which you will perform almost all of your work. Within the workbook window you will enter data into the worksheets. The names of the worksheets within a workbook are shown on tabs in the lower-left corner of the workbook. A workbook stores information much like a database table does. Learn this and more during this lecture.
02:27
At the bottom of the application window is the Status Bar. This tool provides you with information about your workbook. One of the most important status indicators in Excel is the “Cell Mode” status indicator. In Excel, there are three main modes that you will be able to see in this bar towards the left end: “Ready,” “Edit,” or “Enter.” If the word “Ready” appears, Excel is ready to do just about anything. This is the mode you want to be in before you begin a task. Learn this and more during this lecture.
01:26
The workbook view buttons are a group of three buttons located towards the lower right corner of the application in the Status Bar. You can click these buttons to change the working view of your workbook. By default, Excel will open in “Normal” view, which is the view most commonly used for standard workbook creation. Learn this and more during this lecture.
01:51
In the lower right corner of the application window, you can see the Zoom slider. You can use this to change the magnification level of the workbook. This does not modify the workbook in any way, but rather changes your perception of how close or far away the workbook appears onscreen. Learn this and more during this lecture.
00:38
When you select text within a cell and hold your mouse pointer over it, you will see a small dimmed-out toolbar appear next to the selection. This is the Mini toolbar. Learn this and more during this lecture.
03:45
The changes to the visual interface that started in Excel 2007 changed the use of keyboard shortcuts within the application. While many things have changed, many other things have stayed the same, to assist users in the migration to Excel 2007 or later from previous versions. First off, you should be aware that all of the “Ctrl” key keyboard shortcuts remain intact. Learn this and more during this lecture.
Section 2: File Management
00:51
When you first open the Excel 2013 application, you will be presented with the startup screen that allows you to create a new workbook. If you already have opened a workbook you can view a similar screen by clicking the “File” tab within the Ribbon and then selecting the “New” command at the left side of the backstage view. Learn this and more during this lecture.
00:35
To create a new workbook in Excel 2010, click the “File” tab within the Ribbon and then select the “New” command. Learn this and more during this lecture.
00:55
To create a new workbook, click the Microsoft Office button and then select the “New” command. This will launch the “New Workbook” window. Here you can choose to start a new workbook from one of the many templates available, or you can choose to simply create a new blank workbook. Learn this and more during this lecture.
04:01
When you save a workbook for the first time, you must use the “Save As” command so that you can choose where to save the file and what to name it. To do this, click the “File” tab within the Ribbon. Then click the “Save As” command in the command panel shown at the left side of the backstage view. To the right of the command panel, you will see the places that are available for you to save the file. Learn this and more during this lecture.
01:56
When you save a workbook for the first time, you must use the “Save As” dialog box. To do this, click the “File” tab within the Ribbon. Then click the “Save As” command in the command panel shown at the left side of the Backstage View. In the “Save As” dialog box that then appears, give Excel a location to which the workbook will be saved, and enter a file name. Learn this and more during this lecture.
01:56
When you save a workbook for the first time, you must use the “Save As” dialog box. To do this, click the Microsoft Office button, and then roll down to the “Save As” command. From the side menu of format choices, click on the desired file format to use when saving the workbook. In the “Save As” dialog box, give Excel a location to which the workbook will be saved, and a file name. Learn this and more during this lecture.
00:36
To close a workbook in Excel 2013, click the click the “File” tab within the Ribbon and then click the “Close” command at the left side of the backstage view. Learn this and more during this lecture.
00:29
To close a workbook click the “X” button in the upper-right corner of the workbook window. Learn this and more during this lecture.
03:37
To open a workbook, you must first know where the workbook you want to open is located. When you initially open Excel, you can see a listing of recently opened workbooks shown in the panel at the left side of the startup screen, under the “Recent” section. You can open one of these listed workbooks by clicking on its name within the panel to reopen it. Learn this and more during this lecture.
02:31
To open a workbook, you must first know where the workbook you want to open is located. Once you know where the file is located, you open it using the “Open” dialog box. You can access this dialog box by clicking the “File” tab within the Ribbon and then clicking the “Open” command in the Backstage View. In the “Open” dialog box that appears, navigate to the location of the file you want to open. Learn this and more during this lecture.
02:43
To open a workbook, you must first know where the workbook you want to open is located. This location could be within a folder on your computer, a network folder, a CD-ROM, or perhaps located on some other type of removable media. Once you know where the file is located, you open it by using the “Open” dialog box. Learn this and more during this lecture.
01:21
A new feature in Excel 2013 allows you to attempt to recover unsaved workbook files. If you want to see if Excel has automatically saved a copy of an unsaved workbook that you were working on, then select the “File” tab within the Ribbon and click the “Open” command at the left side of the backstage view. Learn this and more during this lecture.
07:03
Excel provides you with tools that assist you in managing your workspace when you have multiple workbooks open. In Excel, you can have many workbooks open at a time to perform functions like copying and pasting text between them, for example. Learn this and more during this lecture.
01:05
In Excel, full screen mode maximizes the amount of worksheet area by removing everything else from the Excel window. To switch to full screen mode in Excel 2013, click the “Ribbon Display Options” button in the button group at the right end of the Title Bar and then select the “Auto-hide Ribbon” command. Learn this and more during this lecture.
04:40
Starting in Excel 2007, Excel saves its workbooks using a new default file format that provides a smaller file size and better security than the format used in prior versions of Excel. However, you should be aware of the file format issue if you will be sharing your workbook collaboratively with others who may need to use and edit the workbook with an older version of Excel. Some features aren’t supported by older versions of Excel. Learn this and more during this lecture.
Section 3: Data Entry
01:53
When you open a new workbook, the active cell is always cell “A1.” You can use the mouse to click into any cell to make it the active cell. You can also use the keyboard to move the active cell cursor. There are many ways to move the active cell quickly with the keyboard. Learn this and more during this lecture.
02:09
In Excel, any combination of numbers and letters entered into a cell will be treated as a text entry- not a numeric entry. Text entries will default to using a left alignment in the cells into which they are entered. As you enter information into a cell, remember that you must leave the cell to finish entry. Learn this and more during this lecture.
02:56
In Excel, for a cell to be considered a “numeric” entry, it can only contain digits and decimals. There can be no text in numeric entries. Ideally, you should enter numbers in a plain and raw format, that is- without any formatting, like dollar signs. A helpful tip is: just enter the digits and decimals. All number signs, commas, and other numeric formatting can be added later on when you format the cells. Learn this and more during this lecture.
01:18
Excel contains a handy feature called AutoComplete that can help speed up repetitive text entry within columns. If you have a column of unbroken text entries, meaning no empty cells, Excel will offer to “fill-in” the next entry that you make at the bottom of the column as you type your entries down the column. Learn this and more during this lecture.
00:51
Excel contains another handy little feature called “Pick From Drop-down List” that can speed up repetitive text entry in columns. If you have a column of unbroken text entries, meaning no empty cells, Excel can display a drop-down menu of the previous text entries within that column from which you can pick! That way, you won’t have to retype duplicate entries and risk misspelling them. Learn this and more during this lecture.
04:20
Starting in Excel 2013, you can use the “Flash Fill” feature to automatically fill-in values within a column with information entered into an adjacent column. This feature is most useful when dealing with data that has a consistent data entry pattern in the column whose values are referenced by the second, flash filled column. Learn this and more during this lecture.
05:09
Many features of Excel are dependent upon making a reference to a group of cells. In Excel, a group of cells is called a range. Ranges are used in many ways in Excel. For example, you may have a column of sales figures. Using a formula, you could refer to the range of all cells in that column and then add them together to find the total sales. This is just one example of how you use ranges in Excel. Learn this and more during this lecture.
01:34
Once you have a range selected, you can easily enter new information into the selected range of cells. Notice that there is one cell within the selected range that is white. That cell is the active cell within the selected range or ranges. You can enter information into this cell. Learn this and more during this lecture.
03:06
AutoFill is a feature that allows Excel to automatically fill in a repeating pattern that you establish. For instance, you could fill in the months of the year, days of the week, or any repeating numerical pattern. Learn this and more during this lecture.
Section 4: Creating Formulas
02:19
This lecture shows an example of the syntax used by a common ranged Excel formula. Learn this and more during this lecture.
01:02
This lecture shows an example of the syntax used by a common simple Excel formula. Learn this and more during this lecture.
06:27
You use formulas to perform mathematical functions on cells. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax” is simply a way of expressing or writing something. It is important to note that these two syntaxes are not mutually exclusive! In fact, your more complex formulas will often incorporate elements of both to arrive at the desired result. Typically, you will use the simple syntax to perform multiple mathematical calculations on multiple cells. You use the ranged syntax to perform a single mathematical function over multiple cells. Learn this and more during this lecture.
02:36
Much of the time, people use Excel to sum columns and rows of data. In fact it occurs so frequently that Excel has included a feature called AutoSum that automatically performs a selected function, like SUM, on a selected column or row of uninterrupted (no blank) cells. This saves you time in creating basic formulas. Learn this and more during this lecture.
04:08
You can insert functions into a selected cell in one of several ways. You could click the “Insert Function” button in the “Function Library” group on the “Formulas” tab in the Ribbon. You could click the “fx” (function) button in the Formula Bar. Learn this and more during this lecture.
01:35
You can edit the cell range reference of a formula after it has been created. To do this, just double-click on the formula cell. It will display itself as the formula instead of the answer to the formula, and it will place a blue border around the currently selected range in the formula. Learn this and more during this lecture.
00:45
If you mistype a formula, Excel may be able to correct your formula syntax automatically. Excel may display a dialog box that offers to correct your mistake for you when you try to exit a cell that contains an incorrect formula. Learn this and more during this lecture.
01:04
AutoCalculate is a tool that displays the results of simple functions in the Status Bar without having to type a formula. The functions displayed by default are “Average,” “Count,” and “Sum.” Learn this and more during this lecture.
02:36
In Excel 2013, some older formula functions have been replaced with new versions to increase their accuracy and to better reflect their purpose. These new, more accurate statistical functions have different names than their older counterparts, and may also require different arguments. The older versions are still included in Excel 2013 for backwards-compatibility with older workbooks. Learn this and more during this lecture.
Section 5: Copying and Pasting Formulas
04:38
In Excel, you can cut or copy data from cells and then paste the data into other cells. Cells that contain numeric or text entries can be moved wherever you want. The only trick is when you need to cut or copy cells that contain formulas. Learn this and more during this lecture.
04:10
To copy or cut data, first select the cells that you want to copy or cut and then press either the “Copy” or “Cut” buttons in the “Clipboard” group on the “Home” tab in the Ribbon. The cells that you have selected will appear with a blinking marquee around them to indicate that they have been cut or copied. The cut or copied data is then placed onto the clipboard, which is memory allocated to cut or copied data. Learn this and more during this lecture.
01:07
You can use the AutoFill handle to copy formulas across rows and down columns. Because a formula is not the start of a standard series, when you use the AutoFill handle on a selected formula cell, it will simply copy the formula across the range of cells that you select. Learn this and more during this lecture.
00:59
The “Undo” command is one of the most important functions available. It allows you to reverse the last command that you performed. The drop-down arrow next to the “Undo” button in the Quick Access toolbar contains a list of the last few actions you have performed. Learn this and more during this lecture.
00:54
The “Redo” command, located next to the “Undo” button in the Quick Access toolbar, is the inverse of the “Undo” command. It will redo an action that was undone. This is valuable if you accidentally click the “Undo” button a few too many times when trying to correct a mistake that was made. Learn this and more during this lecture.
Section 6: Columns and Rows
01:49
Many new Excel users make the mistake of thinking that because they have selected all of the cells that they can see within a column or across a row, they have selected the entire column or row. Selecting a few visible cells onscreen is not the same as selecting entire columns or rows. Learn this and more during this lecture.
02:30
You can adjust the width of columns to correct the display of longer cell entries. You can also adjust row height to accommodate larger fonts. Learn this and more during this lecture.
01:35
You can hide columns and rows that contain sensitive data that you need for formulas but don’t necessarily want to print in a worksheet, like salary information for example. Hiding a column or row conceals the columns or rows from display, but still uses the data that they contain for calculations. Learn this and more during this lecture.
04:30
When you insert columns and rows in a worksheet, there are two rules that you should remember: 1-The number of columns or rows that you select will be the number of columns or rows that you insert. 2-New columns will be inserted to the left of your selected columns, and new rows will be inserted above your selected rows. Learn this and more during this lecture.
Section 7: Formatting Worksheets
03:48
Note that in the “Home” tab of the Ribbon, you have the “Font” group, the “Alignment” group, and the “Number” group. These groups contain buttons that allow you to format the appearance of selected cells. To do this, just start by selecting the cells you want to format. Then click the desired button. Learn this and more during this lecture.
09:07
You can use the “Format Cells” dialog box in Excel to control all aspects of cell formatting for the currently selected cells in your worksheet. The “Format Cells” dialog box has six tabs that allow you to change cell properties. The sixth tab, “Protection,” is related to worksheet security and is discussed in “Chapter 28- Security Features.” It has no bearing on cell formatting. The other five tabs in this dialog box that do control cell formatting are: “Number,” “Alignment,” “Font,” “Border,” and “Fill.” Learn this and more during this lecture.
00:33
You can clear all of the formatting from selected cells by first selecting the cells from which you want to remove all of the formatting. Learn this and more during this lecture.
01:23
You can copy just the formatting of a selected cell or selected cells, and apply it to other areas of the workbook. Learn this and more during this lecture.
Section 8: Worksheet Tools
01:30
Many people will find it necessary to insert or delete worksheets within a workbook when using Excel. To insert a single new worksheet at the end of the current listing of worksheets, just click the “New Sheet” button that appears at the right end of the spreadsheet name tabs. Learn this and more during this lecture.
01:44
When you select multiple worksheets at the same time, changes that you make to one worksheet are applied to all the worksheets in the same group. You can group adjacent or non-adjacent worksheets within the same workbook. Learn this and more during this lecture.
01:36
To move from one worksheet to another, simply click the worksheet name tab of the worksheet that you want to view from the set of worksheet name tabs located in the lower left corner of the workbook. If you prefer keyboard shortcuts, you will find that pressing “Ctrl”+“PageUp” will move to the previous worksheet and pressing “Ctrl”+“PageDown” will move to the next worksheet. Learn this and more during this lecture.
01:33
When you create a new workbook, it contains three worksheets by default. To move from one worksheet to another, simply click the worksheet name tab of the worksheet that you want to view from the set of worksheet name tabs located in the lower left corner of the main screen. If you prefer keyboard shortcuts, you will find that pressing “Ctrl”+“PageUp” will move to the previous worksheet and pressing “Ctrl”+“PageDown” will move to the next worksheet. Learn this and more during this lecture.
01:11
You can rename the worksheets in your workbook so that they reflect their content. By default, the worksheets in a workbook are labeled “Sheet1,” “Sheet2,” “Sheet3” and so on. As you add new worksheets, the same naming convention is applied to the new worksheets. You can rename worksheets to practically anything that you want. You are allowed to use spaces in worksheet names. Learn this and more during this lecture.
01:23
You can change the color of the worksheet tabs, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Format” button in the “Cells” group on the “Home” tab in the Ribbon. Roll your mouse pointer down to the “Tab Color” command. In the side menu that appears, click on the color that you want to apply to the worksheet tab. Learn this and more during this lecture.
02:37
One way to copy and paste entire worksheets in a workbook is by using the worksheet name tabs. To copy a selected worksheet or a group of worksheets first select the worksheets that you want to copy. Then hold down the “Ctrl” key on your keyboard. Then click and drag the first worksheet tab that you selected (its title will appear highlighted), and drop it where you’d like the new worksheets to be pasted. Learn this and more during this lecture.
Section 9: Setting Worksheet Layout
01:47
In Excel, when you get past the end of a printable page, as defined by your current page setup, Excel will insert an automatic page break. Sometimes these automatic page breaks occur in places where you would rather not have them occur. Learn this and more during this lecture.
01:00
You can click the “Page Layout” button in the “Workbook Views” group on the “View” tab in the Ribbon to see how your workbook will appear when printed. In this mode, you can see the margins and the allowable room for header and footer data along with the information from your worksheet. Learn this and more during this lecture.
10:55
When you want to adjust the settings of the workbook for printing purposes, you can do that through the “Page Setup” dialog box. You can access this dialog box by clicking the “Page Setup” dialog box button in the lower right corner of the “Page Setup” group on the “Page Layout” tab in the Ribbon. The “Page Setup” dialog box allows you to make changes to your worksheet’s printed layout. Learn this and more during this lecture.
Section 10: Printing Worksheets
04:17
Before you print your worksheets, make sure that you have the worksheet properly setup using the “Page Setup” dialog box. Once this is accomplished, you will want to check the way that your worksheet will print without having to waste paper by actually printing several copies until it is correct. Excel provides another view of your worksheet called “Print Preview” to assist you in this. In print preview, you can see how your worksheet will actually print on paper, according to the specifications that you’ve set in the “Page Setup” dialog box. Learn this and more during this lecture.
01:20
Before you print your worksheets, make sure that you have the worksheet properly setup using the “Page Setup” dialog box. Once this is accomplished, you will want to check the way that your worksheet will print without having to waste paper by actually printing several copies until it is correct. Excel provides another view of your worksheet called “Print Preview” to assist you in this. Learn this and more during this lecture.
02:14
If you want to quickly print one copy of your entire worksheet, click the Microsoft Office button and then roll down to the “Print” command. Select the “Quick Print” option from the side menu that appears to quickly print one copy of your worksheet without making any changes. Learn this and more during this lecture.
Section 11: Helping Yourself
02:06
Excel has built-in help functionality which can greatly reduce the time and cost of technical support. The help functionality is quite extensive. It contains a searchable database of help files for you to read. Learn this and more during this lecture.
Section 12: 3D Formulas
01:21
It is helpful to be able to create a single formula that calculates data gathered from multiple worksheets. These types of formulas are called 3D formulas. They calculate information from multiple worksheets and show the result in a selected formula cell. Learn this and more during this lecture.
02:50
The best way to learn how a 3D formula works is to look at some examples. This lecture will show three examples of 3D formulas. The first is a simple 3D formula, the latter two are ranged 3D formulas. Learn this and more during this lecture.
01:17
A 3D cell range is one cell range that spans several sheets deep. Learn this and more during this lecture.
Section 13: Named Ranges
03:40
Instead of always having to type a cell range into formulas you can use range names, but only if you first name a particular range of cells. This can be helpful if you have a worksheet that contains data of the same type in the same place. Learn this and more during this lecture.
01:18
You can use the column and row headings in a table or list within a worksheet to name a range of cells. If you use this method of creating named ranges, then start by selecting the cell range- including any titles that you want to use as the names for the ranges that will be created. Learn this and more during this lecture.
00:46
A quick way to select the cells in any named ranges that you have in your workbook is to move to the named range. Once you have named ranges in your workbook, they are contained in the drop-down list that appears when you click the “Name Box” drop-down within the Formula Bar. Learn this and more during this lecture.
02:40
You can use named ranges instead of cell range addresses in formulas. One way to do this is to simply type the named range instead of the specific cell range when creating the formulas by hand. Another way to use named ranges in formulas is to begin creating the formula using whichever method that you prefer. Learn this and more during this lecture.
02:41
You can also give names to 3D ranges. As we learned in the previous chapter, a 3D range is one cell range that spans through multiple worksheets. As long as the cell range reference is the same for all of the different worksheets in the group that you select, you can give it a name. Then it, too, can be used in your formulas in place of the typical 3D cell range references. Learn this and more during this lecture.
00:56
If you no longer require a named range that you have created, you can delete it from the list of named ranges in the workbook. Learn this and more during this lecture.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

TeachUcomp, Inc., Quality Software Training

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center in Holt, Michigan - providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 80 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.

Ready to start learning?
Take This Course