This tutorial covers some of the main benefits and features of Excel as well as why you might want or need to use Excel. Some of the reasons you might want to use Excel include features that allow you to analyze data, update large amounts of data, chart or plot / graph data, sort data, collect data, and much more. This video provides an overview of these features and attempts to show you why you...
| Tutorial Length (mm:ss): |
13:46 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training benefits of using excel overview introduction features |
This is an introduction to Excel and the Excel 2007 interface. This tutorial is geared towards people who know very little about Excel and need to learn the very basics about the Excel interface. This tutorial covers some of the basic and most used Excel terminology; the basic layout of Excel; how to use the Office Button; how to move around the worksheet, zoom, and pan; how to use and customize...
| Tutorial Length (mm:ss): |
15:57 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training introduction to excel interface terminology beginner new starting |
Learn the basics of entering data, numbers, and lists in Excel. This tutorial is for the beginner who is not very familiar with or has never used Excel. You will learn how to move the active cell to the right instead of down using the keyboard; how to cut and paste data with the drag and drop feature; how to automatically increment numbers using the auto fill handle; and how to add an extra line...
| Tutorial Length (mm:ss): |
13:05 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training beginner enter data cells lists auto fill autofill handle drag drop line text numbers move right down tab key |
Learn how to insert, remove, re-size, cut, copy, paste, and delete rows, columns, and cells in Excel. This tutorial shows you how to edit the appearance and location of rows, columns, and cells in order to change the organization of the data within the worksheet. The features mentioned in this tutorial are a cornerstone to using Excel.
| Tutorial Length (mm:ss): |
11:15 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training insert remove resize rows columns organize data |
Learn the basics of formatting in Excel 2007. This introduction to formatting gives you an overview of all of the basic cell, font, and number formatting options in Excel 2007. These formatting options include how to change the font size, color, and appearance; how to use the Cell Styles feature to quickly create professional looking spreadsheets; how to use the alignment features of Excel; how ...
| Tutorial Length (mm:ss): |
12:40 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training introduction beginner formatting format apply excel 2007 fonts colors alignment wrap text merge cells number styles |
Learn how to change a static table of data in Excel 2007 into a dynamic and professional looking table using the Format as Table feature in Excel 2007. This tutorial is an introduction to using the Format as Table feature and does not cover all of the possible benefits of this feature in depth.
Using this feature allows you to quickly add new rows to the table that are already formatted to fit...
| Tutorial Length (mm:ss): |
7:57 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training introduction format data table excel 2007 dynamic sort filter overview beginner |
Learn how to use the AutoSum feature in Excel to quickly sum, average, and count numbers. This tutorial shows you how to use the AutoSum feature to easily enter functions on sets of numbers without having to know much if anything about the functions that are being entered into Excel. This feature also allows you to quickly enter many functions at once. This is a great little feature of Excel th...
| Tutorial Length (mm:ss): |
5:36 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training autosum auto sum add average count numbers functions excel |
This is an introduction to using formulas and functions in Excel. This tutorial assumes little to no prior knowledge of formulas or functions and serves as a walkthrough of how to use formulas and functions. This tutorial covers these topics related to formulas and functions: what’s required to enter them into cells; math operators for formulas; using arguments with functions, different types of...
| Tutorial Length (mm:ss): |
17:04 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training beginner introduction formulas functions formula bar basic insert function help arguments locate |
This tutorial provides an introduction to adding, editing, and using charts and graphs in Excel 2007. This includes the three main ways to add charts to your workbooks and worksheets, including two keyboard shortcuts, and an overview of how to use the three chart editing tabs that appear after you add a chart or graph in Excel 2007. Some of the topics covered include how to change the chart type...
| Tutorial Length (mm:ss): |
11:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training charts graphs introduction overview basic beginner tabs move resize create edit |
Learn how to add, remove, move, rename, and edit worksheets and tabs in Excel 2007. This tutorial shows you how to better organize the worksheets within a workbook in Excel. This includes how to move worksheet tabs and how to create groupings of tabs using different colors for different tabs.
| Tutorial Length (mm:ss): |
4:35 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training worksheets tabs delete add remove color organize edit excel 2007 |
Learn how to very quickly add pre-made worksheets and workbooks into Excel. This feature allows you to get workbook and worksheet templates for items such as expense reports, time sheets, calendars, budgets, and much more. Using this feature can save you a lot of time and provide a good jumping-off point for you when you are creating your own forms or worksheets in Excel. Note that these workboo...
| Tutorial Length (mm:ss): |
3:41 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training quickly add custom pre built made workbooks worksheets calendar reports |
Learn the limitations of opening and using old Excel files in Excel 2007. This tutorial also includes a brief overview of the compatibility mode in Excel 2007 and some of the new features that are not compatible with older versions of Excel. As well, there is a brief mention of how to convert an old Excel file to a new Excel file format.
| Tutorial Length (mm:ss): |
4:02 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training open old workbooks compatibility mode limits |
Learn how to convert your old workbooks to the new Excel 2007 workbook file format. This tutorial shows you two different ways to make this conversion. One way simply converts the current file into the new file format while the other way shown in the tutorial leaves the original file intact, similar to a backup copy, while creating a new file for you in the new Excel 2007 file format. Convertin...
| Tutorial Length (mm:ss): |
3:39 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training convert save as previous versions excel new old workbooks file format |
Learn what workbooks with macros look like for Excel 2007 and how to open these workbooks as well as enable or disable the macros within the workbook. Also, this tutorial shows you how to change the default security settings so that macros are always enabled, always disabled, or something in-between. This is a great tutorial for people just learning about and how to use macros in Excel.
| Tutorial Length (mm:ss): |
4:36 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training open workbook with macro security settings enable disable |
This tutorial shows you how to save Excel workbooks in many different file formats and how to check if the file will be compatible with previous versions of Excel. The file formats covered in this tutorial include PDF, Excel 97-2003, and Macro Enabled Workbooks. These are the most commonly used file formats outside of the new Excel 2007 workbook format.
| Tutorial Length (mm:ss): |
7:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training save excel workbook file format different previous version pdf macro enabled compatibility checker |
This is a comprehensive introduction and overview of the printing features in Excel. This tutorial shows you how to print selections of text, specific worksheets, multiple worksheets, and an entire workbook. Also, you will learn about some other printing features including: how to use the new Page Layout view; how to use print preview to check documents before you print them; how to add headers ...
| Tutorial Length (mm:ss): |
11:20 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training printing print overview introduction comprehensive worksheets workbook page setup page layout selections header footer |
This tutorial provides an overview of the main features of the new Excel 2007 interface. The features covered in this tutorial include the Ribbon Menu, the Office Button, and the Quick Access Toolbar. This is not an in depth tutorial for any of the features listed but is instead an introduction to these features.
| Tutorial Length (mm:ss): |
4:36 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training overview new excel 2007 interface menus ribbon office button toolbar |
This tutorial provides you with an in-depth look at using the Ribbon Menu in Excel 2007. This is a great tutorial for people just starting out in Excel or for those who are looking to better understand how to use the Ribbon Menu or to find out where everything is on the Ribbon Menu. This tutorial includes an explanation of where everything is located on the Ribbon Menu; how to find commands on t...
| Tutorial Length (mm:ss): |
12:37 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training ribbon menu excel 2007 overview introduction explanation how to use hide navigate view |
Open old style Excel 2003 dialog boxes in Excel 2007. This feature allows you to work in a perhaps slightly more familiar interface and also allows you to have access to more functions and features than are available on the Ribbon Menu.
| Tutorial Length (mm:ss): |
2:48 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training open dialog dialogue box old style excel 2003 windows |
This tutorial provides a comprehensive overview of the Quick Access Toolbar in Excel 2007. You will learn how to add commands to the Quick Access Toolbar; how to rearrange these commands; how to add entire groups or boxes of commands to the Toolbar; how to move the Quick Access Toolbar; how to hide the Quick Access Toolbar; and how to add drop down menus to the Quick Access Toolbar. All you need...
| Tutorial Length (mm:ss): |
8:10 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training using quick access toolbar overview add remove move hide customize items |
General overview of the tabs and options contained within the Excel Options Menu.
| Tutorial Length (mm:ss): |
4:09 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel options menu overview functionality change settings security interface |
This tutorial covers using Excel 2003 keyboard shortcuts in Excel 2007 and also how to use the new system of keyboard shortcuts specific to Excel 2007.
| Tutorial Length (mm:ss): |
3:03 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training keyboard shortcuts excel 2007 |
This tutorial covers using the mini toolbar in Excel 2007 for quick formatting changes and also how to disable the mini toolbar in Excel 2007.
| Tutorial Length (mm:ss): |
3:16 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training minitoolbar mini toolbar disable use format excel 2007 |
This is an overview of the new Live Preview feature in Excel 2007. This feature allows you to view what a formatting change will look like before you finalize that formatting change. This tutorial also shows you how to disable Live Preview in Excel.
| Tutorial Length (mm:ss): |
3:43 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training live preview excel 2007 visual interface disable |
Expand the Name Box and Formula Bar in Excel 2007. This tutorial shows you how to increase the size of the name box and formula bar in Excel 2007 and also how to completely remove or hide the name box and formula bar.
| Tutorial Length (mm:ss): |
1:59 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training expand formula bar name box hide increase size excel 2007 |
Learn how to add blank worksheets, add custom workbooks, rename worksheets and tabs, and also how to add and remove color from worksheet tabs in Excel 2007. This tutorial is a general explanation of how to add and remove worksheet elements from your workbook in Excel 2007 and also how to download pre-made custom worksheets and workbooks from Microsoft Online via the Excel interface.
| Tutorial Length (mm:ss): |
2:51 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training quickly create add rename worksheets tabs add color custom workbook microsoft online |
Learn how to hide almost all of the Excel 2007 interface and window. Some of the parts of the window that you can hide include the: Ribbon Menu, Quick Access Toolbar, Row and Column Headings, Scroll Bars, Sheet tabs, and more.
| Tutorial Length (mm:ss): |
7:55 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training hide excel 2007 interface parts ribbon menu headings tabs quick access toolbar |
Display a tab called the Developer tab in Excel 2007 in order to view more options and commands as they relate to macros, forms, and xml. This is a great tab to have displayed for all advanced Excel users.
| Tutorial Length (mm:ss): |
1:56 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training display developer tab show xml form macro tools excel 2007 |
Learn how to install and remove add-ins from Excel 2007. This tutorial uses Solver and the Analysis ToolPak as examples.
| Tutorial Length (mm:ss): |
3:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training install addins add-ins add ins into excel remove analysis toolpak solver |
This is a quick overview of some of the expanded capabilities of Microsoft Excel 2007. Some of these capabilities include more cells, rows, colors, conditional formats, filter levels, and increased character and formula nesting limits.
| Tutorial Length (mm:ss): |
3:07 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training more rows columns cells characters limits features formats colors excel 2007 version |
This tutorial provides an overview of the new Page Layout view for Excel 2007. This new view type allows you to view exactly what the spreadsheet will look like when printed without having to go to the Print Preview screen. This is a very welcome and useful enhancement for printing in Excel.
| Tutorial Length (mm:ss): |
3:45 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training new features excel 2007 page layout view printing header footer |
Learn how to use Cell Styles and Themes in Excel 2007 in order to make great looking spreadsheets that have consistent formatting elements. This tutorial provides an overview of the built in themes and cell styles that are in Excel 2007 and shows you how to apply these styles and themes. You will also see that themes in Excel 2007 change everything from font styles and colors to the look and app...
| Tutorial Length (mm:ss): |
5:13 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training cell styles themes formatting font colors look feel worksheets |
This tutorial provides an overview of the new Format as Table feature in Excel 2007. This feature is an updated version of what used to be called a List. Some of the features available to you when you format a range as a Table in Excel include the ability to quickly apply sorting, filtering, and remove duplicates from the table. Tables in Excel also automatically update formatting when adding n...
| Tutorial Length (mm:ss): |
5:16 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training overview introduction format as table formatting excel 2007 new features |
This is an overview of the new features for Conditional Formatting in Excel 2007. These new features include Data Bars, Color Scales, and Icon Sets. Also, conditional formatting now allows for an unlimited number of conditional formats to be applied to any given cell.
| Tutorial Length (mm:ss): |
4:14 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training conditional formatting new features data bars color scales icon sets excel 2007 |
This tutorial covers some of the new features in Excel 2007 for sorting and filtering. Some of these new features include increased limits for the amount of sorting and filtering than can be applied to a range of cells as well as the ability to sort by cell color, font, and icon sets.
| Tutorial Length (mm:ss): |
5:39 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training sort filter sorting filtering overview new features excel 2007 |
Learn how to use the new Remove Duplicates feature in Excel 2007 to remove duplicate entries in a list or data set in Excel. This is a great new feature that provides for a lot of functionality and removes the need to use a macro to remove duplicates in Excel.
| Tutorial Length (mm:ss): |
3:01 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training remove duplicate duplicates new feature excel 2007 |
This tutorial covers some of the most useful new file formats available in Excel 2007 and also the two different ways that you can convert your Excel files from pre-Excel 2007 file formats to the new Excel 2007 file formats. This general overview also includes an explanation of when to use the Excel Macro-Enabled Workbook file format.
| Tutorial Length (mm:ss): |
6:13 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training convert files formats excel 2007 spreadsheet |
Learn how to get to the tabs or menus in Excel that allow you to edit charts, graphs, pivot tables, shapes, pictures, and more. These tabs are initially hidden and only appear when you select an item to which the tabs pertain. This tutorial shows you how to insert some of these items and how to access the hidden tabs for these items.
| Tutorial Length (mm:ss): |
2:46 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training options tabs hidden office 2007 interface |
This tutorial provides a general overview of the graphics and effects that are new in Excel 2007 for things such as pictures, wordart, shapes, charts, and graphs.
| Tutorial Length (mm:ss): |
5:15 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training overview better graphics effects excel 2007 pictures wordart charts graphs shapes 3d 3-d |
