|
|
|
|
Tutorial by
functionx.com
In the previous lessons, we have been referring to a group of cells as a list. The group of cells that constitute a spreadsheet is referred to as sheet and those cells are spread all over it. For this reason, a document whose main purpose is to present a list as a group of cells is referred to as spreadsheet.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
16 Times
|
|
|
|
|
|
Tutorial by
functionx.com
We have seen that a document in Microsoft Excel is made of one or more worksheets. In reality, a document in Microsoft Excel is called a workbook.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
18 Times
|
|
|
|
|
|
Tutorial by
http://www.functionx.com
In Lesson 2, we saw that you could use a column as a basis to freeze a group of cells on a vertical line and prevent them from moving to the left or right when you scroll the other section.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
14 Times
|
|
|
|
|
|
Tutorial by
comp-tipsandtricks.blogspot.com
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.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
14 Times
|
|
|
|
|
|
Tutorial by
quantunet.com
How To Use The Product Function In Excel
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
11 Times
|
|
|
|
|
|
Tutorial by
quantunet.com
How To Apply Conditional Formatting In Excel
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
13 Times
|
|
|
|
|
|
Tutorial by
quantunet.com
How to paint conditional formatting:
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
12 Times
|
|
|
|
|
|
Tutorial by
mstipsandtricks.com
In this tutorial, you will learn how to work with consolidated data.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
8 Times
|
|
|
|
|
|
Tutorial by
mstipsandtricks.com
In this tutorial, you will apply formatting options to cells and prepare the sheet for printing.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
13 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
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.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
10 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
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.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
23 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
Merging cells in an Excel spreadsheet is extremely useful. By merging cells, you can greatly enhance the look and feel of a spreadsheet.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
26 Times
|
|
|
|