excel.brainbell.com Tutorials

Create series and fill ranges
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.

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.

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.

Search and Replace
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.

Spell Checking
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.

Automatically move the cell pointer in any direction after pressing enter
If you type a number and then press a direction arrow key, Excel will enter the number and move the cell pointer in the direction of the arrow key.

Calculate the depreciation with SYD function
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.