Load an XML Document ito Excel
If someone sends you an XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.

---

Basics
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks. You can also view the Excel 2003 Video Tutorials as they come on line.

---

Excel Worksheet Help
This is the thing about spreadsheet programs like Excel - there are just so many tools and features it's hard to keep track of them all. If you've been using Excel for a while you know how to do such things as enter the data and add a formula or function.

---

Create Excel Spreadsheets Using Other Environments
Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to create .xls files directly from other programs.

---

Excel 2007 Data Entry Form
If you ever created a database file in a spreadsheet program like Excel you'll know that it does a great job. Whether you have a contact list for an organization, an inventory of parts, or a library catalog of books or DVDs, Excel has the tools to make the job simple and straightforward .

---

Check boxes in Excel
Unknown to many excel users, you can easily set up check boxes in Excel. You can use these check boxes to total a list of data by selecting various boxes. The following Excelbuddy.com video demonstrates what this tutorial will accomplish.

---

Address Data by Name
Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy. Excel uses the same technique for defining named cells and named ranges: the Name box at the left end of the Formula bar.

---

Protecting Excel 2007 Data
The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified.

---

Filter Texts and Dates in Excel
Learn how to filter in Microsoft Excel 2007. The filter utility is used to extract specific data out of big tables.

---

Save To SpreadsheetML And Extracting Data
Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information.

---

Creating Charts and Graphs in Excel
Tutorial videos teaching you all the basics of how to make a chart in MS Excel, includes: Adding a chart, setting the legend, formatting axis and adding data labels.

---

Excel 2007 RIGHT Function
Another Excel function, similar to the LEFT function, which can be used to remove unwanted characters from imported data, is the RIGHT function.

---

Excel's Builtin Features
Data validation makes it easy to specify rules your data must follow. Unfortunately, Excel insists that lists used in data validation must appear on the same worksheet as the data being validated. Fortunately, there are ways to evade this requirement. In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call.

---

Microsoft Excel 2003 Help and Tips
Microsoft Excel 2003 tips and tricks for developing spreadsheets (worksheets). Adjusting macro security, tweaking Excel 2003 startup, customizing Excel spreadsheet views, and more.

---

Multiply
Multiplication is essential in Excel. Luckily it is extremely easy. To multiply numbers or cells in Excel, we must use a basic formula. All Formulas in Excel begin with =

---

Editing an Excel Worksheet Tutorial
This Free Editing an Excel Worksheet Tutorial will help you learn to use the Microsoft Excel 2003 Spreadsheet Program. This is part two of the Free Excel Tutorials and will show you how to edit information in worksheets.

---

Getting to know Excel 2007
The Excel 2007 interface has been completely revamped and redesigned compared to the older versions of Excel we are all used to.

---

Excel 2003 Keyboard Shortcuts
This Excel 2003 Keyboard Shortcuts tutorial lists all of the shortcuts for Excel that can be performed on the keyboard. Learning these will save you lots of time in building Excel spreadsheets.

---

Excel 2000 Tutorial
Learn the basics of Excel 2000 and more including Customizing Excel.

---

How to Create Simple Pie Charts Using Excel
In this tutorial, I use data from a fictitious company called Celeste Cosmetics Co. Below please find a snapshot of the company and the data that will be used.

---

Creating Charts in Excel 2007
A chart (also known as a graph outside Excel circles) is a way to present a table of numbers visually. The visual display allows you, for example, to quickly examine trends or compare the relative contributions of various items. Excel provides you with the tools to create a variety of charts.

---

Data Entry
As you are aware, when Microsoft Excel starts, it opens a workbook made of three worksheets. A worksheet is simply made of cells that are patiently waiting for you to enter data.

---

Conditional color formatting in Excel
Let's say you are making an Excel table where you shall input how many hours did you work for everyday. And you would like to make designation with colors. Red number for less than 8, blue for 8 and green color for more than 8. Did you know you can make that process automatic in MS Excel? Here's how.

---

Create Spreadsheets using SpreadsheetML
While exporting spreadsheets as XML is useful, Excel also lets you import information this way, letting you create spreadsheets using SpreadsheetML.

---

Selecting Cells in Excel
Excel 2003 Video Tutorial explains how to select cells in Excel 2003 spreadsheets.

---

Create a drop down list in Excel 2007
Drop down lists in Excel enable you to restrict the user to insert only specific data inside cells by using a user friendly interface. This tutorial shows you how to create such a drop down list inside a cell, from a given list written on the worksheet.

---

Financial Calculation Software, a Snap with MS Excel
There is more to Microsoft Excel than simple math. It has more than 50 functions that can be set up, in effect allowing you to do a certain degree of programming. This article explains how to create and use a financial calculator in Excel, and discusses some of those functions. TOC: Financial Calculation Software, a Snap with MS Excel; Calculating the payment on a loan; Usage of function PMT; A simple spread sheet to calculate PMT.

---

VLOOKUP function
VLOOKUP in excel stands for vertical lookup. This simple function is extremely useful if you have large lists of data. With this function, you can easily search through a list of data and match specific criteria.

---

COUNTIF Function - Cell Counting Tips
There are various methods used to count cells in Excel. We will be utilizing the COUNT function.The COUNTIF function is used to count cells in a range given a certain criteria.The examples listed below show how to properly use the COUNT function in Excel. In every example, the data range that will need to be changed is titled range

---

Data Validation - Dependent Lists
This tutorial will show you how to create a dependent list on Excel. This technique is extremely useful when categorizing data. In the example below, the user will select the State in cell A3. Cell B3 (City) will pull a city based off of the users selection.

---

Work with Pivot Tables in Excel
PivotTables allow you to pivot data using drag-and-drop techniques and receive results immediately. PivotTables are interactive; once the table is complete, you very easily can see how your information will be affected when you move (or pivot) your data. This will become patently clear once you give PivotTables a try.

---

Data Analysis With Charts
Charts are used to analyze data graphically. Good created and formatted charts can help people and businesses make decisions based on the impact that their images provide to the users. Microsoft Excel is equipped with the Chart Wizard that allows you to create and format a chart to suit almost any scenario or need.

---

Working with Excel 2007 Files
This tutorial discover the new Excel interface that provides you with the right tools at the right time. In most Windows programs, you see menus and toolbars from which you select your options.

---

Printing Workbooks in Excel 2007
This tutorial shows you a number of Excel tools you can use to improve your document layout, including headers, footers, page orientation, and margins.

---

Conditonal Formatting - Shading Alternate Rows
This Excel function is very useful when dealing with long lists of data. However, it is extremely easy to use once you know the simple formula.

---

How to Create a Simple What If Scenario in Excel MS
A step by step tutorial with screenshots on how to do scenarios with different factors in excel.

---

Excel Statistical Functions - Countif,Average, Counta, Sum
Learn how to use the basic statistical function in MS Excel. Easy tutorial videos, with many examples and demonstrations,

---

Getting Started With Excel
By following the steps outlined in this tutorial, a basic understanding of Microsoft Excel should be achieved allowing basic requirements of reports and course projects assigned by the Department of Finance at The University of Arizona.

---

Excel Formulas Simply Explained
Learn the basics of formulas in Excel: how to write and use them, using absolute and relative references, and using the fill handle with formulas.

---

Excel 2007 SUMIF
Two of the most useful functions available in Excel are the IF function and the SUM function.

---