Your cart is empty.
Keep shopping
Teach on Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn MoreMicrosoft Excel 2013 Training Tutorial
Rating: 4.3 out of 54.3(42 ratings)
4,929 students
Microsoft Excel 2013 Training Tutorial
Learn to use Microsoft Excel 2013 with this comprehensive course.
Created byTeachUcomp, Inc.
Last updated 6/2013
English
What you'll learn
- 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!
Explore related topics
Course content
39 sections • 226 lectures • 10h 3m total length
- About Excel1:38Microsoft 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.
- The Excel Environment- 20131:57Excel 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.
- The Excel Environment- 20102:09The 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.
- The Excel Environment- 20071:57The 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.
- The Title Bar2:14The 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.
- The Ribbon2:40The 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.
- The “File” Tab and Backstage View- 2013:20101:26Starting 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.
- The Microsoft Office Button- 2007 Only2:01The 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.
- Scroll Bars0:34The 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.
- The Quick Access Toolbar3:24The 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.
- Touch Mode- 20131:30Because 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.
- The Formula Bar1:01The 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.
- The Workbook Window3:17The 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.
- The Status Bar2:27At 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.
- The Workbook View Buttons1:26The 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.
- The Zoom Slider1:51In 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.
- The Mini Toolbar0:38When 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.
- Keyboard Shortcuts3:45The 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.
- Creating New Workbooks- 2013 Only0:51When 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.
- Creating New Workbooks- 2010 Only0:35To 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.
- Creating New Workbooks- 2007 Only0:55To 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.
- Saving Workbooks- 2013 Only4:01When 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.
- Saving Workbooks- 2010 Only1:56When 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.
- Saving Workbooks- 2007 Only1:56When 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.
- Closing Workbooks- 2013 Only0:36To 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.
- Closing Workbooks- 2010:2007 Only0:29To close a workbook click the “X” button in the upper-right corner of the workbook window. Learn this and more during this lecture.
- Opening Workbooks- 2013 Only3:37To 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.
- Opening Workbooks- 2010 Only2:31To 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.
- Opening Workbooks- 2007 Only2:43To 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.
- Recovering Unsaved Workbooks- 2013 Only1:21A 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.
- Using the “Window” Command Group7:03Excel 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.
- Switching to Full Screen View1:05In 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.
- Working with Excel File Formats4:40Starting 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.
- Selecting Cells1:53When 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.
- Entering Text into Cells2:09In 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.
- Entering Numbers into Cells2:56In 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.
- AutoComplete1:18Excel 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.
- Pick from Drop-Down List0:51Excel 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.
- Flash Fill- 2013 Only4:20Starting 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.
- Selecting Ranges5:09Many 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.
- Ranged Data Entry1:34Once 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.
- Using AutoFill3:06AutoFill 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.
- Ranged Formula Syntax2:19This lecture shows an example of the syntax used by a common ranged Excel formula. Learn this and more during this lecture.
- Simple Formula Syntax1:02This lecture shows an example of the syntax used by a common simple Excel formula. Learn this and more during this lecture.
- Writing Formulas6:27You 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.
- Using AutoSum2:36Much 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.
- Inserting Functions4:08You 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.
- Editing a Range1:35You 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.
- Formula AutoCorrect0:45If 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.
- AutoCalculate1:04AutoCalculate 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.
- Function Compatibility- 2013 Only2:36In 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.
- Relative References and Absolute References4:38In 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.
- Cutting, Copying, and Pasting Data4:10To 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.
- AutoFilling Cells1:07You 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.
- The Undo Button0:59The “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.
- The Redo Button0:54The “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.
- Selecting Columns and Rows1:49Many 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.
- Adjusting Column Width and Row Height2:30You 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.
- Hiding and Unhiding Columns and Rows1:35You 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.
- Inserting and Deleting Columns and Rows4:30When 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.
- Formatting Cells3:48Note 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.
- The Format Cells Dialog Box9:07You 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.
- Clearing All Formatting from Cells0:33You 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.
- Copying All Formatting from Cells to Another Area1:23You 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.
- Inserting and Deleting Worksheets1:30Many 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.
- Selecting Multiple Worksheets1:44When 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.
- Navigating Worksheets- 2013 Only1:36To 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.
- Navigating Worksheets- 2010:20071:33When 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.
- Renaming Worksheets1:11You 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.
- Coloring Worksheet Tabs1:23You 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.
- Copying or Moving Worksheets2:37One 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.
- Using Page Break Preview1:47In 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.
- Using the Page Layout View1:00You 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.
- The Page Setup Dialog Box10:55When 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.
- Previewing and Printing Worksheets- 2013:20104:17Before 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.
- Using Print Preview- 2007 Only1:20Before 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.
- Printing Worksheets- 2007 Only2:14If 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.
Requirements
- Excel software recommended for practice.
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.
Our courses were developed from our original classroom trainings. This helped to develop the curriculum of course topics we present that address the student’s real-world concerns and usage.
Our course design helps maximize the learning retention of our self-study courses. Each course contains different learning modalities that help reinforce the topics. We initially present each topic’s information in a course manual in a written, conversational style to provide a conceptual overview. These overviews are followed by instructions, showing the specific actions required to perform the tasks related to the topic. These topic actions are then combined with each other into exercises at the end of each chapter to show their interconnected relationships.
Each course topic is also enhanced with an audio-visual lesson in the form of a video. The video lesson shows how to perform the topic’s actions as the instructor simultaneously narrates the topic’s overview.
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.
Who this course is for:
- Anyone wanting to learn Microsoft Excel.