Microsoft Excel 2007 Tutorial

Microsoft Excel 2007 Tutorial

• 1.
  Tutorial For MicrosoftExcel 2007 Dhafin Year 7
• 2.
  How to Runthe ProgramHow to Run the Program  Turn on the computerTurn on the computer  Log-inLog-in  Click and open StartClick and open Start  Search and click All-Search and click All- ProgramsPrograms  Search Microsoft OfficeSearch Microsoft Office  Click Ms ExcelClick Ms Excel
• 3.
  Sheet Tab Status Bar ZoomControl Scroll Bar Formula Bar Name Box Quick Access Toolbar Office Button Column Letters Ribbon Page View Cells E.x.c.e.l P.r.i.m.a.r.y T.o.o.l.s
• 4.
  •Home Excel •Save: Tosave files that Written •Undo: To go back from an action •Redo: To move forward from an action •Print: To print the file •P. Preview: To check the file before print •Clipboard •Cut: To erase object •Copy: To copy/duplicate file •Paste: To Paste an object •F. Painter: To redo the color •Undo: To go back from an action •Redo: To move forward from an action •Justify Up: Center up writing •Justify middle: Normal •Justify Down: Low writing •Ab >: Writing perfection (diagonal) •Align Left: At left writing ruler •Justify: Center writing ruler •Align Right: Right Writing ruler •Decrease indent: To Choose which side of ruler writing (go back) •Increase indent: To Choose which side of ruler writing (Go forward) •Font •Font: To select letter styles •Bold: To bold a Letter •Italic: To make a letter diagonally to right •Underline: To underline a Word •Size: To maintain the letter size •A+: To add letter size •A-: To subtract letter size •Font color: To choose the letter color •Fill color: To fill the column •Format cells: To check the cells (maintain) •Alignment •Number •Choose how much values in cell are displayed, Accounting, Percent, Comma style, Decrease/Increase Decimal Points. •Cells: •Insert, Delete Format Cells •Styles •Conditional Formatting of cells, format data ad table, format cells with pre defined styles •Editing •Functions •Fill •Sort & Filter Excel ToolbarsExcel Toolbars
• 5.
  Excel Insert ToolbarExcelInsert Toolbar • Tables • Create table to manage data, use pivot table or pivot chart • Illustration • Pictures, Clip art, Shapes, Smart art • To insert, from file, and add inside the data • Charts • Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Bubble, Donut, Radar. (Graph Types) • Links • Hyperlink: To connect other data to another. Create link to web page, picture, email, address, or program • Text • Text box, Header/Footer, Signature Line, Object, Symbol
• 6.
  Page LayoutPage Layout Its for checking the page, (Portrait/Landscape)Its for checking the page, (Portrait/Landscape)  Print Preview: checking before printingPrint Preview: checking before printing  Themes: to organize which color font or effectsThemes: to organize which color font or effects  Page Setup: Margins, Orientation, size, print area, Breaks, background, printPage Setup: Margins, Orientation, size, print area, Breaks, background, print titlestitles  Scale (fitting): Width of paper, Height of paper, and Scale for the paperScale (fitting): Width of paper, Height of paper, and Scale for the paper  Sheet Options (View) Gridlines: For calculating paper to paperSheet Options (View) Gridlines: For calculating paper to paper Headings: To Attach font at the title barHeadings: To Attach font at the title bar  Arrangement: To check pictures file that can be pushed to back, or front ifArrangement: To check pictures file that can be pushed to back, or front if crash, align, selection pane, also can group pictures to one, and rotate.crash, align, selection pane, also can group pictures to one, and rotate.
• 7.
  FormulasFormulas  To typeanswers, formulas of numberingTo type answers, formulas of numbering (accounting, general, etc.)(accounting, general, etc.)  Auto sum, Insert function, can be fromAuto sum, Insert function, can be from recently used, logical, text, date & time,recently used, logical, text, date & time, Lookup & reference, Math & Trig(ometry)Lookup & reference, Math & Trig(ometry)
• 8.
  DataData  To getdata from file, check data, or others (sort filter pivot-table etc)To get data from file, check data, or others (sort filter pivot-table etc)  External data, refresh data, connections, properties, edit linksExternal data, refresh data, connections, properties, edit links  Sort A^Z, Z^A, Filter , clear, reapply, advanced. Data Tools, text toSort A^Z, Z^A, Filter , clear, reapply, advanced. Data Tools, text to columns, remove duplicates. Group, un group, subtotal.columns, remove duplicates. Group, un group, subtotal.
• 9.
  ReviewReview •Spelling: To Autocorrectsome wrong alphabets, or grammars. •Research: To search from file, or website •Thesaurus: Grammar work •Translate: To Change word from another language •New Comment: To add comment •Delete: To delete the comment •Previous: To go back •Next: Forward>> •Comments: Show/Hide, Show all, Show ink
• 10.
  ViewView  To insertadditional things (ruler, grid view, etc)To insert additional things (ruler, grid view, etc)  Normal, page layout, page break preview, custom view, full screen,Normal, page layout, page break preview, custom view, full screen, formula bar, headings, zoom xxx%, zoom to selection, new windowformula bar, headings, zoom xxx%, zoom to selection, new window
• 11.
  How to MakeTable DataHow to Make Table Data So first, click one of the column, then spread them until it went blue, (make as you needed). Then, click Format, and choose Cells (Ctrl+1) Then Click number, and choose accounting After that, click border and click outline and inside. Click ok, and see the tables Write Something The evidence, with some formulas