1 / 35

Microsoft Excel

CompuHigh. Microsoft Excel. Fasten Your Seatbelts!. What is MS Excel. Is a spreadsheet program designed to create, organize and analyze data. Things you can do with MS Excel. Design Business Form Create Chart Sort List Prepare monthly sales and expense reports Prepare product inventory

mckile
Télécharger la présentation

Microsoft Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CompuHigh Microsoft Excel

  2. Fasten Your Seatbelts!

  3. What is MS Excel • Is a spreadsheet program designed to create, organize and analyze data.

  4. Things you can do with MS Excel • Design Business Form • Create Chart • Sort List • Prepare monthly sales and expense reports • Prepare product inventory • Make loan payments schedules • Statement of accounts for tuition fees • Computation of Grades

  5. Question #1-3 • Give at least 3 things you can do with MS Excel.

  6. The MS Excel Window at a Glance ROW HEADINGS FORMULA BAR COLUMN HEADINGS STATUS BAR WORKSHEET TABS

  7. Defn of parts COLUMN HEADINGS – are usually letters. ROW HEADINGS – are usually numbers. FORMULA BAR – one of two places where you can enter or edit a cell’s contents STATUS BAR – where informative messages about the cells y0u’re working with appear. WORKSHEET TABS – help you switch between different sheets in a workbook.

  8. Other Definitions Workbook – the file in which you work and store your data. It is a collection of worksheets. Worksheet – is a storage of data you’ve entered having grid columns and rows. - it contains 256 columns and 65,536 rows.

  9. Keyboard Shortcuts • Up, down, left, right • Tab – one cell to the right • Shift + Tab – one cell to the left. • PageUp – One screen up • PageDown – One screen down • Alt + PageUp – One screen to the left • Alt + PageDown – One screen to the right • Ctrl + PageUp – To the active cell in the previous worksheet • Ctrl + PageDown – To the active cell in the next worksheet • Home – Column A of current row.

  10. Keyboard Shortcuts • Ctrl + Home – To cell A1. • F5 or CTRL + G – To a specific cell address in a worksheet (type the cell address)

  11. To Rename a Worksheet • Right click on the sheet tab you want to rename • Click Rename • Type the new name.

  12. Inserting new Worksheet • Right click on the sheet tab where you want to insert a new work sheet and then click. • From the dialog box, select General tab then Worksheet. • Click OK.

  13. Rows and Columns

  14. Selecting a Row/Column • To select an entire column/row, click the Column/Row heading. • To select a non-adjacent column/row, click the heading while holding down CTRL. • To select adjacent rows/columns, click heading while holding down SHIFT key and click the last row. • To copy column width/row height • Select the column/row heading you want the height to copy. • Click Format Painter and drag to select the column/row headings you want to copy to.

  15. Change Row Height or Column Width • Place your mouse at the top boundary of the row heading until the mouse pointer turns into double headed arrow, then drag to resize your row height.

  16. Change column width/row height with the use of Column Width/Row height command. • Select the row. • Click Format menu, then Row. • Select Height. • Type the row height number and click OK. Do the same with your column • Click OK.

  17. Formatting Worksheets

  18. Formatting toolbar • Tool bar used to format a text. • Formatting involves making changes to all contents to make it stand out.

  19. Simple formatting • Changing Font and Font Size • Bold, Italicize or Underline Data • Text Alignments • Changing Font Color • Changing Color Fill

  20. Adding Borders • Select the cells you want to add borders. • Click the arrow on the border button and select available options OR • Select the cell(s). • Click Format Menu then cells. • Select available options at the border tab.

  21. Using Auto Format • Select the cell you want to format • Click Format menu then click Autoformat • Select from different formats to be applied • Click on Options for more modifications • Click OK.

  22. Inserting Blank Cells • Select a range of existing cell where you want to insert the new blank cells. • Click insert menu then cells. • Select any available options • Click OK.

  23. Deleting cells • Right Click on the cell and then click delete. • Select shift cells up then click OK.

  24. Move cell Data • Select the cells containing the data you want to move. • Move your mouse pointer near the Cell border, when it turns into a four headed arrow, click and drag the cell to its new location. Release the button.

  25. Formulas and Functions

  26. Formula • Formula is an equation that performs mathematical operations on worksheet data. • It can perform mathematical operations such as Addition, Subtraction, Multiplication, Division.

  27. Rules for using Formula in Excel • A formula always begins with an equal sign(=) • Mathematical Operators:

  28. Rules for using Mathematical Operations • To control the order of calculation, use Parenthesis. • Excel follows the MDAS rule, so = 3 + 4*5 is 23, while = (3 + 4)*5 is 35.

  29. Entering a Formula • Click the cell you want a formula to be entered • Type = (equal sign) • Enter (type) a formula and press Enter on your keyboard.

  30. FUNCTIONS • The biggest asset of excel is its collection of mathematical, financial, statistical and logical functions. • Format: • FUNCTION NAME(ARGUMENT)

  31. COMMON FUNCTIONS • SUM(num1,num2,…) • Calculates total of all values in parenthesis • AVERAGE(num1,num2,…) • Calculates average of a group of values • MAX(num1,num2,…) • Finds highest value within list • MIN(num1,num2,…) • Returns smallest number in a set • IF(logical_test,value_if_true,value_if_false) • Returns one value if a specified condition evaluates to TRUE, and another value if it evaluates to FALSE.

  32. Autosum • You’ll use this function more than an other. • Used to add cell instantly. • How to use: • Select the range of cells you want to add plus one blank column or row where excel will place the sum of the highlighted column or row • Click the AUTOSUM button.

  33. Charts

  34. What is a chart? • Chart is a visual representation of a selected data on a worksheet. It is a very useful tool to show trends in data, comparison and patterns. • It helps you take numbers and turn them into pictures that definitely answer questions.

  35. Chart Toolbar Buttons Format Chart Area – formats the selected chart item Chart type – changes the chart type for an individual data series. Legend- adds legend to the right of the plot area. Legend- adds legend to the right of the plot area.

More Related