Home » INTRODUCTION TO M/S OFFICE EXCEL 2007

Go Market

Know Your Tax Status

If you've found Saliu's work helpful and inspiring , please donate by click the button below to show your support:

Get more stuff

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

INTRODUCTION TO M/S OFFICE EXCEL 2007

TABLE OF CONTENTS

  1. Definition of excel
  2. Uses of excel
  3. Users of excel
  4. Features of excel environment
  5. Entries: Constant and Formula entries
  6. Fill handle
  7. Extra columns/rows, & work sheet
  8. Transpose
  9. Chart presentation

 

DEFINITION OF MS. EXCEL: Ms. Excel is a spreadsheet application or software that is use for financial management. It consists of rows which stretch across the screen horizontally and columns that divide the screen vertically. Or is a program that is use for mathematical calculation.

 

SPREADSHEET: Spreadsheet is a group names for software that is used for financial management. It is called spread sheet because of the line and the line is gridlines. And grid line is any line that is invisible. Or

Is a group of cells that make up a range.

Cells: is the smallest unit of a spreadsheet.

 

HOW TO OPEN MICROSOFT EXCEL

  1. Boot the computer on
  2. Click on the start button
  3. Move your mouse to all programs
  4. Click on Microsoft office
  5. Click on Microsoft excel

 

USES OF MICROSOFT EXCEL

  1. It is used for mathematical calculation
  2. It is used for financial calculation
  3. It is used for statistical calculation
  4. It is used for project analysis
  5. It is used for data and chart presentation

 

USERS OF MICROSOFT EXCEL

  1. Bankers
  2. Cashers
  3. Accountants

FEATURES OF MICROSOFT EXCEL ENVIRONMENT

These are the bars & button that make up the excel environment.

 

  1. TITLE BAR: This is the first line of the excel screen that display the name of the current file you are working on. Contains minimize, maximize and close button.

 

  1. THE MENU BAR: This is the bar on a excel screen that contain the list of items like home, insert, page layout, formula data etc. and under each menu will have other items on them.

 

  1. THE FORMULA BAR: It displays the contents of the active cell & anything you type in MS-Excel spreadsheet will first appear at the formula bar: it will then be accepted or rejected and any formulas you use in excel calculation will definitely appear at the formula bar.

 

  1. THE NAME BOX: it displays the active cells.

 

  1. CELL REFERENCE: It is a combination of column letters and rows numbers.

 

  1. WORK SHEET: This is the working area of excel screen, it consist of columns and rows: The columns are represented with (A-XFD), while the rows are represented with figures (1-10,48576) Rows

 

  1. CELL POINTER: This is the rectangular box that appears on the cell. It identifies the active cell

 

  1. FILL HANDLE: This is the small box that appear at the lower right concern of active cell, it is used to duplicate figure or text

 

SCROLL BAR: This contains of two small scroll bars: the vertical one and the horizontal one. They are used to view the entire screen of the page.

 

SOME OF THE KEYS THAT MAKES EXCEL ENVIRONMENT UNIQUE

  1. MERGE & CENTER: It is used to center a title within a range
  2. CURRENCY STYLE: It is used to add a currency or dollars sign
  3. PERCENTAGE STYLE: It is used to add a percentage in a calculation
  4. COMMA STYLE: It is used to add comma to numbers that are confusable to recognize. It can sometime be called 1000separator

 

  1. INCREASE AND DECREASE DECIMAL: It is used to increase or decrease decimal point

 

MATHEMATICAL OPERATORS: These are signs or symbols use in mathematical calculation

EXAMPLES:

  1. Addition +
  2. Subtraction -
  3. Multiplication *
  4. Division /
  5. Exponential or raise to power ^
  6. Greater than >
  7. Less than <
  8. Greater than & equal to >=
  9. less than & equal to <=
  10. Equality sign =

CHART: It is a graphic representation of a cell data. Or is summary of calculation or work done. They are two categories of chart

  1. STANDARD TYPES
  2. CUSTOM TYPES

 

STANDARD TYPES INCLUDES

  1. Column charts
  2. Bar charts
  3. Pie charts
  4. XY (scatter) charts
  5. Area charts
  6. Doughnut charts
  7. Ladder charts

 

