Learn Microsoft Excel 2007 Step By Step
Direct Download Tutorial PDF Files in One Single Click.
Microsoft Excel is a spreadsheet application program offered in the Microsoft office software package. This program allows you to perform calculations and use graphics tools, pivot tables and a macro programming language called VBA. In addition, Excel can also be used to create charts and graphs.
COLUMN
The vertical lines in a sheet are known as a column. There is a total column in a sheet is 16384. The default width of a column is 8.43 point.
ROW
The horizontal lines in a sheet are known as a row. There are total 148576 rows in a column. The height of a row by default is 15 point.
WORKSHEET
Workbook.
While opening MS excel the application screen that appears with some tools and 3 sheets by default to perform different calculations. CELL
intersaction of row and column is called the cell.
Cell = Column*Row
Grid Lines.
The line which separate rows and columns are called grid lines. It is a nonprintable area by default.
GOAL SEEK.
Goal seek is an option through which we can obtain any target value by changing other data.
Sub Total.
subtotal is an option through which we can sort out the value depending on the condition.
AUTO FILL
Sub Total.
subtotal is an option through which we can sort out the value depending on the condition.
AUTO FILL
Autofill is an option which helps the user to automatically fill the above data underneath.
FILTER
RIBBON
he ribbon, a panel that houses the command buttons and icons, organizes
commands as a set of tabs, each grouping relevant commands. Each
application has a different set of tabs which expose the functionality
that application offers.
AUTOSUM
The autosum button allows you to quickly insert the sum function.It is
located in two places on the ribbon. On the right end of the "HOME" tab
in the editing section, and on the far left of the "FORMULA" tab. Select
the cell where you want to put the total and then click on the autosum
button. Excel will insert the sum function and take a guess as to what
cell range you'd like to sum by listing the first and last cell in the
sum, separated by a colon.Check to make sure the cell range is correct,
then press enter to accept the function.
AUTO CALCULATE
Excel will automatically perform the calculation on a set of cells that you
select and display the results on the status bar in the bottom right of
your window. The default calculation is the sum function, but you can
change the calculation by right-clicking or control+clicking(MAC) on the
auto calculate the result.
PIVOT TABLE
A pivot table is a great reporting tool that sorts and sums independently
of the original data layout in the spreadsheet. It is an interactive
representation of a data table. One can rearrange the data and choose
what to display and what to hide.The best way to find out what a pivot
table can do is to create one.
CHARTS
A full discussion of excel"s many charting options is beyond the scope of
this handout. However, it is fairly straightforward to create a simple
chart using the chart wizard. Just highlight the data you wish to base
your chart on and click on the Insert tab and you will see the available
charts there. When you click on a type of chart, you will be prompted
to select a subtype of the chart. Once you have done so, the chart will
appear on your spreadsheet. Three additional tabs will also appear on
your ribbon, through which you can alter your chart by adding titles,
changing data points and many other options.
NAME MANAGER
You can use name manager to name a group of cells, and therefore only type
one name when you want to perform a calculation with that group. This
can be useful when you are performing many different calculations on the
same set of numbers, especially when you want to perform these
calculations across multiple sheets. To do this, select the cells you
would like to name and name them in the "name box" next to the formula
bar. You can then perform any function on these cells by just typing the
name you gave the cells instead of referencing the cell numbers. You
can edit the names you gave the cells and change which cells they refer
to by clicking on "name manager" on the "formula" tab.
FUNCTIONS
excel has created hundreds of functions that
prevent
you from having to write out complex or repetitive formula yourself.
Functions can be inserted by clicking on the function symbol to the left
of the formula bar. Functions can also be inserted by clicking on the
"insert function" button on the "formula" tab or jumping to any of the
subcategories of functions on that tab. Yet another way to insert a
function is to type the equals sign into a cell and begin to type the
name of formula. A drop-down menu will appear, from which you can select
the formula.
FORMULAS
Select the cell that the formula result is going to be displayed in. The
formula can be constructed in the formula bar or typed directly into the
cell in which you want the formula to begin. You must always put the =
sign before a formula, as this is how excel recognizes what you are
entering into a formula. Autofill helps you fill in formula quickly once
you have constructed one in a cell. In order to autofill, select the
cell with the formula.
Cell References
there are two different types of cell references
Cell References
there are two different types of cell references
relative cell references
Cell references that change when the formula is autofilled into different cells.
absolute cell references
If you don't want a certain part
of your cell reference to change when you copy the formula to a new
cell, you need to put a $ in front of the row and /or column part of the
reference.
Microsoft Office Access 2007 step by step Tutorial
For Downloading the files Please Click on "Direct Download Link."
For Downloading the files Please Click on "Direct Download Link."
| Office Excel 2007 Step by Step | Direct Download. |
End of Post
No comments:
Write comments