MS Excel Introduction
Microsoft Office Excel is an advanced computer-based spreadsheet, which is used to store data in columns and rows which can then be organized and/or processed.
|
MS Excel Exploring
Once the Microsoft Excel is launch, you can directly use it by entering data or you can choose to open the existing Excel file. Below are the step-by-step guides:
|
MS Excel Copy & Paste
What is the Mystery Concept behind the Copy and Paste?
Yes, it�s clipboard. and�What is the relationship between clipboard and copy and paste?
|
MS Excel Toolbar
Excel formatting toolbar normally located near to the top of your screen as shown here. The toolbar icons have a specific purpose that can change the outlook of your spreadsheet when you apply formatting to it.
|
MS Excel Formula
A formula is an equation that performs operations on worksheet data. Excel formula can perform mathematical operations
|
MS Excel Chart
Here is the step-by-step guides to create an outstanding Excel chart
|
MS Excel Template
Here is your definite solution for your Excel template questions!!
When working with spreadsheets you may want to use the same layout or design.
|
MS Excel Worksheet
Excel worksheet and workbook protection feature allows you to protect your file being open by unauthorised person.
|
MS Excel Formatting
Excel conditional formatting allows you to apply different formatting options, such as color, to a cell or cells based on the data in the cell(s).
|
MS Excel IF Function
The Excel IF Function checks a condition that must be either true or false. If the condition is true, the function returns one value; if the condition is false, the function returns another value.
|
MS Excel CHOOSE Fun
The Excel Choose function allows you to select a value from a list of up to 29 items.
|
MS Excel Pie Chart
Here is the step-by-step guide to create an outstanding Excel pie chart:
|
MS Excel AND Function
The Excel AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.
|
MS Excel MIN Function
The Excel MIN function is used to find the smallest value in the selected range of cells or a given list of arguments. Text and blank entries are not included in the calculations of the MIN function.
|
MS Excel MAX Function
The Excel MAX function is used to find the largest value in the selected range of cells or a given list of arguments. Text and blank entries are not included in the calculations of the MAX function.
|
MS Excel COUNT Fun
Excel COUNT function will return the number of entries (actually counts each cell that contains number data) in the selected range of cells.
|
MS Excel AVERAGE Fun
The Excel AVERAGE function can be used to calculate the average, or arithmetic mean, of values in a selected range of cells.
|
MS Excel OR Function
The Excel OR function returns TRUE if one condition are TRUE. It returns FALSE if all of the conditions are FALSE.
|
MS Excel RAND function
The Excel RAND function will generate a random number in Excel that is greater than or equal to 0 and less than 1.
|
MS Excel Drop Down List
Microsoft Excel 2003 allows you to build your own Excel drop down list!Well, this feature is really cool
|