CUSTOM TYPE OF CHARTS INCLUDES

  1. Area blocks
  2. B & W area
  3. B & column
  4. B & W line – Timescale
  5. B & W pie
  6. Blue pie
  7. Colored lines

MS EXCEL PRACTICAL

 

HOW TO CENTER A TEXT ON M.S EXCEL

  1. Highlight from A down to K or any letter
  2. Click on home
  3. Click on merge and center one after the other

 

HOW TO APPLY CURRENCY STYLE TO A FIGURE

  1. Highlight the figure
  2. Click on home
  3. Click on currency style

 

HOW TO APPLY A PERCENTAGE STYLE

  1. Highlight the figure
  2. Click on home
  3. Click on comma

 

HOW TO INCREASE OR DECREASE DECIMAL POINT

  1. Highlight the figure
  2. click on home
  3. Click on increase or decrease decimal point

 

HOW TO INSERT EXTRA WORK SHEET

  1. Click on home
  2. click on insert
  3. Click on insert sheet
  4. Or go to sheet bar, click on insert worksheet

 

TRANSPOSE: It is used to put a text that is vertical changed to horizontal aligned

 

STEPS:

  1. Highlight the text you wish to align
  2. click on home
  3. Click on copy, then highlight the area you want align it
  4. click on paste
  5. Click on paste special
  6. Click on transpose
  7. click on ok

 

HOW TO INCREASE THE WIDTH OF A COLUMN AND THE HEIGHT OF A ROW

  1. By manual process
  2. By automatic process

 

MANUAL PROCESS: Click on the edge of the grid lines and drag to a direction of your choice

 

AUTOMATIC PROCESS: Right click on the edge of the row or column grid line then click on width or height and type in the width or height and then ok

 

STATISTICAL FUNCTION

These are the signs or symbols use in excel calculation

EXAMPLES

1. SUM: It is used to find the total in the range of numbers

 

HOW TO USE YOUR SUM FORMULA

=SUM (click on the first number and drag to number) press enter

SUM (click on the first number and plus (+) or subtract () and click on the second number, plus (I) and third number etc) then press your enter key.

 

2. MAX: It is used to find the highest value in a set of numbers

 

HOW TO USE YOUR MAX

=MAX (click on the first drag to last number) press enter key

 

MIN: It is use for finding the smallest or the lowest value in a set of numbers

 

HOW TO USE YOUR MIN

= MIN (click on the first drag to the last number) press enter key

STDEV: It is used to find the standard deviation in a range of numbers

 

HOW TO FIND STANDARD DEVIATION IN A RANGE OF NUMBERS

 

= STDEV: (click on first number drag to the last number) press enter key

 

VARIANCE: It is use to find the variance in a range of numbers

 

HOW TO FIND VARIANCE IN A RANGE OF NUMBERS (VAR)

=VAR (click on the first number drag to the last number) press enter key.

 

COUNT: It is use to count the actual number that makes up a range

 

HOW TO COUNT

= COUNT (click on the first number drag to the last number ) press enter key.

 

AVERAGE: It is use to find the mean values in the range of numbers

 

HOW TO FIND AVERAGE:

