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 |
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 |
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 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 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 th...
| 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...
| 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...
| 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 |
Create your first formula in Excel with this tutorial. You will learn the basics of what a formula is and how to create one. You will also learn about linking cells, how to change the reference of a linked cell, and the affects of changing the contents of linked cells.
| Tutorial Length (mm:ss): |
7:38 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training introduction first formula excel create syntax how to calculations cell link linking |
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 |
This Excel Chart tutorial shows you how to how to create your first chart in Excel 2007. This tutorial covers how to setup your data so that it can be viewed in a chart; multiple different ways to create a chart; and how to edit the chart after it has been created. This tutorial shows you how to make great looking and useful charts in Excel 2007. Creating charts in Excel is covered step by step...
| Tutorial Length (mm:ss): |
12:05 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training create insert chart graph add data excel 2007 setup edit overview learn how to intro bar column pie |
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 |
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 |
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 |
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 |
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 |
This tutorial covers pretty much everything you need to know about the Formula Bar in Excel 2007. This includes how to enter, edit, and cancel functions and formulas from the Formula Bar as well as how to resize the Formula Bar.
| Tutorial Length (mm:ss): |
5:14 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training formula bar in excel 2007 view functions edit insert formulas resize hide |
This tutorial explains what the order of operations is and how it is used in Excel. This is also sometimes known as PEMDAS for Parenthesis, Exponent, Multiplication, Division, Addition, and Subtraction. The order of operations is very important for mathematical calculations in Excel and needs to be mastered before you can learn more complicated formulas and functions.
| Tutorial Length (mm:ss): |
7:32 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training formulas operators order of operations pemdas parenthesis math mathematical |
Learn how to enter your first function in Excel with this tutorial. Specifically, you will learn the syntax required to enter any function into Excel; the different types of arguments that you can enter into a function; how to find a definition and explanation of a function; and how to reference cells for function arguments. This is a great tutorial for anyone just starting out with formulas and...
| Tutorial Length (mm:ss): |
9:53 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training introduction overview first function excel syntax arguments help |
Create your first formula in Excel with this tutorial. You will learn the basics of what a formula is and how to create one. You will also learn about linking cells, how to change the reference of a linked cell, and the affects of changing the contents of linked cells.
| Tutorial Length (mm:ss): |
7:38 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training introduction first formula excel create syntax how to calculations cell link linking |
Learn how to pull text and numbers from one cell into another cell using cell linking. This technique also works for creating formulas and functions using links to cells that contain numbers. Also, you will learn that you can perform mathematical operations on numbers from other cells without using a function. This is a pretty good ground-work building tutorial for formulas and functions.
| Tutorial Length (mm:ss): |
4:10 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training link linking cell values formulas functions operations operators |
This tutorial shows you how to combine formulas and functions in Excel. This means the formulas and functions will be in the same cell and will be combined so to speak in order to generate output. This example also includes how to output text with formulas and functions to create output in sentence form.
| Tutorial Length (mm:ss): |
6:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training combine formulas functions cell & ampersand concatenate |
This feature of Excel allows you to search for a function like a search engine searches websites; you simply enter some search terms and Excel returns every function similar to your search terms.
| Tutorial Length (mm:ss): |
4:11 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training insert search excel for function quickly |
Insert complicated functions easily and quickly using the Insert Function feature in Excel. This tutorial shows you how to use this wonderful tool in order to enter functions into Excel. This specific example inserts a Present Value function and a Text Function using the Insert Function feature.
| Tutorial Length (mm:ss): |
6:26 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training easy insert functions complex complicated arguments formulas tab |
Learn how to cut, copy, and paste formulas and functions in Excel. This tutorial includes an explanation of absolute and relative cell references. You will learn how to move formulas and functions around a spreadsheet while preventing parts of the formulas or functions from changing or updating based on the new position of the formula or function. This will allow you to quickly add many formula...
| Tutorial Length (mm:ss): |
8:34 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training absolute relative cell references formulas functions cut copy paste move quick fill handle dollar sign f4 |
This tutorial covers proper function usage in Excel. Proper function usage includes separating variables from the functions and formulas in which they are used. Separating the variables from the functions allows you to easily and quickly change the values used in the functions or formulas without having to actually change the functions or formulas themselves.
| Tutorial Length (mm:ss): |
4:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training proper function formulas usage separate separating variables arguments link cells |
Use the new Formulas Tab in Excel 2007 in order to locate functions and to easily insert them into Excel. This feature in Excel 2007 is really helpful when you are not sure exactly which function you want to use or when you are just browsing for functions. Also, entering a function from the Formulas Tab allows you to use the Insert Function feature, which walks you through entering the arguments...
| Tutorial Length (mm:ss): |
4:46 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training functions excel 2007 formulas tab insert |
IF statement syntax and usage overview and introduction in Excel. The IF statement is one of the most important functions in Excel; it is used to make decisions and is part of the logical functions in Excel. This function essentially makes decisions based on input. For instance, if A > B do this.
| Tutorial Length (mm:ss): |
7:53 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training introduction overview IF statement syntax function excel logical condition |
Change text in cells to all upper case, lower case, or the proper case using the functions mentioned in this tutorial. These functions are the UPPER(), LOWER(), and PROPER() functions. The proper function simply capitalizes the first letter of each word.
| Tutorial Length (mm:ss): |
2:47 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training change case text upper lower proper functions formulas |
Use the TODAY and NOW functions in Excel to display the current date and time. This tutorial also covers how to use the number formatting options in order to change the way the date and time are displayed with the TODAY and NOW function in Excel.
| Tutorial Length (mm:ss): |
4:35 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training current todays date time excel today now functions formatting |
This Excel Graph and Chart tutorial shows you how to insert many different types of charts into Excel. This tutorial covers the two basic ways to add all of the different chart types available in Excel into a spreadsheet. This provides you with a good overview of different chart types in Excel.
| Tutorial Length (mm:ss): |
5:40 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training insert add types data graph chart different create excel make visual how to |
This Excel Chart tutorial shows you how to change a Chart’s type after it has already been created in Excel. This will allow you to quickly and easily change charts within a spreadsheet or worksheet without having to recreate them. This tip will save you a lot of time when working with Charts or Graphs in Excel.
| Tutorial Length (mm:ss): |
2:36 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training chart type graph change create excel add use column bar pie pyramid |
This Excel Chart tutorial shows you how to move charts to other worksheets within a workbook in Excel. Specifically, you will learn how to copy a chart to many worksheets; how to move a chart to another worksheet; and how to move a chart onto a chart sheet. This tutorial will save you a lot of time when you need to organize charts within an Excel workbook.
| Tutorial Length (mm:ss): |
5:31 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training move charts worksheet tab separate another chart sheet excel different resize how to |
This Excel tutorial shows you how to very quickly create a Chart or Graph using a keyboard shortcut in Excel. You will learn how to create a chart within the current worksheet or tab and also within a separate chart tab. These shortcuts will save you a lot of time and increase the speed with which you create spreadsheets in Excel.
| Tutorial Length (mm:ss): |
3:32 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training keyboard shortcut graph chart create excel make quickly insert data |
This Excel Chart tutorial shows you how to align a chart in Excel 2007 and later perfectly with any cell, row, or column within the worksheet. This tutorial shows you a feature that makes positioning a chart within the worksheet easy. You will learn how to quickly align, position, and resize, all of your charts evenly and professionally throughout the worksheet.
| Tutorial Length (mm:ss): |
3:21 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training align chart cell row grid column excel resize move position easily |
Learn how to create a drop down menu or list in Excel using the data validation feature. This is the introductory tutorial for creating drop down menus and lists.
| Tutorial Length (mm:ss): |
5:51 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel data validation drop down menu list |
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 Excel sorting tutorial provides an overview of how to sort your data in Excel. This tutorial includes an example of sorting numbers and text. As such, you will learn how to sort numbers from lowest to highest and highest to lowest (ascending and descending order) and how to sort text in alphabetical order and reverse alphabetical order (A to Z and Z to A). Also, this tutorial covers some o...
| Tutorial Length (mm:ss): |
4:42 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training sort excel sorting data spreadsheet alphabetical numerical alphabetically atoz order reverse text numbers |
This Excel sorting tutorial will show you how to sort data based on cell color, font color, and icon set. This will allow you to refine your data by color and increase the ability to analyze the data. This sorting tutorial also briefly covers conditional formatting in Excel, which is tied together with sorting based on font color, cell color, and icon set. This is an advanced sorting technique ...
| Tutorial Length (mm:ss): |
11:06 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training sort data sorting excel cell font color icon set sets conditional formatting format advanced |
This Excel data analysis sorting tutorial will show you how to sort case sensitive data in Excel. This is the same as a regular sort except that it also takes into account the case of the data being sorted. This is a great feature to learn when you need to sort values where upper and lower case letters mean different things.
| Tutorial Length (mm:ss): |
5:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training sort sorting excel case sensitive data analysis order numeric alphabetical |
This Excel tutorial shows you how to import a CSV or text file into Excel. This is a comprehensive overview of exactly how to import and organize data from a CSV or text file in Excel. This tutorial covers everything you need to know to import data from a CSV or text file into Excel and can be understood and followed by Excel users of any level. This is a great walkthrough tutorial with step by...
| Tutorial Length (mm:ss): |
10:16 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training import excel text csv file open files comma separated text value values delimiter delimited comprehensive overview explanation |
This Excel date and time tutorial shows you how to add days, months, and years to a date in Excel. This tutorial covers this complicated subject in a step by step manner and thoroughly explains everything along the way. Adding days or months or years to a date is an often required task and, once you watch this tutorial, will be very easy for you to do. As well, this tutorial covers multiple dif...
| Tutorial Length (mm:ss): |
17:48 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates month day year times calculate compute formula function add |
