Introduction to the Main Features and Benefits of Excel
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 might want or need to use Excel.
| Tutorial Length (mm:ss): |
13:46 |
Sign Up to View Tutorials
|
| Downloadable Files: |
Yes |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training benefits of using excel overview introduction features |
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 to text within a cell in Excel.
| 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 to change the formats of data to represent dollars, dates, time, percentages, and more; how to merge cells; how to wrap text within a cell and much more.
| 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 the table; add a Total Row to the table in order to perform quick calculations in the data; quickly change the entire format, look, and feel of the table; perform sorting and filtering on the table; and much more.
| 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 that might just save you some time.
| 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 functions; locating functions; searching for functions; using Excel to help you enter complicated or new functions; and more. This is a great tutorial for those just starting out in Excel.
| 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, remove elements from the chart, change the chart title, and adding some basic effects and formatting to charts.
| 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 workbooks and worksheets, though opened through Excel, are downloaded from the internet and so do require an active internet connection.
| 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 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 to text within a cell in Excel.
| 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 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 to change the formats of data to represent dollars, dates, time, percentages, and more; how to merge cells; how to wrap text within a cell and much more.
| 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 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 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 that might just save you some time.
| Tutorial Length (mm:ss): |
5:36 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training autosum auto sum add average count numbers functions excel |
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 the table; add a Total Row to the table in order to perform quick calculations in the data; quickly change the entire format, look, and feel of the table; perform sorting and filtering on the table; and much more.
| 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 |
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 functions; locating functions; searching for functions; using Excel to help you enter complicated or new functions; and more. This is a great tutorial for those just starting out in Excel.
| 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, remove elements from the chart, change the chart title, and adding some basic effects and formatting to charts.
| 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 workbooks and worksheets, though opened through Excel, are downloaded from the internet and so do require an active internet connection.
| 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 |