= AVERAGE (click on the first number drag to the last numbers press enter key

 

SQRT: It is use to find the square root of a number

 

HOW TO FIND SQUARE ROOT OF A RANGE OF NUMBERS (SQRT)

Add the number with your sum formula: then anything you find as your answer, use it to find your square root.

= SQRT (click on the Total Answer) press enter key

 

The same thing with LOG, which is use to find the logarithm of a number

=Logs (click on the Total Answer) press enter key

 

ROUND: It is used to convert a number to any decimal point

 

Example: to convert this a number use

= Round (click on the number then apply your comma sign then type in the decimal number you need e.g 3 or 2 decimal point then) press enter on your key board.

 

HOW CALCULATE STUDENT REMARK ON EXCEL

Note: the formula to use is = if (C7>60,”pass” “Good”)

Then press enter on your key board

 

HOW TO CREATE A BOARDER OR TABLE

  1. highlight the numbers of columns and rows you counted
  2. Click on home
  3. Click on format
  4. Click on format cell
  5. Click on boarder
  6. Go to line style
  7. Click on the thick line
  8. Click on inside and outline
  9. Click on ok

 

HOW TO APPLY ALIGNMENT OT YOUR BOARDER

  1. Highlight the area you want to apply alignment
  2. Click on home
  3. Click on format
  4. Click on format cell
  5. Click on alignment
  6. Go to orientation and click on 90 or the decree of your choice
  7. Click on ok

 

HOW TO DELETE A BOARDER

  1. Highlight the are you want to delete either column or row
  2. Click on home
  3. Click on format
  4. Click on format cell
  5. Click on boarder
  6. Click on none
  7. click on ok.

 

HOW TO REMOVE ALIGNMENT

  1. Highlight the boarder you want to remove alignment
  2. Click on home
  3. Click on format
  4. Click on format cell
  5. Click on alignment and type in O decree
  6. Then click on ok

HOW TO SORT FILE OR DATA

There are two ways of sorting file or data

  1. ASSENDING ORDER: Means arranging a data from A-Z.
  2. DESCENDING ORDER: Means arranging a data from Z-A.

HOW TO SORT FILE OR DATA

  1. Highlight the text
  2. Go to home
  3. Click on sort &filters
  4. Click on sort A to Z or
  5. Click on sort Z to A

 

FIRST CHAT

HOW TO PLOT A CHART

  1. Highlight the two columns that carries the information of which you want to use and plot the chart (highlight the first one then hold your control key to be able to highlight the second and simultaneously)
  2. Click on insert
  3. Click on pie chart
  4. Choose the one of your choice
  5. Click on layout
  6. Click on chart title
  7. Click on above chart
  8. Then type the title of the chart (eg. Monthly salary of a company)
  9. Click on data labels
  10. Click on outside end
  11. N/B: to change the location of the chart
  12. click on design
  13. click on move chart
  14. click on as new sheet
  15. click on ok
  16. choose a new sheet
  17. Then apply colors to the figures and names & bold.

 

HOW TO APPLY BACKGROUND

Click on the chart area

Click on format

Click on shape fill

Click on texture

Choose the background of your choice

 

2nd CHART

HOW TO PLOT A COLUMN CHART

  1. Highlight the information you are ask to use and plot the chart
  2. Click on insert
  3. Click on column chart
  4. Choose any chart of your choice
  5. Click on layout
  6. Click on chart title
  7. click on above chart
  8. Give your chart a title name (Students Record)
  9. Click on data labels
  10. Click on outside end
  11. Click on gridline
  12. Click on primary horizontal gridline
  13. Click on none
  14. Click on axis title
  15. click on primary horizontal axis title
  16. click on title below axis
  17. then type (Students Names)
  18. Click on axis title
  19. click on primary vertical axis title
  20. Click on vertical title
  21. Then type (Students Scores)
  22. Click on design
  23. click on move chart
  24. click on new sheet.
  25. Then apply colors to the names, figures and title.
  26. Apply background

 

HOW TO CALCULATE ON GRAPH

Note that your X-value will be giving to you and if you are ask to find Y, the formula for Y will be giving Example: y=3*X+2

 

Note after typing the formula giving to 10y by y, and any where you sees X you need to click on any of the column number of X

 

X -2 -1 0 1 2 3 4 5
Y

 

HOW TO PLOT A GRAPH

  1. Highlight the X&Y border
  2. Click on insert
  3. Click on scatter
  4. Choose the graph of your choice
  5. Click on layout
  6. Click on chart title
  7. Click on above chart
  8. Click on title and type in the Name of the Graph
  9. click on data labels
  10. Choose the direction of your choice eg. (Right direction)
  11. Click on Gridlines
  12. Click on primary horizontal gridlines
  13. click on none
  14. N/B: to change the location of the graph
  15. click on design
  16. click on move chart
  17. click on as new sheet
  18. click on ok
  19. Apply colors to the figures & title & bold

 

HOW TO APPLY GRAPH BACKGROUND

  1. Click on the graph area
  2. Click on format
  3. Click on shape fill
  4. click on texture
  5. choose the texture of your choice

Next step


Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Our Posts

Space for Direct Advertisment

Please link to us on:

SE-Concept Blog

Advertise Here!

Translate »
Copy Protected by Chetans WP-Copyprotect.