Basic Tasks with Charts
Unlike the orderly rows of numbers and labels that fill most worksheets, charts float above your data, locked inside special box-like containers. To take advantage of these chart boxes, you need to understand a little more about how they work.

---

Selecting the Right Chart Type for your Data
In this tutorial I'll show you how to convert your data into powerful information by selecting the right charts for expressing them.

---

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.

---

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.

---

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.

---

Insert Graphics, Pictures or WordArt into an Excel Table or Chart
In this tutorial, you'll learn how easy it is to insert graphics, pictures, or WordArt to your tables or charts. The thing to remember is to do it with taste and a purpose so that your audience is not overwhelmed or distracted from the data highlights that you want to emphasize.

---

What Is a Chart?
A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets since the early days of Lotus 1-2-3.

---

Charting Hacks
This tutorial describe how to make charts in MS Excel, how to use wizard to make a chart and many more techniques for beginner & advance level users.

---

Macros
In this tutorial, you get a chance to practice recording, testing, and playing back macros that you use to automate repetitive tasks required when building and using your Excel worksheets and charts.

---

Excel Tutorial
The tips and tools in these free tutorials include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language.

---

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.

---

Scatter Plot Graphs with Trendline
Scatter plots are used to see the trend of the data set as a whole instead of the sequential pattern of the data.

---

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.

---

Types of Data
In a spreadsheet there are three basic types of data that can be entered.

---

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.

---

CountA Function
This tutorial describes CountA function. This will return the number of entries (actually counts each cell that contains number data OR text data) in the selected range of cells.

---

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.

---

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.

---

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.

---

About Spreadsheets
The basics of spreadsheets, on the other hand, are not always so basic. Even getting data entered into a spreadsheet the way you want can sometimes be a challenge.

---

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.

---

HLOOKUP Function in Excel
HLOOKUP stands for horizontal lookup. The difference between HLOOKUP and VLOOKUP is that HLOOKUP searches for data in rows instead of columns.

---

Excel MODE Function
The MODE function, another of Excel's statistical functions, can be used to find the value that occurs the most often in a range of data.

---

Excel 2007 Pivot Table Tutorial
A pivot table is a great tool for sorting and summarizing the data in a spreadsheet or database file.

---

Printing
Printing allows you to get your work on paper. This is useful both for referencing and sharing your work. Data available on your worksheets can be explored and exploited in various areas including visual presentation or book review.

---

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.

---

Count Function
The function we will discuss is Count. This will return the number of entries (actually counts each cell that contains number data) in the selected range of cells.

---

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.

---

Upper to Lower Case Function "=PROPER()"
The following formula easily tranforms a list of data from Upper to Lower case.

---

Combine Two Different Chart Types for Maximum Impact
In this tutorial, I'll show you how to combine two chart types to better present two different sets of data.

---

Excel MIN Function
Excel's MIN function works much the same as the recently mention MAX function. What the MIN function does is find the smallest value in a given list of data.

---

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 .

---

Formulas in Excel
Formulas are entries that have an equation that calculates the value to display. We DO NOT type in the numbers we are looking for; we type in the equation. This equation will be updated upon the change or entry of any data that is referenced in the equation.

---

Access SOAP Web Services from Excel
If your spreadsheet needs to access constantly updated data, or if you need to access services hosted on another computer, Excel's Web Services support will enable you to get connected.

---

Import Data Directly into Excel
This tutorial relies on Excel's ability to perform web queries, so you'll need Excel 97 or higher. Excel's Web Queries tool transforms simple HTML tables into Excel spreadsheets.

---

Average Function
There are many functions built into many spreadsheets. One of the first ones that we are going to discuss is the Average function. The average function finds the average of the specified data. (Simplifies adding all of the indicated cells together and dividing by the total number of cells.)

---