1 / 9

Introduction to Excel

Introduction to Excel. ICL and MSO. Excel Basics. Excel is a spreadsheet application and looks similar to a table An Excel document is called a Workbook A new Workbook contains a default number of 3 Worksheets A Worksheet is where you work Worksheets can be divided using page breaks

raheem
Télécharger la présentation

Introduction to 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. Introduction to Excel ICL and MSO

  2. Excel Basics • Excel is a spreadsheet application and looks similar to a table • An Excel document is called a Workbook • A new Workbook contains a default number of 3 Worksheets • A Worksheet is where you work • Worksheets can be divided using page breaks • There are 2 types of sheets in Excel: Worksheets and Chart Sheets • To move cells press Tab, Shift + Tab, or Enter

  3. Quick Access Toolbar Excel Window Office Button Columns—Characterized by Letters Cell –the intersection of a row and column Example: L14 Rows—Characterized by Numbers Sheet Tabs (default 3 worksheets) Scroll Bars Views-Normal, page layout, & page break

  4. Excel Basics • 10 is a Row • A is a Column • A10 is a Cell • One can create charts/graphs in Excel • Column, line, bar, pie, area, scatter, and others • Charts/Graphs can appear in the same worksheet as the data or in a separate sheet called a chart sheet

  5. Excel Basics • A range is a selection of cells • There are two types of ranges • Adjacent—cells by one another • Example: A1:G11 • Nonadjacent—cells that are separated by other cells • Example: A1:G11; I1:J11 • To select a nonadjacent range select A1:G11 press and hold down control and select I1:J11

  6. Excel Formulas • Think of Excel as a giant calculator • Formulas always start with an = sign • + is used for addition • - is used for subtraction • / is used for division • * is used for multiplication • If I wanted to add A4 and B6 together I would click in the cell where the total should appear and I would enter =A4+B6 • I can type the information • OR I can press equal click A4, click +, click B6, press enter

  7. Excel Functions • Functions simplify formulas • In this class, we will work with the following functions: SUM & AVERAGE • Click the cell where a function needs to be calculated • Home Tab  Editing Group  Sigma Click SUM or AVERAGE  Highlight your range (Excel automatically highlights what is believed to be the range, but you need to double check it) • Excel Selected Changed

  8. Excel Formatting • AutoFill allows one to copy selections from one cell to another. Examples: • Formulas • Functions • Series • One can format cells multiple ways we will cover the following: • Home Tab  Number Group  Launch the Number Group dialogue box • Decimal • Currently • Thousands separator

  9. Excel Formatting • One can add borders to cells • Home Tab  Font Group  Borders • One can add fill to cells • One can change the font size and color of cells • One can indent content of cells • Home Tab  Alignment Group  Decrease/Increase Indent • One can rename sheet tabs • One can add and delete rows and columns, (right click the column or row selector) • When printing, one can set the print area to only print certain cells instead of the entire worksheet • One can also choose a print setting to print column and row headings (letters and numbers) • Page Set Up Dialogue Box  sheet tab  Row and Column Headings

More Related