MS Excel Tutorials
MS Excel / Getting Started
Learn the techniques of inserting, deleting and renaming worksheets in MS Excel 2007
Added: 2008-09-02 - Author: sara5
MS Excel / Formulas and Functions
Learn how to fill a range with a particular value or formula, what is fill handle, create text and numeric series with AutoFill and create your own AutoFill list.
Added: 2008-08-23 - Author: sara5
MS Excel / Formulas and Functions
In this tutorial, we calculate the depreciation of an investment by using the SYD function, which returns the sum-of-years' digits depreciation of an asset for a specified period.
Added: 2008-08-12 - Author: sara5
MS Excel / Getting Started
Leran how to: automatically move the cell pointer in any direction after pressing enter, change the number of Recent Documents, see headings as you scroll around a report, freeze top row, first column or freeze panes based on selection.
Added: 2008-08-11 - Author: sara5
MS Excel / Getting Started
Spell checking a worksheet can go a long way towards eliminating typos that get by the program's AutoCorrect feature. Learn how to check spells, update dictionary, use custom dictionary and more.
Added: 2008-08-10 - Author: Naveed
MS Excel / Getting Started
You can use the Find and Replace feature to quickly locate every occurrence of a specific string (a series of characters) in a worksheet and then have Excel actually update the cells that it finds with new text or numbers.
Added: 2008-08-10 - Author: Naveed
MS Excel / Charts and Graphics
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.
Added: 2008-07-29 - Author: sara5
MS Excel / Charts and Graphics
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.
Added: 2008-07-29 - Author: sara5
MS Excel / Charts and Graphics
After you select the data to use in a chart, the next step is to select the type of chart. Learn which chart type is suitable for your chart.
Added: 2008-07-29 - Author: sara5
MS Excel / Charts and Graphics
Learn how to print a chart. Depends on the type of chart you've created. You can print embedded charts either with worksheet data or on their own. Standalone charts, which occupy separate worksheets, always print on separate pages.
Added: 2008-07-29 - Author: sara5
MS Excel / Charts and Graphics
Its easy to chart and list that contains two columns you want to graph one with text labels and one with numeric data. But in real life, you'll need to deal with many different types of data that occupy many different configurations on your worksheet
Added: 2008-07-26 - Author: sara5
MS Excel / Getting Started
Learn what Excel is used for, parts of Excel's window, Ribbon user interface, shortcut menus, dialog boxes and how to navigate Excel worksheets.
Added: 2008-07-26 - Author: sara5
MS Excel / Formulas and Functions
Formulas and worksheet functions are essential to manipulating data and obtaining useful information from the Excel workbooks. This tutorial present a wide variety of formula examples that uses many of Excel's functions.
Added: 2008-07-26 - Author: sara5
MS Excel / Getting Started
This tutorial is for you if you've used a previous version of Excel. Here you'll find an overview of what's new and what's changed in Excel 2007.
Added: 2008-07-26 - Author: sara5
MS Excel / Formatting
MS Office styles are pre-selected combination of colors, fonts, and effects that you can apply to a workbook. Use styles to give your work a particular look: professional, playful, or creative.
Added: 2008-07-25 - Author: Naveed
MS Excel